Batches of scripts

Forum for users of SQL Packager database archive utility

Batches of scripts

Postby JDS » Fri Jun 22, 2007 2:28 pm

Is there any way to include a batch seperator between inserts into different tables?
Posts: 18
Joined: Fri Oct 27, 2006 5:43 pm

Postby Brian Donahue » Sat Jun 23, 2007 8:58 pm


That's a good question. Packager allows you to output the SQL and data scripts, so you can view them, or save them to disk. In the actual package output, though, they wouldn't have much meaning. The ADO .NET client that is going to run the script doesn't have a concept of batch separators (GO), as they're mainly to enhance the performance of SQL clients like Query Analyzer and Management Studio.

If you could elaborate on your need to have these, we can certainly look into it.

Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby JDS » Tue Jun 26, 2007 2:04 am

We have our own installer that that uses the the scripts generated to populate the database data. Our installer chokes on the size on of this script (60 MB). If a batch seperator could be added after inserts to each table it would save us some time adding them in.
Posts: 18
Joined: Fri Oct 27, 2006 5:43 pm

Postby richardjm » Tue Jun 26, 2007 11:00 am

What you could do if you are using the API is generate the migration SQL for each individual table you want to package and put your batch separators in there, however you want to do it.

You would however have to be very careful about disabling foreign keys - doing things in the right order and all the other lovely things SQL Data Compare does for you when you tell it to work on a whole database.

If you're not using the API then there's no way of doing it (neatly anyway)
Richard Mitchell
Project Manager
Red Gate Software Ltd
Posts: 541
Joined: Fri May 20, 2005 8:44 am
Location: Red Gate Software Ltd

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests