What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare - How to Generate Script to be Executed with Installer that cannot use GO statement

gwruckgwruck Posts: 1 New member
I am developing an application using C# and want to execute the output of the SQL Compare script directly to create the database.  However, the generated script uses GO statements to batch the SQL commands, which are not able to be parsed directly by SQL Server.  (GO Statements are not part of the TSQL definition, but instead are used by SSMS to pass batches to SQL Server)

There are options that I can use in my c# project (eg. use SMO, or split the statements at GO), but I'd prefer not to have that dependency.  I thought of generating separate files, but I would like to be able to control the order of processing the files.

Has anyone else faced this problem?

Answers

Sign In or Register to comment.