Wished Feature

Single-click script execution on multiple SQL Servers.

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

Wished Feature

Postby pakwichek » Tue Dec 04, 2007 5:52 pm

Very Good Product and I love it. I wish there was an
ability to auto generate script from a database by an select an object schema such Stored Procedure, table field, etc

I have used in-house tools that do exactly that and it is nice

Also, ability to save the metadata of the project, that is script run and the list of target server databases..

I believe this request is over-kill but will be really nice for future versions
pakwichek
 
Posts: 2
Joined: Tue Dec 04, 2007 5:37 pm

Postby Robert » Tue Dec 04, 2007 6:06 pm

Hi,

Thanks for the comments. If you want to deploy objects to multiple servers, I'd suggest you use a tool like SQL Compare to synchronize your source database to a blank database, then use the resulting SQL script in Multi Script.

As for saving projects, this is definitely something we're considering adding in a future version - it's in the issue tracking system already!

Many thanks,
Robert
Robert Chipperfield
Red Gate
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK

Postby pakwichek » Tue Dec 04, 2007 6:11 pm

Thanks for the reply.. I do have SQLcompare, and I guess it works for that. Waiting for the future release.

Thanks for the good work..
pakwichek
 
Posts: 2
Joined: Tue Dec 04, 2007 5:37 pm

order script

Postby parscott » Wed Dec 12, 2007 9:09 pm

It there a way to determine the execute order other then through the GUI?

Background:
We have an in house process that controls the running SQL scripts. Scripts are logged in a table with an executing order. Essentially each script messages out what the next SQL script to run and its a major time consumer to run >100 scripts. :cry: If SQLMS could order the script from a text file or selecting from DB it would be great.
Paul
parscott
 
Posts: 1
Joined: Wed Dec 12, 2007 8:59 pm
Location: Ottawa, Canada

Postby Robert » Thu Dec 13, 2007 11:27 am

Hi Paul,

I'm afraid at the moment we don't support programmatic modification of the script list. We'll bear this in mind when we're looking at future versions, though - so thanks for the suggestion!

Just to clarify, do you need something that lets you modify the list "on the fly" (i.e. execute one script, modify the list, execute the next, modify the list etc.), or do you just want to be able to create a list of scripts programmatically, then run them all in one go?

Thanks,
Robert
Robert Chipperfield
Red Gate
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests