July 13, 2007 at 2:53 am
Hi Guys,
I am new to Replication. So I need help. I am having 3 servers. First & Second are normal DB servers & the third one is the centralized server. I want to replicate the data from I & II to the centralized server. All the data model/schema are same except the data. Please tell me which replication to go for & how to proceed & where can I get a complete tutorial or help reg this.
I tried transactional replication in which I & II are the publishers & the III (centralized) is the subscriber for these two. Upon running these, I am getting a problem. When I do the snapshot of I server, its getting replicated in the Cent' server & upon modifications in the I server, its getting automatically updated in the III. But when I start the II server to replicate, then only the II server's data is available in the cent' server. All the data from the I server is being overwritten. May I know the reason?
This is very Urgent. Please help me in this regard. Thanks a lot.
July 13, 2007 at 3:05 am
Can you post the error that you get when you use Transactional Replication.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 13, 2007 at 12:32 pm
From the sounds of it, you probably should be doing MERGE replication. I've never used it so you should read up on it in the BOL and GOOGLE it.
-SQLBill
July 16, 2007 at 6:24 am
You probably will not be able to use transactional replication. You could, but your databases would need to be set up to ensure that you did not get primary key violations and you had no data conflicts. Merge replication, on the other hand, is going to require you have GUID and TIMESTAMP fields in your tables (which you may not be able to add).
Replication is not really designed as something that can be added as an after-thought. You will need to understand the different types of replication and their uses and re-engineer your databases as necessary to make use of them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply