Multi Script Package

Packages and compresses schema and contents of SQL Server databases

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

Multi Script Package

Postby Kirby1367 » Wed Aug 01, 2012 4:51 pm

I did a quick search and could not find anything directly related to what I am asking, so sorry if there is one.

I have a series of .sql scripts that are used for client DB updates, and labeled such as this:

Step01 - xxx.sql
Step02 - xxx.sql
Step03 - xxx.sql
...
The idea behind this is the scripts are zipped, sent over and ran on the client DB.

I noticed that the packager can create a single .exe using 1 script, but is there a way to include multiple scripts?

I could simply combine all the scripts into 1 script, but these "step" scripts are already created for clients and number in the multiple thousands. I was wondering if there was a way I could package the steps for each client into a nice .exe and discard the individual scripts.

Thank you ahead of time!
Kirby1367
 
Posts: 3
Joined: Wed Aug 01, 2012 4:42 pm

Postby james.billings » Thu Aug 02, 2012 5:37 pm

Thanks for your post.

Unfortunately you're right, Packager will only package up one script; so you would need to combine them as you suggest.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests