Groups | Blog | Home
all groups > sql server replication > july 2003 >

sql server replication : syncronizing info between 2 sql 2k db


Hilary Cotter
7/14/2003 8:52:13 AM
Your question is too vague to give a good answer.

There are three types or replication that could work for
this.

Snapshot, where you send all the tables and their data to
the subscribers. This will replicate all data even in
tables with no primary keys. The problem is that you have
to send all of the data over the wire everytime, and is
not a good solution when you have a low bandwitdth link
between your publisher and subscriber. If a large part of
your data changes between sync's you should consider it.

Transactional, where the transactions flow across the
wire. The downside of this is that only tables with PK's
on them will be replicateable. The upside is that its way
fast, and works quiet well on low bandwidth solutions.

There is also merge which adds into own key to all of your
table. Merge replication is more difficult to
troubleshoot, but works well in low bandwidth solutions.

Check out http://www.mssqlserver.com/replication for a
replication tutorial.
[quoted text, click to view]
prdqld
7/14/2003 2:01:58 PM

Hello,
I am new to this and would like some assistance please.

I have two db in the same SQL Group on a SQL 2000 installation. Both
have an identical structure but different names.

What I would like to do is syncronize some of the information from one
db into the other on a daily basis, overwriting the existing information
in the second db.

Is there a simple way to do this? If so please help with details or
point me in the right direction.

Sorry if this is a simple/stupid question, I am new to SQL databases.

Thanks in advance

Ross

--
AddThis Social Bookmark Button