Sqlcompare.exe doesn't write to file (/ScriptFile)

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Sqlcompare.exe doesn't write to file (/ScriptFile)

Postby jhogan » Tue Oct 09, 2012 11:27 pm

I recently installed SQL Compare V8.50.12.20 (x86) on a Windows Server 2008 R2 Standard x64 machine.

Everything seemed to be going okay but I don't seem to be able to use sqlcompare.exe to create script files.

From an Administrator Command Prompt I enter:

Code: Select all
C:\\Program Files (x86)\\Red Gate\\SQL Compare 8>sqlcompare /database1:myDb1 /database2:myDb2 /ScriptFile:"c:\\temp\\sf.sql" /force /v


The output sent to stdout is exactly what I would expect; it shows me the objects that are different between myDb1 and myDb2. However, the file c:\\temp\\sf.sql is not created.

c:\\temp\\ exists (as a directory) and the Everyone group was given full access to it (plus I can create files in that directory from DOS using the echo command). Does anyone know why the script file isn't being created?
jhogan
 
Posts: 7
Joined: Wed Sep 23, 2009 6:30 pm

Postby jhogan » Tue Oct 09, 2012 11:48 pm

Interestingly, SqlDataCompare.exe produces its file when given the same arguments. It even prints "Creating Migration SQL & Saving Script" to stdout.

Code: Select all
C:\\Program Files (x86)\\Red Gate\\SQL Data Compare 8>sqldatacompare /database1:myDb1 /database2:myDb2  /ScriptFile:"c:\\temp\\mkddl-out.sql" /force /v
jhogan
 
Posts: 7
Joined: Wed Sep 23, 2009 6:30 pm

Postby jhogan » Wed Oct 10, 2012 7:36 pm

jhogan
 
Posts: 7
Joined: Wed Sep 23, 2009 6:30 pm

Postby stanori » Thu Oct 11, 2012 12:20 am

Hi jhogan,

Thanks for your forum post. So were you able to download the patch ok?

Best Regards,
Steve
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Postby jhogan » Mon Oct 15, 2012 4:52 pm

Yes, the patch worked for me. Thank you for following up.
jhogan
 
Posts: 7
Joined: Wed Sep 23, 2009 6:30 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests