Scheduling 'Create Snapshot'

JonathanJonathan Posts: 4
edited May 11, 2010 11:48AM in SQL Compare Previous Versions
Hi there,

I've a question about creating SQL Compare Snapshots:
Is it possible to schedule this action?
I would like to automatically create a snapshot of each database every night, like I schedule backups.

Greetz,

Jonathan

Comments

  • Hi Jonathan,

    Many thanks for your post. If you have the PRO version of SQL Compare you are granted access to the command line interface of the tool. One of the switches available is to generate a snapshot of a DB, so with this in mind you could create a batch file to generate the snapshot and then schedule the batch file to run using Windows Task Scheduler.

    More information on the command line and switches is available from the below link:

    http://www.red-gate.com/supportcenter/C ... 846144.htm

    HTH!

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.