You can use the toolbar buttons in the Data Source Explorer
to export database connection and filter information to a plain or
encrypted text file and save it on the local file system. You can
export one or multiple connection profiles to a single text file.
About this task
You might want to export database connection profiles
in the following situations:
- You want to create a new workspace or upgrade to a newer version
of your product.
- You want to reuse existing connection profiles.
- You want to share a common set of connection profiles across a
workgroup.
- You want to deploy a set of connection profiles to a backend server
environment, whose application can work directly with the exported
file. You can copy the file to a server with no need to explicitly
import the connection profiles.
Procedure
To export database connection profiles:
- In the Data Source Explorer, select a connection and click
the Export toolbar button.
- Select the connection profiles that you want to export.
- Enter a fully qualified file name to create a new file,
or click Browse to navigate to an existing
file that you want to replace.
- Optional: Clear the Encrypt File
Content check box if the connection profiles do not contain
passwords or any other content that poses a security risk. This
option generates an unencrypted text file.
- Click OK.
Results
The text file is generated and saved in the directory that
you specified.