I have a subscription that needs to keep some external legacy data static. The Pk for the old data is of len(pk) = 8 and the new data has len(pk_new) = 15. As date field is not available i am using the pk to filter the data coming in from the publisher
as follows (select published columns from table where len(pk) > 8. However, i have a question about reinitializing the subscription. When i do so, i only want the new data to be pushed into these tables and to leave the old external legacy data untouched.
I hoped using filter would automatically be translated by MSSQL as, for all articles keep existing objects as unchanged, but i guess i have to manually change it on every reinitialization. Please advise.
View Complete Post