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
Prerequisites: - 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.
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.