Wished Feature
pakwichek
Posts: 3
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
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
Comments
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
Red Gate
Thanks for the good work..
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.
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
Red Gate