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

4^th/5^th 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

4^th/5^th GL of

Source DB

Source

DB

PL/SQL Stored Procedures using direct file I/O

Target DB

PERL Filters

CLEANED

FLAT FILES

FLAT FILES

4^th/5^th GL of

Source DB

Source

DB