sql server replication: Merging -- sql server replication

Merging

Gousers
12/5/2003 8:40:13 PM

sql server replication:

I have two SQL 2000 Standard servers. The servers have a
frac T1 between them. Users from each side write to their
respected databases. I've been trying to setup
replication so that the datbases stay synced. I've set
one as the distributer and published the database as
merged. on the other I subscribed to the published
database.

What I'm getting is the subriber is getting changed from
the publisher and the subriber's changes are being
deleted.

Anyone know what I'm missing?

Re: Merging

johnston NO[at]SPAM mounet.com
12/7/2003 6:19:26 PM

Could you give us the DDL of the table you are concerned with and give
us
an example of what is being deleted?? Also need to know what filters
are on it if any (row or join).

Jim

[quoted text, click to view]

Re: Merging

gousers
12/7/2003 7:34:43 PM

No filters.

As for the DDL, can I tell without asking the developer?
The table is a to do list inside the app. I go each
database and enter different to do and wait for the
schedule synchronization to run. After synch publishers
todo is in both data bases subscriber's todo is deleted.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.