Managing Database Connections

dbForge Data Generator for SQL Server offers you visual, quick, and simple way to manage database connections through the Connection Manager window.

Create a database connection

  1. Open the Database Connection Properties dialog box by one of the following ways:
  • Click New Connection on the Database menu.

    -or-

  • Click Connection Manager on the Database menu, and then click the New button in the Connection Manager dialog box.

    Connection Manager

  1. The Database Connection Properties dialog box opens. Set up connection parameters here.

    Database Connection Properties

  2. Click OK to finish creating the connection, or click Test Connection to find out whether the connection with such parameters exists.

Windows connection coloring

Window connection coloring allows you immediately to know to which server you’re connected to. You can add coloring for each server connection in the Document Category field of the Database Connection Properties dialog box when setting the database connection properties.

Editing a database connection

To edit an already existing database connection, on the Database menu, click Connection Manager. The Connection Manager dialog box opens. Select a required connection, and then click the Edit button. The Database Connection Properties dialog box opens where you can make changes on database connection parameters.

Deleting a database connection

To delete a database connection, open Connection Manager from the Database menu. Choose a connection you want to delete, and then click the Delete button.