Automated data warehouse migration

A computer-readable storage device comprising computer-executable instructions stored therein for causing the computer to perform a method of migrating data from a source database environment to a target database environment, the source database environment including at least one source database, the method comprising:

• analyzing the source database environment and the target database environment to extract a validation criteria list and produce based on the analyzing, a conversion inventory of the source database environment and a configuration data file identifying at least one mapping code and/or script, the configuration data file for generating one or more mappings for data in the conversion inventory of the source database environment to the target database environment, wherein:
• the conversion inventory comprises extraction, transformation, and loading (ETL) code from the source database environment;
• the generating the one or more mappings comprises mapping one or more validation structured query language (SQL) statements based on the extracted validation criteria list;
• and
• migrating at least a portion of the data to the target database environment, wherein the migrating is performed based at least in part on the mappings generated using the at least one mapping code and/or script identified by the produced configuration data file, wherein the migrating produces migrated data in the target database environment.

A method of migrating source extraction, transformation, and loading (ETL) code from a source environment to a target environment as target ETL code compliant with the target environment, the method comprising, with a computer:

• analyzing the source ETL code and the source environment using at least one analysis script to produce a conversion inventory, wherein the analyzing further includes extracting a validation criteria list;
• converting at least a portion of the source ETL code to the target ETL code using at least one mapping from the source environment to target environment, wherein the mapping is based at least in part on the extracted validation criteria list and the conversion inventory, and wherein at least a portion of the target ETL code is executable in the target database environment;
• generating an input ETL job list with one or more migration validation requirements based on analysis of the source ETL code and the target ETL code;
• generating validation results based on the one or more migration validation requirements;
• and
• determining whether to repeat the converting based on the validation results.

A system for migrating a source database environment to a target environment comprising a data warehouse appliance, the source database environment including a source database and source Extraction, Transformation, and Loading (ETL) code, the system comprising:

• a memory coupled to at least one processor, the memory storing the source database and the ETL code;
• a computer-implemented database analysis workbench stored in the memory, the database analysis workbench for analyzing the source database environment and the target environment to extract a validation criteria list from the source database and produce based on the analyzing, a conversion inventory of the source database environment and a configuration data file identifying at least one mapping code and/or script the configuration data file for migrating data from the source database environment to the data warehouse appliance, the conversion inventory comprising ETL code from the source database environment, wherein the database analysis workbench is further operable to compare an ETL dictionary specifying a plurality of ETL tools with a set of target ETL attributes to generate the configuration data file;
• a computer-implemented database migration workbench stored in the memory, the database migration workbench for migrating at least a portion of the data from the source database environment to the data warehouse appliance using one or more mappings based at least in part on one or more validation structured query language (SQL) statements associated with the extracted validation criteria list and identified by the produced configuration data file;
• and
• a computer-implemented database quality assurance workbench stored in the memory, the database quality assurance workbench for validating data migrated to the data warehouse appliance by the database migration workbench.