|
The comparison and synchronization process has three steps:
schema loading, comparison 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 generation |
~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 child objects (view,
procedure, trigger, etc).
|
