Feature requests - checkbox for "use"

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Feature requests - checkbox for "use"

Postby Petro » Fri May 16, 2008 4:39 pm

Hi all :)

updates are sometimes for more than one database. in oure case, we often make separated scripts (files) to make sure the script runs on the correct db. so we use a "use". but multiscript does not change back the db-context, witch is not the db that is shown in multiscript.

for us, the need for "use" is imported, because we do not use multiscript to update productive dbs (yet).

Possibilities:
- option for "check for 'use' and mark at import"
- checkbox on each script for "set back the db before run the script"

thanks for thinking about

see ya
petro
Petro
 
Posts: 10
Joined: Tue Nov 15, 2005 9:48 am

Postby HJoyce » Mon May 19, 2008 1:39 pm

I have logged this as a feature request to be considered in the next release. Thanks for the feedback.

Regards,
Helen
HJoyce
 
Posts: 150
Joined: Mon Oct 10, 2005 9:48 am

Postby shadowbob » Tue Jul 22, 2008 6:05 pm

A feature similar to this would probably be considered my "#1" productivity booster. Basically, I'd love an option to "Override USE statements in script" so that if any USE statements happen to be in the script, they go away and the script actually runs on the database which Multi Script intends it to. This would literally shave minutes off of every single work day for me. Thanks a bunch!
shadowbob
 
Posts: 52
Joined: Fri Feb 02, 2007 1:12 am

Postby Roust_m » Wed Apr 29, 2009 7:36 am

But what if you have something like this:
USE MyDB
[do some schema changes here]
USE msdb
[create some jobs here]

if you ignore all USE statements your script may fail.

I would rather have an ability to do automatic replacements like this:
USE {database name}
[do some schema changes here]
USE msdb
[create some jobs here]
So {database name} would automaticaly be replaces to the database the script runs against.
Roust_m
 
Posts: 4
Joined: Tue Apr 28, 2009 9:46 am

Postby Colin Millerchip » Fri May 01, 2009 9:31 am

Hi,

Thanks for the suggestion, I've logged this request and we'll consider it for the next release.

Best regards,


Colin.
Colin Millerchip
 
Posts: 66
Joined: Wed Oct 31, 2007 5:31 pm
Location: Cambridge, UK


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests