How can we help you today? How can we help you today?

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

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
0

Comments

4 comments

Sort by
  • 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
    0
  • jhogan
    Looks like this is actually a dup: http://www.red-gate.com/messageboard/vi ... scriptfile
    jhogan
    0
  • stanori
    Hi jhogan,

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

    Best Regards,
    Steve
    stanori
    0
  • jhogan
    Yes, the patch worked for me. Thank you for following up.
    jhogan
    0

Add comment

Please sign in to leave a comment.