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:
- In the Data Source Explorer, right-click an existing connection,
and select Create Connection Configuration.
- 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.
- 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.