Keep track of scripts that have been run

Single-click script execution on multiple SQL Servers.

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

Keep track of scripts that have been run

Postby hoosiersqldev » Wed Sep 02, 2009 8:40 pm

It would be nice if Multi Script could insert into a change log table on the db (automatically) with what script and when it was run. Then to also have the ability to have it not run scripts which have already been run.

I highly suggest that for the next release. How do other people handle that situation now?
hoosiersqldev
 
Posts: 3
Joined: Wed Sep 02, 2009 8:36 pm

Postby peter.peart » Mon Sep 07, 2009 12:55 pm

Hi there,

I can certainly see why this would be a valuable thing to have, therefore I have created a note in our systems regarding this particular feature request, and the tracking number is SE-639.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby hoosiersqldev » Tue Sep 15, 2009 8:47 pm

Okay, yeah, that is holding us up from using red gate products. We need to be able to know what scripts have been run and for multi-script to automatically filter out previously run scripts.
hoosiersqldev
 
Posts: 3
Joined: Wed Sep 02, 2009 8:36 pm

Postby hoosiersqldev » Mon Aug 30, 2010 9:57 pm

Any update on this request? Tracking number was created almost exactly a year ago.

Thanks
hoosiersqldev
 
Posts: 3
Joined: Wed Sep 02, 2009 8:36 pm

Postby spivey24 » Mon Nov 14, 2011 5:09 pm

I keep running into this problem where I need to rerun scripts that failed on certain databases. Finding the few databases needed to rerun in a list of 100+ in the distribution list is getting very tedious. It would be nice to have a button that checks off just the databases the script failed on in the distribution list. Any update on this?
spivey24
 
Posts: 18
Joined: Tue Oct 17, 2006 3:16 am


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron