Ability to schedule?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Ability to schedule?

Postby noob2013 » Fri Jan 03, 2014 10:37 pm

Is there a way to schedule SQL Compare to execute at a certain time?

Say, I want to move objects currently in development to production. After selecting the objects I want moved, I know I can save project as abc.scp.

Is it possible to schedule Windows Task Scheduler (perhaps?) to run and make the move during after hours?

Any example to accomplish the task above?

Thanks
noob2013
 
Posts: 19
Joined: Wed Jan 30, 2013 3:11 pm

Postby Chris Auckland » Mon Jan 06, 2014 11:52 am

Thanks for your post.

Yes, you can automate your deployments using the SQL Compare command line. The easiest way is to use a Windows Scheduled Task.

The best way to get started is to read our documentation on using the command line interface. There are several examples that should help you set it up.

I hope this helps.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest