Red Gate forums :: View topic - Sqlcompare.exe doesn't write to file (/ScriptFile)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

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

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jhogan



Joined: 23 Sep 2009
Posts: 7

PostPosted: Tue Oct 09, 2012 11:27 pm    Post subject: Sqlcompare.exe doesn't write to file (/ScriptFile) Reply with quote

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:
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?
Back to top
View user's profile Send private message
jhogan



Joined: 23 Sep 2009
Posts: 7

PostPosted: Tue Oct 09, 2012 11:48 pm    Post subject: Reply with quote

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

Code:
C:\Program Files (x86)\Red Gate\SQL Data Compare 8>sqldatacompare /database1:myDb1 /database2:myDb2  /ScriptFile:"c:\temp\mkddl-out.sql" /force /v
Back to top
View user's profile Send private message
jhogan



Joined: 23 Sep 2009
Posts: 7

PostPosted: Wed Oct 10, 2012 7:36 pm    Post subject: Reply with quote

Looks like this is actually a dup: http://www.red-gate.com/messageboard/viewtopic.php?t=13823&highlight=scriptfile
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 76

PostPosted: Thu Oct 11, 2012 12:20 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
jhogan



Joined: 23 Sep 2009
Posts: 7

PostPosted: Mon Oct 15, 2012 4:52 pm    Post subject: Reply with quote

Yes, the patch worked for me. Thank you for following up.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group