You can use saved connection information in the Data Source
Explorer to view objects in a database even if you are not actively
connected.
Before you begin
Save connection information before you disconnect from
a database.
Procedure
To work with an offline database connection in the Data
Source Explorer:
- In the Data Source Explorer, right-click an active connection,
and then 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 then click Disconnect.
- Right-click the same connection again, and then 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 Data Source 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 then click Disconnect, then right-click
the connection again and click Reconnect.
- Optional: Right-click the connection again
and then click Save Offline to save any changes
that have been made to the database since you last connected.