Red Gate forums :: View topic - Wished Feature
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Wished Feature

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
pakwichek



Joined: 04 Dec 2007
Posts: 2

PostPosted: Tue Dec 04, 2007 5:52 pm    Post subject: Wished Feature Reply with quote

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
Back to top
View user's profile Send private message Yahoo Messenger
Robert



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Tue Dec 04, 2007 6:06 pm    Post subject: Reply with quote

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
Developer, Red Gate Software Ltd
Back to top
View user's profile Send private message MSN Messenger
pakwichek



Joined: 04 Dec 2007
Posts: 2

PostPosted: Tue Dec 04, 2007 6:11 pm    Post subject: Reply with quote

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..
Back to top
View user's profile Send private message Yahoo Messenger
parscott



Joined: 12 Dec 2007
Posts: 1
Location: Ottawa, Canada

PostPosted: Wed Dec 12, 2007 9:09 pm    Post subject: order script Reply with quote

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. Crying or Very sad If SQLMS could order the script from a text file or selecting from DB it would be great.
Paul
Back to top
View user's profile Send private message Send e-mail
Robert



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Thu Dec 13, 2007 11:27 am    Post subject: Reply with quote

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
Developer, Red Gate Software Ltd
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group