Save a Relational Database Connection

On this page

You can use a saved connection for any task that requires connecting to a database. You can save a new relational database connection:

Steps

To save a new connection from the Connections page:

In the list of Relational connections, click + Add connection.

In the Database type drop-down, select the database type.

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. Required.
Identifier	One of Service Name or SID.
Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. If blank, you only see objects in the default `dbo` schema in all databases.
Authentication	By default, this is set to SQL Server. Set to Windows to enable Windows Integrated Authentication, using the credentials of the user who launched the Relational Migrator executable. This disables the Username and Password fields.
Username and Password	The credentials to use for authentication. Disabled if Authentication is set to Windows. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.
General / SSL toggle	View SSL settings for the connection. To use SSL, you must first uncomment and update the `server.ssl` configuration properties in your `user.properties` file.
SSL: Use SSL	Enable or disable SSL.
SSL: Trust server certificate	With SSL enabled, check this to trust the stored certificate. Leave unchecked to verify the server certificate against a trusted Certificate Authority.

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. Leave blank to load all databases.
Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.
General / SSL toggle	View SSL settings for the connection. To use SSL, you must first uncomment and update the `server.ssl` configuration properties in your `user.properties` file.
SSL: Use SSL	Enable or disable SSL.
SSL: SSL mode	With SSL enabled, choose from: Preferred (default): Make an encrypted connection if possible, otherwise fall back to an unencrypted connection. Required: Require an encrypted connection. Verify CA: Verify the server certificate against a trusted Certificate Authority. Verify identity: Verify the database connection information against the certificate contents.

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. Leave blank to connect to the default database.
Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.
General / SSL toggle	View SSL settings for the connection. To use SSL, you must first uncomment and update the `server.ssl` configuration properties in your `user.properties` file.
SSL: Use SSL	Enable or disable SSL.
SSL: SSL mode	With SSL enabled, choose from: Prefer (default): Make an encrypted connection if possible, otherwise fall back to an unencrypted connection. Require: Require an encrypted connection. Verify CA: Verify the server certificate against a trusted Certificate Authority. Verify full: Verify the database connection information against the certificate contents.

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. Required.
Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

Field	Value
Host	The host IP or DNS name.
Port	The port number.
Database	The database name. Leave blank to connect to the default database.
Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

Relational Migrator attempts to authenticate and connect to the database.

The saved connection is available for use in all jobs and projects.

Back

Save a MongoDB Connection

Manage Connections