Overview

Data Migrator is an agnostic tool capable of creating database objects such as databases, schemas, and tables from ready-to-execute SQL scripts for the target database. It can also populate these objects with data from provided data files.

I/O Support

Input

• Data files: Data Migrator supports a variety of source data file-based systems, including CSV, EBCDIC, and QDDS. These data files are extracted by customers from their legacy databases to populate the migrated databases.
• Configuration files: These files allow users to configure the target database credentials, which can also be secured in AWS Secret, to ensure a successful connection for the Data Migrator tool. Additionally, the configuration files define multiple steps to orchestrate the end-to-end migration process, from creating the database objects to converting and migrating the data.
• Modernized SQL files: The tool requires ready-to-execute SQL scripts generated from the modernization of DB2 DDL or IMS DBD files using Blu Age transformation engines. It is important to note that IMS only supports PostgreSQL as the target database platform.
• SQL Model JSON: File representing the DB2 or IMS metadata. It helps Data Migrator determine how to convert certain columns during the data loading process.

Output

• Data Migrator supports the following target database platforms:
  • PostgreSQL
  • Oracle
  • SQL Server
  • DB2LUW (Linux, Unix, Windows)
• CSV Report: A report that provides metrics and status information regarding the executed scripts, as well as the number of records that were loaded.
• Log File: Logging execution of each migration step.