I had set up replication a few times with SQL Server 2000 and there were times that I didn’t want to use a snapshot or a backup – had the schema and data already available and I just wanted to push new data over there. Setting up the subscription was pretty easy. In the Initialize Subscription dialog box, I just checked ‘No, the Subscriber already has the schema and data’. Simple, eh?
Recently I ran into the same situation – couldn’t use a snapshot or a backup (don’t ask). The subscription database was already in place and I just wanted to push any new transactions from the publication over there. When I went through the handy dandy replication wizard, though, I didn’t see the option that I had remembered from SQL Server 2000. After an initial panic attack, I did some research. The option is still there, it just looks different.
All that you need to do now is uncheck the Initialize checkbox in the Initalize Subscription dialog box and away you go.
Live, learn and replicate.