| Author |
Message |
jhilden
Joined: 24 Apr 2012 Posts: 9
|
Posted: Mon Apr 30, 2012 7:18 pm Post subject: 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:
| Code: |
| 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? |
|
| Back to top |
|
 |
jhilden
Joined: 24 Apr 2012 Posts: 9
|
Posted: Mon Apr 30, 2012 8:40 pm Post subject: |
|
|
Sorry guys, I just didn't read enough in the documentation. Here is the solution:
| Code: |
| sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync /ScriptFile: "C:\foo.sql" |
|
|
| Back to top |
|
 |
eddie davis
Joined: 14 Jun 2006 Posts: 796 Location: Red Gate Software
|
Posted: Tue May 01, 2012 4:04 pm Post subject: |
|
|
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 |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group