A connection working set is a group of specific
database connections. You can define connection working sets to help
you quickly identify the databases that you want to work with and
to more easily manage your connections. For example, you might define
a working set to display only your locally hosted data sources.
Procedure
To define a connection working set, complete the following
steps:
- In the Administration Explorer,
right-click the Working Sets folder, and click Configure
Connections Working Set. The Connections
Working Set window opens.
- Click New. The New
Working Set window opens.
- In the Working set name field, name
your working set.
- Add all of the connections that you want to include in
this set. You can add specific database connections or
you can select a host name to add all of the database connections
that belong to that host. The items that you add
are listed on the right side.
- Click Finish. The New
Working Set window closes.
- In the Connections Working Set window,
ensure that the set that you want to work with is checked, and click OK. Your working set is added to the Workings Sets folder
in the Administration Explorer and contains only
the connections that you selected.
What to do next
You have a subset of database connections that you can
work with. Only those database connections that you selected are visible
under the working set name in the Workings Sets folder.
Repeat these steps to create additional working sets that include
connections to different databases. Individual connections can belong
to more than one working set.
If you want to edit a connection
working set, right-click the Working Sets folder
and click Configure Connections Working Set.
In Connections Working Set window, select the
working set that you want to edit, and click Edit.
You
can remove a connection working set by following the steps to edit
a working set and clicking Remove instead of Edit.