Database Migration

 

Next Steps
Overview Data Type Conversion File Format Conversion Database Migration Data Replication

In addition to converting data types, record layouts, and file formats, IRI software can help you convert from one database to another. See this list of supported DB (and related) sources.

The free IRI Workbench, built on Eclipse™, is an Integrated Development Environment (IDE) and Graphical User Interface (GUI) for IRI's data management software and DB-connecting technologies. The Workbench supports:

the use of: in order to:
DB profiler & E-R diagrammer
find intra- and inter-table patterns, values, statistics, and key relationships within multiple databases
JDBC
view source and target databases in the IRI Workbench's Data Source Explorer (Data Tools Platform)
ODBC
move data (dump or select, then create/truncate, append, insert/update) between source and target tables directly
IRI FACT (Fast Extract)
rapidly unload source databases in bulk to the file system for faster data movement and manipulation (interchange)
filter, transform, remap, and pre-sort table data for ODBC inserts or bulk loads to new targets
IRI NextForm (DBMS edition)
filter, remap, and populate target tables via ODBC with source table data, create new table DDL, and leverage built in SQL editing and execution in the IRI Workbench to facilitate DB migrations (see how-to example)
discover, filter/subset, mask and populate new target tables via ODBC with source table data protected and transformed at the column level using IRI Workbench wizards, dialogs, and transform mapping diagrams to facilitate secure DB migrations and comply with data privacy laws
synthesize new table test data in full or part (subsets) based on the target's DDL information to prototype and capacity-plan migrations to the new database
DB loader configs
facilitate bulk loads into Oracle, DB2, MySQL, PostgreSQL, Sybase, SQL Server, and Teradata
SQL
define new CREATE table programs with keys and other constraints, and edit and run SQL directly in the Workbench, too
stored procedures
use available API-compatible conversion technology from IRI partner erwin to auto-engineer legacy SQL programs into Voracity ETL workflows and/or other DBs

Use the facilities in the common IRI Workbench GUI to migrate between databases or versions if you know your source data and target plans. The CoSort and NextForm job wizards and workflows support cross-table rule definition and application to facilitate job design and automate mass remapping.

Leverage IRI professional services or expert partners to help you migrate triggers, stored procedures, and applications. Refer to the database acceleration section for prototyping (DB test data), performance optimization, and column-level security considerations.

Share this page

Request More Information

Live Chat

* indicates a required field.
IRI does NOT share your information.