Shift2Ingres - Migrate to Ingres now

Shift2Ingres
Migrate to Ingres now!

This project is hosted on

Covers most of the commonly used features!

Shift2Ingres migration toolkit covers most of the commonly used Oracle/DB2 database features. Stated below is the detailed list of the features being migrated by the toolkit right now.

Oracle to Ingres Migration Features | DB2 to Ingres Migration Features

Oracle to Ingres Migration feature list:

Data Migration
- Mapped Oracle Data Types:
  - Blob - Mapped to Long Byte
  - Char(n) - Mapped to Char(n)
  - Clob - Mapped to Clob
  - Date - Mapped to Date
  - Double Precision - Mapped to Float(53)
  - Float(n) - Mapped to Float(n). Maximum precision is set to 53. If no precision is provided 53 is used.
  - Long - Mapped to Clob
  - Long Raw - Mapped to Long Byte
  - Number(n,p) - Mapped to Decimal(n,p)
  - Raw(n) - Mapped to Byte Varying(n)
  - VarChar(n) - Mapped to VarChar(n)
  - VarChar2(n) - Mapped to VarChar(n)
  - Integer - Decimal(31,0)
- Un-Mapped Oracle Data Types:
  - BFile
  - Long Varchar
  - NChar(n)
  - NClob
  - NVarChar(n)
  - OID
  - RowID
  - URowID
  - User Defined Data Types
- Mapped Oracle Database Objects
  - Table
  - Index
  - Views
  - User
  - Sequences
  - Synonyms
  - PL/SQL Procedures
  - PL/SQL Functions
  - PL/SQL Triggers
- Un-Mapped Oracle Database Objects
  - Materialised Views
  - Pacakge/Package Body
  - Role
  - Rollback Segment
  - Schema
  - TableSpace
  - Temporary Table
Application Migration
- Application Interfaces
  - JDBC
    - Oracle Blob support
    - Upgradable (Read only - Write) locks
    - Oracle and DB2 look alike driver classes
  - Not implemented interfaces
    ODBC/Oracle Forms/OCI/Embb. SQL
- Mapped/Implemented Oracle Functions
  - Implemented using OME or QC Mapping
  - avg
  - chr
  - greatest
  - least
  - lpad
  - ltrim
  - trunc
  - round
  - replace
  - translate
  - to_date
  - to_char
  - is_empty_string
  - acos
  - asin
  - atan
  - atan2
  - bitand
  - ceil
  - cosh
  - sinh
  - tan
  - tanh
  - exp
  - floor
  - count
  - date
  - float8
  - length
  - long_byte
  - lower
  - max
  - min
  - upper
  - sum
  - varchar
  - ln
  - var_pop
  - var_samp
  - stddev_pop
  - stddev_samp
  - sqrt
  - soundex
  - sin
  - power
  - mod
  - covar_pop
  - covar_samp
  - regr_slope
  - regr_avgx
  - regr_avgy
  - regr_sxx
  - regr_sxy
  - regr_syy
  - regr_count
  - regr_intercept
  - regr_r2
  - corr
- Not Mapped/Implemented Oracle Functions
  - ADD_MONTHS
  - BFileName
  - CharToRowID
  - Dense_Rank
  - DeRef
  - Dump
  - LengthB
  - Make_ref
  - NLS_CharSet_Dec_Len
  - NLS_CharSet_ID
  - NLS_CharSet_Name
  - NLS_InitCap
  - NLS_Lower
  - NLSSort
  - NLS_Upper
  - UID
  - Sys_guid
  - Sys_Context
  - RowIDToChar
  - Ref
  - Ratio_To_Report
  - Rank
  - Percent_Rank
  - Cume_Dist
  - First_Value
  - Grouping
  - Instrb
  - Last_value
  - Lead
  - LenghtB
  - Variance
  - SubstrB
  - Row_Number
  - RefToHex
  - Round(date)
  - InitCap
  - Lag
  - CONVERT
  - Months_Between
  - New_Time
  - Ntile
  - Sign
  - StdDev
  - To_Char(date)
  - To_Lob
  - To_Multi_Byte
  - To_Single_Byte
  - UserEnv
  - Value
  - Vsize
  - User Defined Functions
