A reference guide for creating and managing test data.
Purpose of Move component
The Move component extracts, copies, and moves sets of
relationally intact data from multiple source tables to corresponding
destination tables. Move handles an arbitrarily complex data model
consisting of any number of tables and relationships and ensures a
referentially intact set of data for use in application testing, data
migration, and date aging.
Processing Flow
Move uses a two-step process to migrate data: an Extract step
and an Insert step.
Convert Process
You may want to convert data to assure data privacy or
to systematically transform data to meet your application testing
requirements. You can import converted data into a spreadsheet program,
insert it into a testing database, or restore it to a reporting database.
Extract Process
Use the Extract Process to copy a set of related rows from
one or more tables and save the rows to an external Extract File.
Specifications for the Extract Process are stored as an Extract Request.
Insert Process
Use the Insert Process to insert data stored in an Archive
File or Extract File into a destination database. If tables in the
Archive or Extract File do not exist at the destination, the Insert
Process uses the object definitions stored in the Archive or Extract
File to create them.
Load Process
Use the Load Process to transform the contents of an Archive
or Extract File into a format that is appropriate for a particular
DBMS loader and then, if specified, start the corresponding database
load utility.
Command Line Interface
Optim provides a
command line interface that allows you to run an Extract, Insert,
Load, or Convert Process, run one or more processes from a file, or
run a scheduled job, without opening the graphical user interface.