December 15, 2008 at 10:11 pm
Hello,
I have two web servers that connect to different sql backend's (db have the same schema) , that log the visits to the web sites, i want to setup replication so both db are replicated to each other, updates going both directions. Can anyone advise me what they recommend?? I have a sneaking suspicion that I can't do this because they have been runnin independently for a while and the identity fields will clash, a possible re-seeding my be in order 🙁
Cheers,
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
December 15, 2008 at 10:48 pm
Likely you can set up identity ranges for each server and manage that.
I'd look at bi-directional transactional and merge, and then see which one seems to suit your needs. Merge is more complex, but can handle collisions better.
December 15, 2008 at 10:54 pm
Cheers for that, and yeah i've decided to use identity range for the tables, thanks again 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply