Red Gate forums :: View topic - Saving 'Scripts Executed' and 'Executed Against'
Return to www.red-gate.com RSS Feed Available

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

Saving 'Scripts Executed' and 'Executed Against'

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



Joined: 18 Sep 2009
Posts: 3
PostPosted: Fri Sep 18, 2009 2:35 pm    Post subject: Saving 'Scripts Executed' and 'Executed Against' Reply with quote
This is a great app, really simplyfies things.. but it would be very helpful if you could save the information displayed under the 'Scripts Executed' and 'Exectued Against' fields.

The 'Save Results' features
Quote:
SQL Multi Script does not automatically save results if you exit the application. To save your results, click Save, located above the Messages tab in the Results window. You can save your results as a .csv or .txt file that can then be opened and used in other applications.

doesn't really help as it doesn't specify exactly what script was run on what database and when.

Is there are some type of patch that can be dowloaded, which would allow for this data to be saved in a similar way the 'Messages' are saved?
Back to top
View user's profile Send private message
Colin Millerchip



Joined: 31 Oct 2007
Posts: 42
Location: Cambridge, UK
PostPosted: Tue Sep 22, 2009 2:53 pm    Post subject: Reply with quote
Hi ivopld,

Thanks for the post. Could you provide a bit more details regarding what you're trying to do, and why you'd want to save this information, please? Is it as a way of recording changes, eg, for audit needs?

Thanks,


Colin.
Back to top
View user's profile Send private message Send e-mail
ivopld



Joined: 18 Sep 2009
Posts: 3
PostPosted: Wed Sep 23, 2009 4:34 pm    Post subject: Reply with quote
Hi Colin,

In a way it is for "audit" purposes.. it would be helpful for our organization to track issues related to 'missing scripts' or scripts that haven't been run on particular databases.

So a way to log the execution history of scripts on databases, would be very helpful.
Back to top
View user's profile Send private message
ivopld



Joined: 18 Sep 2009
Posts: 3
PostPosted: Wed Sep 23, 2009 4:38 pm    Post subject: Reply with quote
Or, if there's a button to export the contents of the 'Scripts Executed' and 'Exectued Against' fields into some type of external file.. that would also be very useful.
Back to top
View user's profile Send private message
Colin Millerchip



Joined: 31 Oct 2007
Posts: 42
Location: Cambridge, UK
PostPosted: Wed Sep 23, 2009 5:43 pm    Post subject: Reply with quote
Hi ivopld,

Thanks for the further information. It isn't something that SQL Multi Script does at the moment, but I'll add this as a request for consideration for a future release.

Best regards,


Colin.
Back to top
View user's profile Send private message Send e-mail
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