Last post Feb 06, 2017 10:30 AM by satyam khare
Dec 30, 2012 05:18 PM|hady_matrix|LINK
I have a web application published to remote server. user use it in case of internet existance.
there is another published version on local pc "sql server express 2008" . in case of there is no Internet connection ,user will use it from local pc.
how can i update remote database with new data of local database when there is no internet connection?
Dec 30, 2012 08:42 PM|wmec|LINK
You have to make sure the connection is fine to connect to the remote DB.
Dec 31, 2012 05:50 AM|hady_matrix|LINK
we need this method because internet problems and may be not available sometimeso we need to update remote database"central DB" with new data
Jan 01, 2013 10:17 PM|wmec|LINK
Try the way to copy both .mdf and .ldf files from that remote server and then attach both to your local DB.
Jan 01, 2013 10:54 PM|hady_matrix|LINK
tow databas alraedy exist and running.ok.
when there is internet connection ,user log to website www.mywebsite.com and enter the data.
when there is no internet,user use installed app of local database to enter the data.
how can i synchronize between remote and local database?
Jan 02, 2013 02:52 AM|Chen Yu - MSFT|LINK
You could use merge replication to sync data between to server. Merge replication, like transactional replication, typically starts with a snapshot of the publication database objects and data. Subsequent data changes and schema modifications made at the
Publisher and Subscribers are tracked with triggers. The Subscriber synchronizes with the Publisher when connected to the network and exchanges all rows that have changed between the Publisher and Subscriber since the last time synchronization occurred.
You could use merge replication in sql server express cause merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.
Hope it helps.
Feb 06, 2017 10:30 AM|satyam khare|LINK
Chen i had not listen this anytime can you give some reference i googled but not getting understand
and one more thing that can it be possible to update Remote database automatically if one not clicked the button
thanks for reply