Automate SQL Compare with a list of objects to synchronize !

eriveraa

Hi friends, i am evaluating the product and it's really cool, but i also need to know how to automate some tasks. The most important for me is how to automate SQL Compare on synchronizing a list of objects i choose.

For example, i have a list of tables and stored procedures that need to be synchronized, and i would like to be able to send this list to SQL Compare, and SQL Compare do the job.

Any ideas??
Thanks in advance.

Brian Donahue

Hello,

I suppose you have a few options for automating the synchronization of a set of objects. The first would be to construct a batch file specifying the objects on the command-line using the /include argument to sqlcompare.exe, or do the same by writing an XML command file for sqlcompare.exe.

The second would be to use SQL Compare to set up a comparison project between two databases, then go into the projects screen again, right-click the project, select locate on disk and then copy the project file and use the project in a batch file using the /pr argument to sqlcompare.exe.

Either way, you can automate the synchronization by submitting the batch file to your Windows Scheduled Tasks and use the /Sync switch to execute the synchronization automatically. Sqlcompare.exe is the command-line version of SQL Compare that comes with the Professional Edition licence.