I am attempting to deploy a database to a machine by executing a script generated by the "Generate Scripts" tool in SQL Server Management Studio.
Here is the command I've issued:
sqlcmd -S LOCALHOST\sqlexpress -I -U user -P ******** -i C:\Rollouts\NI-9-25-2012_10-42-AM\Rollout.sql > rolloutlog.txt
I'm receiving errors like this:
Sqlcmd: Error: Syntax error at line 39488 near command ''' in file 'C:\Rollouts\ NI-9-25-2012_10-42-AM\Rollout.sql'.
When I view this line with a text editor all signs point to an issue with quotation marks.
The line in question looks like this:
Is there a switch that I should be executing or generating the script with to support quotes within the script?