Setting up a configuration repository database to store connection configurations

Before you can store connection configurations in a database, you must perform some setup steps.
Before you begin
Prerequisite: The following types of data sources can be used as configuration repositories. You can use any version of each database that is supported by your product. Refer to the list of supported data sources for your product in the system requirements documentation for more details.
About this task

Before you can store connection configurations in a configuration repository, you must set up a database that will be used as the configuration repository. This database should be accessible by all team members to facilitate sharing the connection information. You can run a script to set up the database with the correct structure.

To set up a configuration repository database to store connection configurations:

  1. In the Data Source Explorer, connect to the database that you want to use as a configuration repository.
  2. Right-click the connection in the Data Source Explorer, and select Set up Configuration Repository.

    In the editor that opens, you can customize the setup script to specify different table spaces for the configuration tables, based on your need to backup and share the connection configurations.

    Important: Do not change the names of the data objects that are created.
  3. Right-click in the editor and select Run SQL to set up the configuration repository. Verify that the script ran successfully by checking the SQL Results view. If the script runs successfully, you should also be able to see the new tables in the Data Source Explorer.
  4. Add this database as a configuration repository:
    1. Right-click the Configuration Repositories folder in the Data Source Explorer and select New.
    2. In the window that opens, select the database on which you ran the setup script, and click Finish.
Results
What to do next
After the configuration repository is set up and you have populated it with database connection configurations, notify team members and provide them with the information that they need to connect to this configuration repository.

Feedback