Database migration projects are not just about data migration. They also involve changes to schema, applications, security, integration, reporting tools, backup, and recovery processes.
With the introduction of new technologies to reduce the application migration effort by way of emulating database functionalities, either at the database access layer or at the application tier, impact of database migrations on applications can be reduced to a certain extent. Aside from marketing claims on how easy it is to migrate databases in weeks, database migrations in general can be complex and time-consuming, especially when there is significant amount of business logic implemented in the database that needs to be migrated first. With judicious use of tools/technologies, a good portion of the migration tasks can be automated and the whole migration process can made manageable and economically viable. Using a factory approach for many of the tasks such as data migration, schema conversion, and...