- Mapped Oracle SQL Grammar Functions
  - Select
  - Update
  - Insert
  - Delete
  - Create
  - Alter
  - Drop

[ Back to top ]

DB2 to Ingres Migration feature list:

Data Migration
- Mapped Oracle Data Types:
  - Blob - Mapped to Long Byte
  - Char(n) - Mapped to Char(n)
  - Clob - Mapped to Clob
  - Date - Mapped to Date
  - Double Precision - Mapped to Float(53)
  - Float(n) - Mapped to Float(n). Maximum precision is set to 53. If no precision is provided 53 is used.
  - Long - Mapped to Clob
  - Long Raw - Mapped to Long Byte
  - Number(n,p) - Mapped to Decimal(n,p)
  - Raw(n) - Mapped to Byte Varying(n)
  - VarChar(n) - Mapped to VarChar(n)
  - VarChar2(n) - Mapped to VarChar(n)
  - Integer - Decimal(31,0)
- Un-Mapped Oracle Data Types:
  - Long Varchar
  - NChar(n)
  - NClob
  - NVarChar(n)
  - User Defined Data Types
- Mapped Oracle Database Objects
  - Table
  - Index
  - Views
  - User
  - Sequences
  - Synonyms
- Un-Mapped Oracle Database Objects
  - Materialised Views
  - Pacakge/Package Body
  - Rollback Segment
  - Schema
  - TableSpace
  - Temporary Table
Application Migration
- Application Interfaces
  - JDBC
    - Oracle Blob support
    - Upgradable (Read only - Write) locks
    - Oracle and DB2 look alike driver classes
  - Not implemented interfaces
    ODBC/Oracle Forms/OCI/Embb. SQL
- Mapped/Implemented Oracle Functions
  - Implemented using OME or QC Mapping
  - avg
  - chr
  - greatest
  - least
  - lpad
  - ltrim
  - trunc
  - round
  - replace
  - translate
  - to_date
  - to_char
  - is_empty_string
  - acos
  - asin
  - atan
  - atan2
  - bitand
  - ceil
  - cosh
  - sinh
  - tan
  - tanh
  - exp
  - floor
  - count
  - date
  - float8
  - length
  - long_byte
  - lower
  - max
  - min
  - upper
  - sum
  - varchar
  - ln
  - var_pop
  - var_samp
  - stddev_pop
  - stddev_samp
  - sqrt
  - soundex
  - sin
  - power
  - mod
  - covar_pop
  - covar_samp
  - regr_slope
  - regr_avgx
  - regr_avgy
  - regr_sxx
  - regr_sxy
  - regr_syy
  - regr_count
  - regr_intercept
  - regr_r2
  - corr
- Not Mapped/Implemented Oracle Functions
  - ADD_MONTHS
  - BFileName
  - CharToRowID
  - Dense_Rank
  - DeRef
  - Dump
  - LengthB
  - Make_ref
  - NLS_CharSet_Dec_Len
  - NLS_CharSet_ID
  - NLS_CharSet_Name
  - NLS_InitCap
  - NLS_Lower
  - NLSSort
  - NLS_Upper
  - UID
  - Sys_guid
  - Sys_Context
  - RowIDToChar
  - Ref
  - Ratio_To_Report
  - Rank
  - Percent_Rank
  - Cume_Dist
  - First_Value
  - Grouping
  - Instrb
  - Last_value
  - Lead
  - LenghtB
  - Variance
  - SubstrB
  - Row_Number
  - RefToHex
  - Round(date)
  - InitCap
  - Lag
  - CONVERT
  - Months_Between
  - New_Time
  - Ntile
  - Sign
  - StdDev
  - To_Char(date)
  - To_Lob
  - To_Multi_Byte
  - To_Single_Byte
  - UserEnv
  - Value
  - Vsize
  - User Defined Functions
- Mapped Oracle SQL Grammar Functions
  - Select
  - Update
  - Insert
  - Delete
  - Create
  - Alter
  - Drop

[ Back to top ]

All the code and documents are solely owned by the Shift2Ingres team. Shift2Ingres migration toolkit is available for public use under the BSD Open Source License.