Red Gate forums :: View topic - Running project from CMD "unexpected char: '\'
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Running project from CMD "unexpected char: '\'

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tspeich



Joined: 04 May 2010
Posts: 10

PostPosted: Mon Mar 07, 2011 5:18 pm    Post subject: Running project from CMD "unexpected char: '\' Reply with quote

I have an automated build project that packages a script created previously by RedGate Compare. Over the weekend the tools in mention where upgraded to Packager 6.4 Compare to 8.5. This morning my build is failing with the error message "unexpected char: '\' " I am calling a project file from the cmd line with this call

C:\Downloads\Sql Packager 6>sqlpackager.exe/Project:"C:\RedGate\DSIDB_ALL.sqlpkg"

This same call has been working without incident for several months. I can also execute the package over the same script from the GUI and everything works fine. Any calls from the cmd line produce the error.
Back to top
View user's profile Send private message
tspeich



Joined: 04 May 2010
Posts: 10

PostPosted: Tue Mar 08, 2011 6:07 pm    Post subject: Reply with quote

The error is coming from the result of a script being appended to the end of the upgrade script created by SQLCompare via the type command in a .cmd file.

There was no carriage return after a GO which was resuling in the code below

Code:
GO/*
10 lines of vaious comments that included the \ character
*/


Adding the carriage return solved the problem. Although there are other issues with sqlCompare that have caused problems since upgrading. My superiors have created an incident for those
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