dbForge Fusion for SQL Server provides features for managing objects in instances of the database engine.
Database Explorer provides a hierarchical user interface to view and manage database connections and database objects. To open Database Explorer, on the Fusion menu, click Database 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.
To use Database Explorer, you must first connect to a server.
To create a database connection:
1. Click the New Connection button on the Database Explorer toolbar. The Database Connection Properties dialog box opens.
2. On Data Source, select a database server you want to connect to.
3. Set up connection parameters. For more information see - Connecting to a Database.
Double-click a connection in Database Explorer. The connection icon will be changed to and the connection node will be opened to show database objects.
Right-click a connection in Database Explorer, and then select Close. The connection icon will be changed to indicate the close.
Right-click a connection in Database Explorer and select Modify Connection. The Database Connection Properties dialog box opens.
Right-click a connection in Database Explorer, and then select Duplicate Connection. A copy of the connection will appear in the Database Explorer window.
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.
Window connection coloring allows you to immediately know which server you are connected to. You can add coloring for each server connection.
Right-click a connection in Database Explorer and select Properties. The Properties window opens displaying the connection properties info.