Managing SQL Management repositories with the workbench

Use the workbench to connect to a SQL Management repository, create and manage runtime groups in a repository, and manage pureQuery information that is stored in the repository runtime group versions.

Before you begin

Before you manage a SQL Management repository in a database, you use the ManageRepostory utility to create a repository. To create a repository, see Creating a repository.

Procedure

Use the following steps to create a connection to a repository:

  1. Open the Common Repositories perspective from Task Navigator > Common Repository Management. The default Common Repositories perspective contains a Common Repository Explorer view and an Eclipse Properties view.

    You can also open the Common Repository Explorer view from Window > Show View > Other . In Show View, click Data Management > Common Repository Explorer.

  2. From the Common Repository Explorer view, connect to a database that contains a SQL Management repository, and create and manage runtime group versions.

    To create a connection to a repository, right-click Common Repository Connections, then click New.

    After a repository connection is defined, the properties for the repository connection are displayed in the Properties view.

  3. In the new connection node, expand the SQL Management repository node to display the runtime groups and group versions contained in the repository. The selected runtime group properties are displayed in the Properties view. These properties include the count of incremental captures that are associated with the runtime group and the latest timestamp of all the associated captured SQL data.

    You can create runtime groups, manage runtime group version data, add SQL data to a rutnime group version, and replace data in a runtime group version.


Feedback