|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Sunday, August 12, 2012 1:38 AM
Points: 284,
Visits: 493
|
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, November 24, 2008 11:33 AM
Points: 1,
Visits: 5
|
|
| Can this be automated so that we can use this to keep a mirror copy of a database up to date?
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Sunday, August 12, 2012 1:38 AM
Points: 284,
Visits: 493
|
|
Yes, synchronisation scripts can be saved and then embedded in a SQL job to be run at regular intervals. The last step in the synchronisation wizard prompts you either to synchronise now or save the script for a later use. Simply save the script and then use it in a SQL Agent job.
|
|
|
|