3. Conversion Procedure

Use an automated tool called Migration Center for data conversion.

Before the conversion work, it is necessary to create a user and create a tablespace according to the environment used in the previous DBMS for mapping work.

When specific DB-dependent functions are applied, the manual conversion is performed.

DATA conversion and application operation procedure

Checking DATA consistency

Resolving data conversion failure

Conversion Tools

Migration Center

1) Advantages of Migration Center

 East to use with GUI-based tool
 Easy execution and high performance of transferring by supporting CLI mode
 Transfer data along with schema in one operation
 Perform migration by mapping different data types
 Support user-defined formats to support flexible data migration
 Provide step-by-step step summary report on conversion results

2) How to use

(1) Add Database Connection

Input the information of Source/Targe DBMS
 Connection Name : Can be arbitrarily specified
 IP : DBMS Server IP
 Port : DBMS Server Port
 User : Connected user account
 Password : Connected user password
 SID : Service name
 IP Version : IPv4/IPv6

Since the JDBC driver is used to connect to the database, it is important to prepare a suitable JDBC driver for the source database and target database. For user convenience, several JDBC drivers suitable for supported databases are provided with the Migration Center.

(2) Create Project

Create a project for data migraiton
 Project Name : Can be arbitrarily specified
 Project Path : Automatically created
 Source Database : Oracle
 Destination Database : Altibase

(3) Build Project

Select the method (Fast/Slow) to get the number of records in the table from the source database and proceed.

(4) Reconcile Project

This is the most important step in the migration process that defines how to perform the migration.

 User Mode: Defines all tables and all data accessible to the user account defined when creating the source database as migration targets
 Table Mode: Select and define the table to migrate data from among all tables accessible to the user account defined when creating the source database

 Data Type Mapping: Data type mapping between Oracle and Altibase
 PSM Data Type Mapping: Data type mapping between Oracle PL/SQL and Altibase PSM
 Tablespace to Tablespace Mapping: Oracle and Altibase tablespace mapping
 Table to Tablespace Mapping: Specify the tablespace to store Altibase tables
 Select Editing: Add/edit Oracle data search condition
 DDL Editing: Edit the final DDL of Altibase