Synchronizing views
Published 23 January 2013
SQL Data Compare can synchronize 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 synchronize views that reference more than one table, we recommend the following procedure:
- Use SQL Data Compare to compare the views.
Make sure the Include views project option is selected. - Note which rows are different.
- Use SQL Data Compare to compare and synchronize the tables that contain the differing rows.