May 31, 2011
Database migrations have always been complex, time-consuming, and costly due to proprietary data structures and data types, SQL extensions, and procedural languages. It can take up to several months to migrate a database, depending on database size, complexity, and usage of these proprietary features.
A new technology has recently emerged for solving this problem: the database compatibility layer[DCL], a database access layer that supports another database management system's (DBMS's) proprietary extensions natively, allowing existing applications to access the new database transparently. ANTs Software, EnterpriseDB, and IBM offer database compatibility layers that enable a new approach to database migrations.
Application developers and database administrators looking to migrate databases due to cost concerns, staffing problems, or technology issues should consider this new database compatibility layer option to mitigate risk, lower migration cost, and speed the migration process. Quotes: -- "Currently, IBM DB2 is the only DBMS product that offers a DCL, ..." -- "Forrester estimates that more than 400 companies have migrated their databases using a DCL, and we expect this rate to double in the next two years." -- "Although a DCL does not support 100% application code compatibility, firms Forrester interviewed indicated that it?s possible to achieve 90% to 98% compatibility, which is a significant improvement over traditional approaches."