If you already have different data in the 2 databases, and need to
synchronize it, replication is not really a suitable tool. Have a look at
DataCompare from Redgate (http://www.red-gate.com/SQL_Data_Compare.htm)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

This is probably a newbie question but I was wondering if there is a way to
setup the initial snapshot between two databases, that are the exact same
database, and merge the data between the two without losing or overwriting
any data? It seems that "Merge" is the way to go however I either get one of
the DBs overwritten (push or pull) or I get nothing to merge.

Any ideas?

That's what I thought. I just downloaded the tool.

Thanks

[quoted text, click to view]