Packages and compresses schema and contents of SQL Server databases
Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings
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
- Posts: 1
- Joined: Thu Jan 09, 2014 5:55 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...).
- 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