Red Gate forums :: View topic - Allow Searching/Sorting of Databases in Distribution Lists
Return to www.red-gate.com RSS Feed Available

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

Allow Searching/Sorting of Databases in Distribution Lists

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



Joined: 04 Jan 2014
Posts: 2

PostPosted: Sat Jan 04, 2014 5:20 am    Post subject: Allow Searching/Sorting of Databases in Distribution Lists Reply with quote

This was mentioned here as well:

http://redgatesupport.zendesk.com/entries/32691108-Allow-Searching-Sorting-of-Databases-in-Distribution-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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 06, 2014 1:50 pm    Post subject: Reply with quote

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



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Mon Jan 06, 2014 2:06 pm    Post subject: Reply with quote

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



Joined: 04 Jan 2014
Posts: 2

PostPosted: Fri Jan 10, 2014 7:39 pm    Post subject: Reply with quote

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