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

jhogan

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:

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

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

C:\Program Files (x86)\Red Gate\SQL Data Compare 8>sqldatacompare /database1:myDb1 /database2:myDb2  /ScriptFile:"c:\temp\mkddl-out.sql" /force /v

jhogan

Looks like this is actually a dup: http://www.red-gate.com/messageboard/vi ... scriptfile

stanori

Hi jhogan,

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

Best Regards,
Steve

jhogan

Yes, the patch worked for me. Thank you for following up.