Can I compare and synchronize system databases with ApexSQL Data Diff?
System-supplied objects can only be compared but not synchronized. If you want to use a system database in a comparison project, check the Show System Databases option in the Data Sources tab of the Project Settings dialog. This will add the system databases to the list of databases. User tables and views found in system databases can be both compared and synchronized.
Related Questions
- Can I compare databases without taking indexes and constraints into account so that SQL Examiner does not offer me to synchronize tables with the same set of columns as different after the comparison?
- The databases I am comparing have different structures. Will ApexSQL Data Diff do the data comparison in such case?
- Can I apply a rule to synchronize the data between tables in different databases?