Exporting database connection profiles

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:

  1. In the Data Source Explorer, select a connection and click the Export toolbar button.
  2. Select the connection profiles that you want to export.
  3. 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.
  4. 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.
  5. Click OK.

Results

The text file is generated and saved in the directory that you specified.

Feedback