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