Allow Searching/Sorting of Databases in Distribution Lists

Single-click script execution on multiple SQL Servers.

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

Allow Searching/Sorting of Databases in Distribution Lists

Postby dstew » Sat Jan 04, 2014 5:20 am

This was mentioned here as well:

http://redgatesupport.zendesk.com/entri ... tion-Lists

But as this forum seems to get more visibility, I thought I'd post here as well.

We currently use Multiscript heavily to manage around 400 databases (and growing quickly) across about 20 database servers. There's currently not a great way to search for individual databases in the list by server or name (more important). We've been forced to reverse engineer your .dat files to generate multiple distributions lists based on our client list. One sorts by date created, one alphabetically, one by server (then alphabetically) and finally we've built an individual distribution list per server. While we've implemented this workaround and it works pretty well, we're still missing a way to find and run a script on one individual database quickly. Currently we have to go into our alphabetical view and scan down the massive list for the database in question. Ideally there'd be a textbox at the top of the database list that would filter while you type based on a partial string match. While additional built in sorting of lists would be nice, again we have a workaround, so it's not top priority for us.

The database search would be a HUGE time saver for us. Let me know if you need any further details on this.

Thanks,

Dave
dstew
 
Posts: 2
Joined: Sat Jan 04, 2014 5:19 am

Postby Chris Auckland » Mon Jan 06, 2014 1:50 pm

Thanks for your post.

We've had a few requests for this feature over the years, but unfortunately it has never been scheduled into any future versions of the product.

There isn't any short-term plans for this to change, but I'll make sure it's considered for the next time we work on the product.

I really don't know when this might be, but it's unlikely it will be within the next six months.

Sorry, I don't have any better news.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby David Atkinson » Mon Jan 06, 2014 2:06 pm

@Dave

Out of interest, are you using SQL Multi Script to deploy one-to-many schema changes to your databases, or run one-to-many queries?
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby dstew » Fri Jan 10, 2014 7:39 pm

Both, its use for schema changes is crucial to our SaaS company that relies on consistent database changes, but we also query all client databases (again, shared schema) to pull one off reports and make one-off changes.

Dave
dstew
 
Posts: 2
Joined: Sat Jan 04, 2014 5:19 am


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron