SQL Server Merge replication with no initial snapshot option
Posted on 2007-03-26
I am trying to setup a SQL Server 2005 merge replication without the initial snapshot.
The data on both the subscriber and the publisher is currently in an identical state and I have inherited a script that creates the publication. After running this script, the publication is created, I then create the subscription (ensuring I do not tick the Initialize subscription checkbox).
This subscription then gets created. However when I look at the replication monitor on the publisher, there is an error, stating the initial snapshot for the publication is not yet available.
I remember that when creating a publication using the MSSM Studio wizard, there is an option (checkbox) questioning whether to create the snapshot immediately.
Therefore my thinking is that within the publication script I inherited this "create the snapshot immediately" option has not been turned off.
Can somebody please tell me how to turn off this option using t-sql (or a script) or is there a property I can change once the publication has been set up.
(apologies if the above seems muddled, but am fairly new to replication and still getting my head around it ;-)