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
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.
larshittu
Member
2 Points
8 Posts
How to merge different Sql Database With Same Structure
May 07, 2012 04:12 PM|LINK
bbcompent1
All-Star
32992 Points
8508 Posts
Moderator
Re: How to merge different Sql Database With Same Structure
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: http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/009f0cf6-a17e-4a05-bf6e-5a69b40adc79
larshittu
Member
2 Points
8 Posts
Re: How to merge different Sql Database With Same Structure
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?
Thanks
Mandeep Joon
Participant
1570 Points
385 Posts
Re: How to merge different Sql Database With Same Structure
May 08, 2012 11:37 AM|LINK
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.
Mandeep Joon
Blog:- Hightechnology.
Chen Yu - MS...
All-Star
21584 Points
2493 Posts
Microsoft
Re: How to merge different Sql Database With Same Structure
May 11, 2012 10:41 AM|LINK
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.
Feedback to us
Develop and promote your apps in Windows Store