I have two identically structured databases on two separate servers. Both have different data within them.
I have set one of them up with merge replication as a publisher and I want the other to be a subscriber.
The problem is that when I create the subscription, the publisher sends its snapshot to the subscriber and it clears all of the data from the subscriber database before it begins the sync process.
How can I preserve the data in both databases and set them up so that one is the publisher and the other is the subscriber?