| Author |
Message |
pakwichek
Joined: 04 Dec 2007
Posts: 2
|
 Posted: Tue Dec 04, 2007 5:52 pm Post subject: Wished Feature |
 |
|
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 |
|
 |
Robert
Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK
|
| Posted: Tue Dec 04, 2007 6:06 pm Post subject: |
|
|
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 |
|
|
pakwichek
Joined: 04 Dec 2007
Posts: 2
|
| Posted: Tue Dec 04, 2007 6:11 pm Post subject: |
|
|
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 |
|
|
parscott
Joined: 12 Dec 2007
Posts: 1
Location: Ottawa, Canada
|
| Posted: Wed Dec 12, 2007 9:09 pm Post subject: order script |
|
|
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.  If SQLMS could order the script from a text file or selecting from DB it would be great.
Paul |
|
| Back to top |
|
|
Robert
Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK
|
| Posted: Thu Dec 13, 2007 11:27 am Post subject: |
|
|
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 |
|
|
|
