How can we help you today? How can we help you today?

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

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
0

Comments

2 comments

Sort by
  • 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"
    jhilden
    0
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.