Red Gate forums :: View topic - Import databases
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

Import databases

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



Joined: 27 Sep 2011
Posts: 3

PostPosted: Tue Sep 27, 2011 9:08 am    Post subject: Import databases Reply with quote

Hi,

I have seen a post about this topic back from 2010 without any answer.

My problem is that I have a sql-script that gives me all database names of every database server where the customer has a certain release version.

Then I have to manually per database server select these databases in Multi Script.

It would be awesome and save me alot of time if I somehow can import the names of all databases I want to select instead of doing this manually every time.

Thanks in advance!

Regards,

Christian Persson
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Wed Sep 28, 2011 3:28 pm    Post subject: Reply with quote

Hello,

MultiScript won't do this but you may be interested in a utility to import all reachable servers and databases from your network:
http://labs.red-gate.com/Tools/Details/MultiScriptLM
Back to top
View user's profile Send private message
Kidde82



Joined: 27 Sep 2011
Posts: 3

PostPosted: Wed Sep 28, 2011 3:44 pm    Post subject: Reply with quote

Hi Brian and thanks for your reply.

Adding our servers is no problem since we just have 5 servers. It is adding 50 out of 500 databases on each of the 5 servers that is time consuming.

But it would be a nice feature in the future which would save me and perhaps many others a lots of working hours.. Smile
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Wed Sep 28, 2011 4:57 pm    Post subject: Reply with quote

Just to clarify, List Exporter will add all databases on all of the servers it detects.
Back to top
View user's profile Send private message
spivey24



Joined: 17 Oct 2006
Posts: 18

PostPosted: Mon Nov 14, 2011 5:00 pm    Post subject: Reply with quote

We have about 180 databases across 6 servers now, and they are constantly changing with new databases and servers being added! The utility mentioned is not nearly enough to keep up with this.

I ended up writing a .NET application that builds the distribution list XML file that Multi Script uses each time it runs. Gives me exact control over building the lists I need in different ways. Also allows me to order the database list based on server so it will execute all scripts on all servers at once (since Multi Script seriosly lacks the option for parallel execution across servers instead of databases)

I posted the code to generate the list at:
http://spivey24.blogspot.com/2011/11/sql-multi-script-by-redgate.html


Last edited by spivey24 on Mon Nov 14, 2011 6:18 pm; edited 1 time in total
Back to top
View user's profile Send private message
Kidde82



Joined: 27 Sep 2011
Posts: 3

PostPosted: Mon Nov 14, 2011 5:25 pm    Post subject: Reply with quote

Spivery24: Thank you, great idea!
I have a sql-script that I run on each server manually which gives me all databases with a certain version. With that result I should pretty easily be able to create a distribution list. Where can I find the xml-file? Dont find it in the install dir or in my documents folder.
/Christian
Back to top
View user's profile Send private message
spivey24



Joined: 17 Oct 2006
Posts: 18

PostPosted: Mon Nov 14, 2011 6:18 pm    Post subject: Reply with quote

Depending on OS, the filepath should be something like: C:\Users\XXXX\AppData\Roaming\Red Gate\SQL Multi Script\Application.dat

I posted the code to generate the list at:
http://spivey24.blogspot.com/2011/11/sql-multi-script-by-redgate.html
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