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

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?

Greg Wruck January 23, 2019 21:16

Comments

1 comment

Thanks for your inquiry!
Given you case, it is recommended that you try using SQL Change Automation instead. You can see more details in the following documentation: https://documentation.red-gate.com/sca3/tutorials/worked-examples/embed-change-script-into-application

squigley January 25, 2019 16:38

0

Add comment

Please sign in to leave a comment.

How can we help you today?

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

Comments

Add comment