September 18, 2002 at 4:17 pm
In the company that I work there are a Factory outside the city and an Office inside the city. They are conected trough DS0, and they access the same database (in a SQL Server at the office). The comunication from the factory to the database is very slow and we want to add a new server at the factory, so the movements made there doesn't have to be saved in the office in real time. We want to replicate the data between the two servers at night. One thing to consider is that the database doesn't use primary keys, instead of that we used identities (an autoincremental value managed by the server). I'm confused because I'm new with SQL Server and I don't knok what type of replication should I use. There are 3 types, a)Snapshot, b)Transactional and c)Merge. Can anybody tell me which one should I use and why?
September 18, 2002 at 7:04 pm
Probably transactional or merge. Hard to say why in a paragraph, or even a page. You have to look at table size, transaction volume, if you'll be doing updates in both places, how much latency you can afford. Regardless replication will work with identity columns though you must have a declared primary key on each table for trans/merge to work.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply