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

jhildenjhilden Posts: 12
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?

Comments

  • 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 DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.