Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 02, 2013 06:52 AM by Chen Yu - MSFT
Dec 30, 2012 09:18 PM|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 31, 2012 12:42 AM|LINK
You have to make sure the connection is fine to connect to the remote DB.
Dec 31, 2012 09:50 AM|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 02, 2013 02:17 AM|LINK
Try the way to copy both .mdf and .ldf files from that remote server and then attach both to your local DB.
Jan 02, 2013 02:54 AM|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 06:52 AM|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.