In SQL Server merge replication, how does reinitializing work?
Posted
by Craig Shearer
on Stack Overflow
See other posts from Stack Overflow
or by Craig Shearer
Published on 2010-03-28T09:59:14Z
Indexed on
2010/03/28
10:03 UTC
Read the original article
Hit count: 264
sql-server
|merge-replication
I have set up a pull subscription to a merge publication in SQL Server. I use parameterized row filters on some tables. This works fine with the initial synchronization - just the rows using the filter arrive in the replicated (client) database.
However, at some later point I'd like to be able to synchronize the replicated database again from the server and have new rows that match the parameterized row filters appear on the client database. The doucmentation seems to indicate that I can call Reinitialize() to do this. However, when I do try this and Synchronize again, I get an error saying that the script 'snapshot.pre' cannot be applied to the database. I've inspected the script and can see why - it's trying to drop some functions are used by the tables in the database. It would appear that for Reinitialize() to work it requires that the database be blank.
Am I misunderstanding something here? Is there a way to make this work?
© Stack Overflow or respective owner