Product Suggestion: Option to add more than one script

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

Product Suggestion: Option to add more than one script

Postby vreeland » Wed Jan 21, 2009 1:38 am

As is, unfortunately this product doesn't help me at all.

However, if it were possible to select and add more than one script to be performed in a specific sequence, then this would be a great help to me.

Any chance this might make it into a future release?
vreeland
 
Posts: 5
Joined: Tue Aug 22, 2006 6:56 pm

Postby Matthew Flatt » Fri Jan 23, 2009 10:37 am

Hi,

Thank you for your feedback, this will be considered for future releases but I am unable to comment on the likelihood of this being implemented.

It's not much of a workaround but you could use the pre and post sql script option when running the package, this would then execute 3 scripts in sequence.

Thanks.
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

Postby David Atkinson » Fri Jan 23, 2009 12:11 pm

Another possible workaround is to concatenate the scripts to each other before loading the script into SQL Packager?

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Additional scripts in package

Postby larsbuch » Wed Apr 01, 2009 10:34 am

Hi

I can agree with the feature suggestion.

When we release to our servers we use from 4 to 15 scripts depending on the number of features released that need to be run in a specific order. The servers are not nessisarily upgraded at the same time and we might have 2-3 different versions running. Before a script is run the database version is checked to see if the script has already been run.

So for SQL Packager to be useful we need to be able to pack more than one script in one package and to be able to append more as we release more features.

Our way of handling this is to not use SQL Packager but to use our own creation but i would prefer to have a tool for doing that.
Regards

Lars Buch-Jepsen
Database Engineer
SCADA Development
Suzlon Energy A/S
larsbuch
 
Posts: 1
Joined: Wed Apr 01, 2009 10:17 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests