Working with an offline database connection in the Database Explorer

You can use saved connection information in the Database Explorer to view objects in a database even if you are not actively connected.

You must save connection information before you disconnect from a database.

To work with an offline database connection in the Database Explorer:

  1. In the Database Explorer, right-click an active connection, and click Save Offline. This step should be completed just after you refresh a connection, and just before you disconnect, so that you save the most recent changes to the database. The connection information is saved on your computer.
  2. Right-click the same connection, and click Disconnect.
  3. Right-click the same connection again, and click Work Offline. You can perform this step at any time after you save the connection information, even if you have closed and reopened the workbench. The objects in the connection are visible in the Database Explorer.
  4. Browse the objects as needed. Some actions that are normally available when you are working in an active connection are not available when you are working offline.
  5. To return to the active connection, right-click the connection and click Disconnect, then right-click the connection again and click Reconnect.
  6. Optional: Right-click the connection again and click Save Offline to save any changes that have been made to the database since you last connected.

Feedback