Managing Database Connections

dbForge Studio for SQL Server offers you visual, quick, and simple way to manage database connections through Database Explorer.

By default, the Database Explorer window opens when you start dbForge Studio for SQL Server. To open the window manually, in the View menu, click Database Explorer. Alternatively, you can press: CTRL+W, L.

DB Explorer

By default, Database Explorer displays recently used database connections. The list of available connections is empty, while opening the **Database Explorer **window for the first time.

Note
The Database Explorer window is not available in the dbForge Data Compare for SQL Server, dbForge Schema Compare for SQL Server products.

Use this window to open data connections and to log on to servers and explore their databases and system services.

Create a database connection

  1. Open the Database Connection Properties dialog box:
    • Click the New Connection button on the Database Explorer toolbar.

    or * Right-click in the Database Explorer window and select New Connection from the shortcut menu.

    DB Connection Manager

  2. Set up connection parameters.

Windows connection coloring

Window connection coloring allows you immediately know to which server you’re connected to. You can add coloring for each server connection.

Tabs Coloring

Open a database connection

Double-click a connection in Database Explorer. The connection icon will be changed to Tabs Coloring and the connection node will open to show database objects of the database assigned to the connection.

Close a database connection

Right-click a connection in the Database Explorer and select Close. The connection icon will be changed to Tabs Coloring to indicate the close.

Edit a database connection

Right-click a connection in Database Explorer and select Modify Connection. The Database Connection Properties dialog box opens enabling you to edit the parameters.

Duplicate a database connection

Right-click a connection in Database Explorer and select Duplicate Connection. A copy of the connection will appear in the Database Explorer window.

Delete a database connection

Right-click a connection in Database Explorer and select Delete. The message appears asking “Are you sure you want to remove database connection ‘name’?”. Click Yes to drop the connection. Click No to cancel dropping.

View database connection information

Right-click a connection in Database Explorer and select Properties. The Properties window opens displaying the connection properties info.

DB Properties