SQL Server Database Project

  1. On the File menu, point to New, and then click Project to add SQL Server 2008 Database Project to the existing solution.
  2. On the Data menu, point to Schema Compare, and then click New Schema Comparison.
  3. In the Source Schema panel, select Database, and then click New Connection to connect to the data source.
  4. In the Target Schema panel, select Project, and then select the Database Project.
  5. Click OK to start Schema Comparison.
  6. After the comparison finishes, a table in the Schema Compare window lists the database objects that were compared.
  7. To update the schema to the target Database Project, click Write Updates button in the Schema Compare toolbar.
  8. You can save the created Schema Comparison for later use.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s