I'm doing merge replication in sql server 2008 to synchronize the database between two systems. I added only tables to replicate initially. Successfully it is synchronizing.
Now the problem is whenever I'm adding new article say adding stored procedure, the snapshot is starting from scratch. Meaning, it is creating article from the table to stored procedure. So, it is taking too much time to run the snapshot as my data consists of lots of records.
Is there any way to run the snapshot for only newly added article??