Command Line : Snapshot Automation

Forum for users of SQL Compare schema synchronization utility

Command Line : Snapshot Automation

Postby jamesforest » Tue Nov 22, 2011 5: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?
Posts: 1
Joined: Tue Nov 22, 2011 5:22 pm

Postby james.billings » Thu Nov 24, 2011 6: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.
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests