SQL Data Compare 12

Deploying views

SQL Data Compare can deploy views directly only if they reference rows from a single table, and the referenced columns are simple (for example, they must not include identity columns or computed columns). If you want to deploy views that reference more than one table, we recommend the following procedure:

  1. Use SQL Data Compare to compare the views.
    Make sure the Include views project option is selected.
  2. Note which rows are different.
  3. Use SQL Data Compare to compare and deploy the tables that contain the differing rows.

Didn't find what you were looking for?