Import databases

• 
  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

  Brian Donahue September 28, 2011 10:28

  - 0 +
• 
  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..

  Kidde82 September 28, 2011 10:44

  - 0 +
• 
  Just to clarify, List Exporter will add all databases on all of the servers it detects.

  Brian Donahue September 28, 2011 11:57

  - 0 +
• 
  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/sq ... dgate.html

  spivey24 November 14, 2011 11:00

  - 0 +
• 
  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

  Kidde82 November 14, 2011 11:25

  - 0 +
• 
  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/sq ... dgate.html

  spivey24 November 14, 2011 12:18

  - 0 +

Add comment

Please sign in to leave a comment.