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

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

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

Postby jhilden » Mon Apr 30, 2012 7:18 pm

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:

Code: Select all
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
 
Posts: 9
Joined: Tue Apr 24, 2012 4:25 pm

Postby jhilden » Mon Apr 30, 2012 8:40 pm

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

Code: Select all
sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync /ScriptFile: "C:\\foo.sql"
jhilden
 
Posts: 9
Joined: Tue Apr 24, 2012 4:25 pm

Postby eddie davis » Tue May 01, 2012 4:04 pm

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests