sql compare command line - how to send final script to file

jhilden

I'm using SQL Source Control and testing out SQL Compare for continuous integration. What I'm testing now is that SQL compare successfully uses a couple custom migration scripts and a couple outmatic updates. This seems to be working with the following command:

sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync

The sync works properly but the /verbose command doesn't output the migration script that sqlcompare actually used. How can I get a look at what is being run behind the scenes?

jhilden

Sorry guys, I just didn't read enough in the documentation. Here is the solution:

sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync /ScriptFile: "C:\foo.sql"

Eddie D

Hi

Thank you for your posts into the forum and a for updating your post with the solution to your issue.

Please contact us if you need our help and assistance in the future.

Best Regards
Eddie