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
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!
- Posts: 3
- Joined: Wed Aug 01, 2012 4:42 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.
- 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