THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Migrate Oracle to HiRDB

HiRDB

The database migration tool Ispirer MnMTK can convert Oracle to HiRDB. You can use our conversion tool for stored procedure migration, function migration, trigger migration, view migration, schema migration. We help to understand our clients the value of automated database and application migration solutions that enable business growth.


Oracle to HiRDB Migration Overview

The tool migrates the following database objects and properties to HiRDB:

  • Tables conversion
  • Stored Procedures, Functions and Triggers conversion
  • Stored PL/SQL block conversion
  • Stored Packages conversion
  • Indexes conversion
  • Functions conversion
  • Comments conversion

We propose you to have a deeper insight at the Oracle to HiRDB migration features.

Tables conversion

  • Columns definitions conversion - data types, default values
  • Integrity constraints conversion - primary and foreign keys, unique and check constraints
  • Partitions and options conversion

Oracle:

  1. CREATE TABLE hanbai
  2. (
  3. data_date NUMBER(8) NOT NULL,
  4. mise_no CHAR(6) NOT NULL,
  5. nou_gen_kin NUMBER(15,2),
  6. kep_kaisu NUMBER(9) DEFAULT 10
  7. )
  8. PCTFREE 05
  9. PARTITION BY RANGE (data_date)
  10. (PARTITION d19970101 VALUES LESS THAN (19970102)
  11. TABLESPACE TBS_USIA_10000K);

HiRDB:

  1. CREATE TABLE hanbai
  2. (
  3. data_date INT NOT NULL,
  4. mise_no MCHAR(6) NOT NULL,
  5. nou_gen_kin DEC(15,2),
  6. kep_kaisu INT DEFAULT 10
  7. )
  8. IN((TBS_USIA_10000K) data_date < 19970102)
  9. PCTFREE = 05;

Stored Procedures, Functions and Triggers conversion:

  • Basic statements and syntax (Cursors, Loops, Exceptions, DML statements etc) conversion
  • %TYPE and %ROWTYPE variables conversion
  • IN, OUT, INOUT parameters

Oracle:

  1. CREATE TABLE t4 (c1 FLOAT, c2 TIMESTAMP, c3 INT);
  2. CREATE TABLE t5 (c1 FLOAT, c2 TIMESTAMP, c3 INT);
  3.  
  4. CREATE OR REPLACE PROCEDURE cur1_proc(CNT FLOAT)
  5. IS
  6. CURSOR cur1 IS SELECT c1,c2 FROM t4;
  7. cur1_rec cur1%ROWTYPE;
  8.  
  9. BEGIN
  10. OPEN cur1;
  11. LOOP
  12. FETCH cur1 INTO cur1_rec;
  13. EXIT WHEN SQL%NOTFOUND;
  14.  
  15. INSERT INTO t5 (c1,c2)
  16. VALUES( cur1_rec.c1, cur1_rec.c2 );
  17.  
  18. END LOOP;
  19. CLOSE cur1;
  20.  
  21. END;

HiRDB:

  1. CREATE TABLE t4 (c1 FLOAT, c2 TIMESTAMP, c3 INT);
  2. CREATE TABLE t5 (c1 FLOAT, c2 TIMESTAMP, c3 INT);
  3.  
  4. CREATE PROCEDURE cur1_proc(IN CNT FLOAT)
  5. BEGIN
  6. DECLARE cur1 CURSOR FOR SELECT c1,c2 FROM t4;
  7. DECLARE SWV_CUR1_REC_C1 FLOAT;
  8. DECLARE SWV_CUR1_REC_C2 TIMESTAMP;
  9.  
  10. OPEN cur1;
  11. SWL_Label: WHILE 1 = 1 DO
  12. FETCH cur1 INTO SWV_CUR1_REC_C1,SWV_CUR1_REC_C2;
  13. IF SQLCODE = 100 THEN
  14. leave SWL_Label;
  15. END IF;
  16. INSERT INTO t5(c1,c2)
  17. VALUES(SWV_CUR1_REC_C1, SWV_CUR1_REC_C2);
  18. END WHILE SWL_Label;
  19. CLOSE cur1;
  20.  
  21. END;
  22. END_PROC;

Stored PL/SQL block conversion:

  • PL/SQL block to stored procedure conversion
  • Basic statements and syntax conversion
  • %TYPE and %ROWTYPE variables conversion

Oracle:

  1. DECLARE
  2. i NUMBER;
  3. BEGIN
  4. FOR i IN 0..681 LOOP
  5. INSERT INTO msgcode_range VALUES (i);
  6. END LOOP;
  7. END;
  8.  

HiRDB:

  1. CREATE PROCEDURE proc1()
  2. BEGIN
  3. DECLARE i FLOAT;
  4.  
  5. SET i = 0;
  6. WHILE (i <= 681) DO
  7. INSERT INTO msgcode_range VALUES(i);
  8. SET i = i+1;
  9. END WHILE;
  10. END;
  11. END_PROC;

Stored Packages conversion:

  • Each stored procedure from an Oracle package’ body is converted into a separate stored procedure in HiRDB
  • Ispirer MnMTK converts package's variables to INOUT variables in the procedure's body
  • Basic statements and syntax conversion
  • %TYPE and %ROWTYPE variables conversion

