Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 11, 2012 10:41 AM by Chen Yu - MSFT
May 07, 2012 04:12 PM|LINK
May 07, 2012 04:43 PM|LINK
Have you considered using the database sync features built into SQL? You could use MS SyncFramework to do the heavy lifting in thsi case:
May 08, 2012 11:05 AM|LINK
Thanks so much,
But i my own case i have more than 100 local mechine deployed on. and i need to merge the Sql Database record.
Would the MS SyncFramework it also?
May 08, 2012 11:37 AM|LINK
I think you have to use SQL Server Replication feature.
Transactional replication offers a more flexible solution for databases that change on a regular basis. With transactional replication, the replication agent monitors the publisher for changes to the database and transmits those changes to the
subscribers. This transmission can take place immediately or on a periodic basis.
More about Replication:- http://msdn.microsoft.com/en-us/library/ms151198.aspx
Mark this as answer if it is usefull.
May 11, 2012 10:41 AM|LINK
I found below thread, it may help you to make a decision.