Multi Script list manager
From RedGateWiki
Contents |
SQL Multi Script Server List Manager v1.2
This program allows you to import SQL Multi Script database lists from one configuration profile to another, or to another computer. The database lists and any SQL scripts can be exported to an .msx file which can be applied to another profile or computer using the list manager application.
Installation
Download the ZIP file at the end of this article and extract all files to a folder on your hard disk. Run the program by double-clicking the .exe icon.
Usage
Exporting your database lists
Launch the list exporter by double-clicking the icon. If SQL Multi Script is installed and lists and scripts have been configured, the application will pick them up and show the information in the "Databases" and "SQL Scripts" tabs of the main window. You can export all of this configuration using the File->Export menu item. The result is a Multi Script List Manager (.msx file) that you can distribute, along with the list manager application, to the other computer.
Distributing your database lists to other SQL Multi Script users
When the destination user launches the list manager application, it will also show the local server lists in the "Databases" tab. To import the lists from the .MSX file, use the File->Open->ListManager file. Select the lists that you want to merge into the local settings by clicking/shift-clicking/CTRL-clicking the lists that you want to add, then select File->Save->Selected Lists.
It is also possible to save the SQL Scripts to the destination computer, using File->Save->SQL Scripts. You are then asked for a directory in which to save the scripts, and the existing Multi Script installation will be updated to reflect the scripts and their new location.
Editing databases in the database list
Version 1.1 of the list manager will allow you to do some basic manipulation of database lists. You can sort alphabetically, either ascending or descending, find databases, or move databases up or down in order, and delete databases.
Clicking "save" will save your changes to the Multi Script project on the local computer. Note that you cannot change .msx files and will be warned about this. To modify the database lists, you can save your changes, then use File->Open->MultiScript settings and then edit the database list.
To access the databases window, double-click on the list that you want to change. To delete a database from the list, highlight it and remove it using the delete key.
