February 23rd, 2004, 10:43 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Merge Replication without transferring schema and data from publisher.
Hi All,
I am doing merge subscription between two computers that have MSDE and it works great. My merge subscription is a pull subscription such that when you do the subscription for the first time the subscriber fetches all the table schema and existing data from the publisher.
By doing this, all the pre-existing data and schema in the subscriber MSDE are overwritten.
I wanted to change this such that the table schema and existing data of subscriber MSDE are not overwritten when pull subscription is done, and when I trigger synchronization all the pre-existing data from subscribing MSDE is merged along with the data from publisher.
To do that:
1. I created a pull subscription using Enterprise Manager (I have SQL Server client tools installed over MSDE), and I chose not to download schema and data from publisher.
2. Started syncronization.
But, after syncronization completed what I saw was none of the data from publisher is brought back to subscriber and all the existing data from subscriber is deleted.
Then, I added couple of rows in few tables in Publisher MSDE and Subscriber MSDE (In published and subscribed tables). I tried doing synronization again. After synchronization completed what I saw was:
1. All the newly added rows in subscribed tables in Subscribing MSDE have been deleted and were not transferred to publisher.
2. The newly added rows from publisher MSDE seemed to have transferred to subscriber, but not the pre-existing rows from before the pull subscription was done.
It seems to me that when you are doing pull subscription with an option of not getting the table schema and data then you can only do replication with the data added after the subscription is done. Is it true? Or, am I missing anything here??
Any response will be appreciated.
Thanks,
Niben
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
