Building Packager Applikation or C# Project based on Script.

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings

Building Packager Applikation or C# Project based on Script.

Postby mrupprath » Fri Jan 10, 2014 11:27 am

Hello;
we tried to build a SQl Package Solution based on a SQL Script.

If i am right, SQl Packager analyses the script and crates a resource file
wich a number of Batches using "GO" T-SQL Statement for Detecting of a new Batch.

Unfortunately we run into several errors all like this "Error near GO..."
We analysed the resourcefile and found out that sometimes the Go statemens remains inside of some Batchentries of the resource file.
After we manually deleted the GO Statements, it worked.

Because this is only a suitable solution for small resourcefiles reworking the resourcefiles by hand is a bad solution.

Can someone explain how the resouzrcefile is build according to the sal script, and how to handle our Problem

Greatings.
mrupprath
 
Posts: 1
Joined: Thu Jan 09, 2014 5:55 pm

Postby Brian Donahue » Mon Jan 13, 2014 12:39 pm

SQL Packager should be able to determine that a batch separator is present in a file and handle it appropriately. It breaks the script into lines, then checks that the line starts with GO and is on its' own line. That line will be a batch separator and Packager will not try to execute it.

Some things I guess could go wrong are... GO not being capitalized, GO not being the start of the line, or something about the end-of-line characters (MSDOS CRLF sequence is a safe bet...).
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager 7

Who is online

Users browsing this forum: No registered users and 0 guests