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.
hady_matrix
Member
242 Points
252 Posts
synchronize data only between local database and remote database
Dec 30, 2012 09:18 PM|LINK
Hi all,
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?
thanks
wmec
Contributor
6228 Points
3225 Posts
Re: synchronize data only between local database and remote database
Dec 31, 2012 12:42 AM|LINK
You have to make sure the connection is fine to connect to the remote DB.
HuaMin Chen
hady_matrix
Member
242 Points
252 Posts
Re: synchronize data only between local database and remote database
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
wmec
Contributor
6228 Points
3225 Posts
Re: synchronize data only between local database and remote database
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.
HuaMin Chen
hady_matrix
Member
242 Points
252 Posts
Re: synchronize data only between local database and remote database
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?
thanks
Chen Yu - MS...
All-Star
21600 Points
2493 Posts
Microsoft
Re: synchronize data only between local database and remote database
Jan 02, 2013 06:52 AM|LINK
Hi,
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.
More information: http://msdn.microsoft.com/en-us/library/ms152746.aspx
http://msdn.microsoft.com/en-us/library/ms151819%28v=sql.105%29.aspx
Best Regards,
Feedback to us
Develop and promote your apps in Windows Store