Command Line Script file Only

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Command Line Script file Only

Postby abaker97 » Mon Aug 01, 2011 4:24 pm

I am trying to compare a scripts folder to live database via the command line and generate a script file using the /scriptfile parameter without actually syncing the database. But, the only way I can get the script file created is to use the /sync option. Is it possible to generated the script file without syncing?
abaker97
 
Posts: 1
Joined: Mon Aug 01, 2011 4:05 pm
Location: United States

Postby james.billings » Wed Aug 03, 2011 6:37 pm

Thanks for your post.

This sounds unusual. I've just tried it here, with a commandline of:

sqlcompare /db1:<db> /db2:<db> /scriptfile:c:\\somefolder\\somescript.sql

This worked fine, and the file was generated. Are you working with any other switches that may somehow be conflicting? The full command may help. Also, what version are you using? If your scriptfile already exists, you may need to add on the /force option to overwrite it; but I think the same would be true with the /sync option set.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby bjarni » Wed Sep 21, 2011 10:40 am

I got the same problem as abaker97:

If I specify /scriptfile without /sync I don't get my scriptfile ex:

sqlcompare /s1:<server1> /db1:<db> /s2:<server2> /db2:<db> /scriptfile:c:\\somefolder\\somescript.sql

Including the /sync switch will generate the scriptfile ex:

sqlcompare /s1:<server1> /db1:<db> /s2:<server2> /db2:<db> /scriptfile:c:\\somefolder\\somescript.sql /sync

I'm using SqlCompare8! Is this a bug which has been fixed in SqlCompare9?

Is it because I'm comparing across servers?
bjarni
 
Posts: 4
Joined: Wed Sep 21, 2011 10:28 am

Postby james.billings » Wed Sep 21, 2011 11:53 am

I believe an update to the latest release did resolve it- try out the latest version and see if it works for you.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby bjarni » Fri Sep 23, 2011 12:27 pm

Thanks.

I found a patch that fixed the problem:

http://www.red-gate.com/messageboard/vi ... hp?t=11077

SC-4896 /ScriptFile:"<path\\name.sql>" does not appear to generate script file (regression from 8.2)
bjarni
 
Posts: 4
Joined: Wed Sep 21, 2011 10:28 am


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests