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?