|
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).
|