Options
Automate SQL Compare with a list of objects to synchronize !
eriveraa
Posts: 2
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.
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.
Comments
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.