|
Comparison and synchronization process has three steps: schema loading, comparion and, if necessary, script generation.
In the DTM Schema Comparer we have optimized all steps. Typically performance is shown in the following table:
| Operation |
Performance1 |
| Schema loading |
18.1 objects per second2 |
| Comparison |
4.9 complex objects per second2 |
| Comparison |
56.4 simply objects per second3 |
| Script seneation |
~170 statements per second |
1) - Standard version with middle scale databases with about 680 tables in the primary database and about 460 in the secondary and about 40% differences.
For this test we used local SQL Server 2000 at desktop system (Windows XP with 2 GHz CPU and 2Gb RAM).
2) - that means you need about 8.5 minutes to compare two 1000-tables databases with default settings in the same conditions.
3) - complex object has child items like columns, related primary key, etc. Simply object has no childs (view, procdure, trigger, etc).
|
