Creating a connection configuration from an existing database connection

You can create a connection configuration from an existing database connection and store it in a configuration repository so that other team members can reuse the properties of the connection.

Before you begin

Before you can create a connection configuration, you must set up a configuration repository database to store connection configurations.

For best results, create connection configurations from database connections that are generated by the New Connection wizard to ensure that the appropriate connection values are used. Unexpected results can occur if you create connection configurations from database aliases.

About this task

In addition to this method, you can also copy a database connection from the Database Connections folder to a configuration repository or group in the Configuration Repositories folder to create a connection configuration.

Procedure

To create a connection configuration from an existing database connection:

  1. In the Data Source Explorer, right-click an existing connection, and select Create Connection Configuration.
  2. In the window that opens, browse to the configuration repository and group in which you want to store the connection configuration, and specify a name for the connection configuration.
  3. Click OK.

Results

The new connection configuration is displayed in the Data Source Explorer in the Configuration Repositories folder, under the configuration repository in which you selected to store the connection configuration.

Feedback