MicroStrategy Incorporated
SYSTEMS AND METHODS FOR DATABASE MIGRATION

Abstract:

Systems and methods are disclosed herein for migrating data from a source environment to a target environment. The source and target environments may have different database management systems and/or may be disposed on separate networks. In some embodiments, systems and methods disclosed herein may include identifying data for migration in the source environment, wherein identifying the data comprises identifying tables having a predetermined prefix value, setting customized properties in a data migration utility based on the data, creating a shell for the data in the target environment, using the data migration utility, creating an intermediary representation of the data, copying the intermediary representation to the target environment; and restoring the data from the intermediary representation into the shell in the target environment.