How to merge different Sql Database With Same Structure

Hi my Professionals, Am having little problem with SQL Database. I have Web application using SQL DB, We try to make the date capture faster in uploading information to it by deploring on deferent local machine to deferent zone @ the end than we can merge the data on the sql database since the database is with the same structure. but have been having issue on how to i go about it. please any idea will be welcome Thanks

Re: How to merge different Sql Database With Same Structure

Have you considered using the database sync features built into SQL? You could use MS SyncFramework to do the heavy lifting in thsi case: http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/009f0cf6-a17e-4a05-bf6e-5a69b40adc79

Re: How to merge different Sql Database With Same Structure

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?

Thanks

Re: How to merge different Sql Database With Same Structure

Hi,

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.

Re: How to merge different Sql Database With Same Structure

Hi,

I found below thread, it may help you to make a decision.

Please see: http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/1534f579-d8d5-4252-a048-b34bde66172d/

Thanks.