Download In This Chapter

Transcript
Automatic Data Migration
dbexport/
dbimport
dbload
Operating
System
Can use
when
you
move
data
between
operating
systems
Can use
when
you
move
data
between
operating
systems
Ease of Use
Moderate Moderate
External
Tables
HPL
IECC
onunload/
onload
onxfer
UNLOAD/
LOAD
Can use
when
you
move
data
between
operating
systems
or from a
nonInformix
database
Can use
when
you
move
data
between
operating
systems
or from a
nonInformix
database
Can use
when
you
move
data
between
operating
systems
Cannot
use when
you
move
data
between
operating
systems
Can use
when
you
move
data
between
operating
systems
Most
difficult
Most
difficult
Easy to
use
More
difficult
Moderate Easiest
Can use
when
you
move
between
operating
systems
(2 of 2)
The following sections provide guidelines on how to choose the appropriate
migration tool or tools.
Automatic Data Migration
Data migration is automatic. Automatic data migration means that when you
migrate from one database server to another, you do not need to use any data
migration tools to move the data. The data migrates automatically from the
source database server to the target database server after you bring up the
target database server. For example, data migration between Dynamic Server
7.3x and Workgroup Edition 7.3x is automatic if the database servers use the
same operating system.
Data migration can also be automatic when you move between different
versions of a database server in the same operating system.
2-8
IBM Informix Migration Guide