Batches of scripts

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Batches of scripts

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

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

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

Hi,

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.

Thanks!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby JDS » Tue Jun 26, 2007 3: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.
JDS
 
Posts: 18
Joined: Fri Oct 27, 2006 6:43 pm

Postby richardjm » Tue Jun 26, 2007 12:00 pm

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
richardjm
 
Posts: 395
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest