Databases Reference
In-Depth Information
Performing data migration
After you have successfully created a new environment for Oracle BAM, it is time
to move BAM data to the environment. You can use either the low-level database
commands or ICommand, a BAM utility to achieve this goal.
Migrating BAM data using database commands
BAM stores its artifacts (Data Objects, reports, folders, and so on) and metadata
in a database. Therefore, it is practical to perform data migration by using data-
base commands to move raw data directly to a different environment. Though
BAM supports Oracle Database, IBM DB2, and Microsoft SQLServer, this section
only covers the usage of Oracle database commands to achieve data migration.
The
expdp
database command can be used to export the
database schema for BAM on the source host, while the
im-
pdp
command is for importing the dump file to the database
on the target host. Because these are the low-level database
methods, this approach is more suitable in the case of the ini-
tial data migration to a fresh installation, or cloning a database
schema that does not contain any business data yet.
To perform BAM data migration using Oracle Database commands, do the follow-
ing:
1.
Connect to the BAM database as the
sys
user.
sqlplus sys/password as sysdba
