Schema Comparison Stress Testing
Wednesday, May 6th, 2009A few weeks after the first version of dbForge Schema Compare for SQL Server had been released we received a letter from one of our users who was testing our product to find out if it’s capable to support his DBA tasks. Here is the excerpt from his letter:
Nowadays I work as ERP-system (industry enterprise management system) adoption consultant. Though this ERP-system was originally developed for Microsoft SQL Server 2000 platform but it allows deployment on SQL Server 2005. Second decision has better performance characteristics, but at the same time architectural differences between SQL Server version 2000 and 2005 impede installation of patches and regular database maintenance operations.
The only way out of this situation is this:
- periodically downgrade database from SQL Server 2005 to 2000
- perform maintenance operations over database on SQL Server 2000 platform
- upgrade database back to SQL Server 2005
But this decision makes difficulties…