Command Line : Snapshot Automation

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Command Line : Snapshot Automation

Postby jamesforest » Tue Nov 22, 2011 6:33 pm

I am considering automating the generation of snapshots on a periodic basis via the command line. I was hoping to create new snapshot datasets with a timestamp suffix versus using the /force parameter. Any provisions for this now or in the future?
jamesforest
 
Posts: 1
Joined: Tue Nov 22, 2011 6:22 pm

Postby james.billings » Thu Nov 24, 2011 7:06 pm

Thanks for your post.

There's a "makesnapshot" switch for the command line (see the list of switches here) which may help.

There's no option to automate the filename to a date/time etc, but if you are combining it with an MS-Dos batch file you could probably use variables to perhaps name the file based on the current date? For example, someone had a similar query (unrelated to RedGate products!) here - could be worth checking out.

You can use Windows task scheduler to kick it off.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests