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:
- 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.
- Right-click the same connection, and click Disconnect.
- 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.
- 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.
- To return to the active connection, right-click the connection
and click Disconnect, then right-click the connection
again and click Reconnect.
- 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.