Connecting to a Database

To create a connection:

  1. On the Connection toolbar, click New Connection.
  2. Enter the host name in the Host box.

  3. Enter the port information in the Port box. The default port number is 3306.

  4. Enter the login credentials in the User and Password fields.
  5. In Database, type or click the name of the database to which you want to connect.
  6. The Connection name should be generated automatically from the host name. You can create a distinctive name for your new connection.
  7. (optional) You can assign a category for a new connection in the Document Category box.

  8. (optional) You can click Advanced to configure advanced connection properties.

  9. (optional) You can click Security to configure security properties. For example, you can set up either SSL or SSH security protocols.

  10. (optional) You can click HTTP to configure HTTP tunnel properties.
  11. (optional) You can click Embedded to configure embedded server properties.
  12. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.
  13. Click OK to create the connection.

Edit and delete connections

You can create, edit, and delete connections with the help of Connection Manager. To open it, click Edit on the Source and Target page of the New Schema Comparison wizard or click the Connection Manager button on the Database menu.

To edit a connection, select it in the Connections list and click the Edit button or just double-click it in the list. The Database Connection Properties window will open.

To delete a connection, select it in the Connections list and click the Delete button or press the DELETE key.

You also can use the New button to create new connections.

Windows connection coloring

Windows connection coloring allows you immediately know to which sever you are connected to. You can add coloring for each server connection.