Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Maintaining Deployed Databases

This topic applies to:

Visual Studio Ultimate

Visual Studio Premium

Visual Studio 2010 Professional 

Visual Studio Express

Topic appliesTopic appliesTopic does not applyTopic does not apply

By using Visual Studio, you can compare two database schemas. Those schemas might be represented by a database, a data-tier application project, a database project, a server project, or the build output from a database project (a .dbschema file). When the schema comparison finishes, the results appear in the Schema Compare window. You can optionally write updates to the target or you can generate a Data Definition Language (DDL) script that you can use to update the schema and data on the target server so that it matches the source server.

In the following table, you can find descriptions of common high-level tasks that support this scenario and links to more information about how you can successfully complete those tasks.

Common Tasks

Supporting Content

Synchronize schemas between your production and development databases: You can compare the schemas of your production and development servers and specify which changes you want to synchronize.

Synchronize data between your production and development databases: You can compare the data on your production and development servers and specify which changes you want to synchronize at the table level or even at the row level.

Troubleshoot problems: You can identify and correct common problems that you might encounter when you compare and synchronize schemas or data.

Perform routine operations tasks: Back up your database, manage your transaction log, monitor your database, and tune the performance of your database.

On the Microsoft Web site:

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.