Data Movement Workflow

In Migrations

 

Perl via ODBC or embedded  PL/SQL Anonymous. Procedures.

 

1a. Type one migrations: More steps, but better performance with very large transfers

 

1b. Type one or two migrations: Not as fast as 1a, but better suited to “business object” collections in type two requirements. Fewer steps

 

1c. Type two migrations: well adapted to long term transfer of records on continuous basis.

 

Target DB

 

PERL Filters

 

CLEANED

FLAT FILES

 

FLAT FILES

 

4th/5th GL of

Source DB

 

Source

DB

 

PL/SQL stored procs. & SQL+ scripts

 

SQL Loaded Temp Tables

 

Target DB

 

SQL LDR Scripts

 

PERL Filters

 

CLEANED

FLAT FILES

 

FLAT FILES

 

4th/5th GL of

Source DB

 

Source

DB

 

PL/SQL Stored Procedures using direct file I/O

 

Target DB

 

PERL Filters

 

CLEANED

FLAT FILES

 

FLAT FILES

 

4th/5th GL of

Source DB

 

Source

DB