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