Oracle:

  1. CREATE OR REPLACE PACKAGE package1
  2. AS CNT FLOAT;
  3. PROCEDURE proc1(INPARAM1 IN DATE);
  4. PROCEDURE proc2;
  5. END package1;
  6. /
  7. CREATE OR REPLACE PACKAGE BODY package1
  8. AS
  9. PROCEDURE proc1(INPARAM1 IN DATE)
  10. AS
  11. BEGIN
  12. CNT := CNT+1;
  13. END proc1;
  14. PROCEDURE proc2
  15. AS
  16. BEGIN
  17. CNT := CNT+2;
  18. END proc2;
  19. END package1;
  20. /

HiRDB:

  1. CREATE PROCEDURE PACKAGE1_PROC1(INOUT CNT FLOAT,
  2. IN INPARAM1 TIMESTAMP)
  3. BEGIN
  4. SET CNT = CNT+1;
  5. END;
  6. END_PROC;
  7.  
  8. CREATE PROCEDURE PACKAGE1_PROC2(INOUT CNT FLOAT)
  9. BEGIN
  10. SET CNT = CNT+2;
  11. END;
  12. END_PROC;

Indexes conversion:

  • Index’s options conversion

Oracle:

  1. CREATE INDEX IX1
  2. ON HANBAI_D ( mise_no,shohin )
  3. PCTFREE 05
  4. TABLESPACE TBS_USIA_IX_10000K
  5. LOCAL;

HiRDB:

  1. CREATE INDEX IX1
  2. ON HANBAI_D
  3. (mise_no,shohin)
  4. IN(TBS_USIA_IX_10000K)
  5. PCTFREE = 05;

Functions conversion:

  • Main functions to HiRDB equivalents conversion
  • Time and number formats conversion
  • Ispirer MnMTK converts functions depending on argument's types

Oracle:

  1. CREATE TABLE hanbai_t (c1 DATE, c2 NUMBER);
  2.  
  3. SELECT trunc(c1, 'YEAR'), trunc(c2) FROM hanbai_t;
  4.  
  5. SELECT to_timestamp('2012-06-14','RRRR-MM-DD HH24') FROM t;

HiRDB:

  1. CREATE TABLE hanbai_t (c1 TIMESTAMP, c2 FLOAT);
  2.  
  3. SELECT truncyear(c1), trunc(c2) FROM hanbai_t;
  4.  
  5. SELECT timestamp_format('2012-06-14','YYYY-MM-DD HH') FROM t;

Comments conversion:

Oracle:

  1. -- comment1
  2. REM comment2
  3. REMARK comment3

HiRDB:

  1. /*comment1*/
  2. /*comment2*/
  3. /*comment3*/

This demo shows how Ispirer MnMTK can migrate Oracle to HiRDB database:



Ispirer MnMTK allows to convert a project with Embedded SQL to HiRDB. Ispirer MnMTK converts Pro*Cobol and Pro*C files with Oracle Embedded SQL. You can also have a look at how Ispirer MnMTK database migration tool can migrate embedded SQL statements without extracting them from the application code:




Ispirer MnMTK Tool Features for Oracle to HiRDB Migration

  • Quick and Useful Conversion of SQL Scripts - You can easily start converting existing SQL scripts - DDL statements, SQL queries etc.
  • Conversion with Database Connection - Ispirer MnMTK can connect to Oracle, extract and convert the entire database or just specified objects and schemas
  • Generation of SQL scripts in HiRDB syntax
  • Command Line Support can help you automate the migration process
  • Migration Validation - The tool can compare the number of tables, the number of rows, and perform data validation for all or selected columns (based on primary keys or specified order clause)

Read more about Ispirer MnMTK Key Benefits at Why Ispirer.

If you are looking for a tool to convert Oracle to HiRDB we are here to provide you with one of the best-in-class migration solutions.

Try the Toolkit

Ispirer MnMTK 2017

Oracle to HiRDB

Data and SQL SQL Data

Estimate Your Project

Ispirer MnMATK 2017

Oracle to HiRDB

Download

Purchase the Toolkit

Ispirer MnMTK 2017

Oracle to HiRDB

Data and SQL SQL Data

Purchase Service

Ispirer Migration Service

Oracle to HiRDB

Data and SQL SQL Data

You can also reach us via Contacts page.

 
Oracle Databases

Oracle 12с, 11g, 10g, 9i, 8i, 8.0.x, 7.x

Oracle Exadata v2 and v1

Testimonials
November 7, 2014High Availability Systems Co. Ltd., Japan
Informix to Oracle Migration

"We first contacted Ispirer, our long-term migration partner, to discuss the challenging application migration situation we found ourselves in during a project for a...

...

September 1, 2014Continental Tire the Americas, LLC, United States
DB2 to Oracle Migration

"Recently it became necessary to migrate our existing DB2 database into an Oracle environment. Our migration required that all tables, data, triggers and functions...

...

Case Studies
May 27, 2014Oracle to MySQL Migration, India

Our client was a major IT company with corporate headquarters in the United States and India. The company has several Fortune India 500 as well as global clients, and specializes in delivering...

...

January 1, 2013Oracle to PostgreSQL Migration, Japan

In cooperation with our solution partner in Japan, Ispirer executed a short-term migration project for a subsidiary of a grand, reputed Tokyo-based telecommunications company. The subsidiary is...

...

Feedback

I’ve just tested your tool and I’ve really appreciated the high quality of the conversion, the tool is easy and pleasant to use.

Read more
Industry Events