SQL Server 2008 Snapshot Replication Trigger Start

Posted by Chris on Server Fault See other posts from Server Fault or by Chris
Published on 2012-06-12T22:40:22Z Indexed on 2012/06/12 22:42 UTC
Read the original article Hit count: 189

I have setup a production server and a staging server. Whenever we are at the point in our release cycle where we want to begin testing on staging I want to copy the production DB over to our staging server. I have setup snapshot replication to do this and have setup the staging server to have a pull subscription to the production DB.

I want my continuous integration server to be able to kick off this process. How do I programmatically trigger a snapshot to be created and replicated?

If there is a way to trigger this process is there a way to know when it's finished?

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about database