Im running an SQl server ( SQL 2000 ). I also have SQL
2000 on my laptop.

I would like to be able to copy ' sync ' the data on both
systems for a couple of tables, which enables me to make
changes on my laptop or on the SQL Server and both will
be updated with the same records. One thing i am
concerned that there may be duplicates created

can anybody suggest a route to go.. in laymans terms
please

Thanks in advance

Merge Replication is one way of doing it

The problem you have identified is "Who wins in a conflict"

Say the "Office" version always wins

If there are no changes to a row on the "Office" but there is on the
"Laptop" then you need to update the rows on the "Office"

You need to track changes as well which you can do using a timestamp column
and check that for the rows and see if the value is different

You then simply build the logic.


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote