Overview

Top  Previous  Next

To use SQL Multi Select, you need to first understand how server list, query groups, and projects are related.

 

Server list

 

A server list is a list of servers that SQL Multi Select can access.  You can define as many servers as you want.  You maintain the list of servers by clicking on any project's Edit button in the Query group section.

 

query_group_edit

 

In the Configure Query Groups window, you can add/edit/remove servers on the left panel.

 

query_group_list

 

It is important to note that any changes to the server affects all query groups which contain that server.  E.g. if you change the connection details of the server, all query groups using that server will use the new connection details.  Likewise, if you remove a server from the server list, that server will also be removed from all query groups using that server.

 

 

Query Groups

 

A query group consists of one or more servers selected from the server list.  You can add, rename, and remove query groups to fit different needs.  For each server in a query group, you can define which databases SQL Multi Select should connect to and run the query for.

 

For example, you may define a query group that only runs scripts on the connected database,

 

query_group_name01

 

 

and another query group that runs scripts on all the databases on the server.

 

query_group_name02

 
For more on query groups, please see this topic.

 

 

Projects

 

A SQL Multi Select project is made up of one or more scripts, and a query group.  When you run a project, SQL Multi Select runs all the scripts against all the servers defined in the selected query group.

 

project_overview