Creating and Using a Local Copy of the Database Connection Profile
You can use a database connection profile to either connect directly to the database, or to create and use a local copy of the database schema.
Procedure
Expand the list of
Databases in the Data Source Explorer view.
Right-click the database connection profile you want to copy and select
Connect
(if you are not already connected).
Right-click the database connection profile and select
Save Offline.
Note: If you choose to use a local copy of the databases schema, you must manually keep the local copy synchronized with the master database. If you believe the master schema has changed, use the same procedure to recreate your local copy.