EXperDB DB2PG Save Abandoned

eXperDB-DB2PG: Data Migration tool for PostgreSQL

Introduction

eXperDB-DB2PG is a data migration tool from heterogeneous DBMS to eXperDB (PostgreSQL).
DDL extraction after converting objects (Table, View, Sequence, Index, Constraint) of heterogeneous DBMS to PostgreSQL grammar.
It works on JAVA basis, so there is no restriction on platforms such as Unix, Linux and Windows, and installation is not necessary and can be used easily.

Features

• Export full data or using WHERE clause.
• Export Oracle Spatial data to PostGIS.
• Export Oracle CLOB, BLOB object to PostgreSQL BYTEA.
• Support for any platform such as Linux and Windows.
• Faster than PostgreSQL COPY function.
• Removing FK and INDEX before performing data import operation(Rebuild after termination).
• Data export using select query is supported.
• Selective extraction through exclusion table.
• Support for Oracle, Oracle Spatial, SQL Server, Sybase, DB2, Mysql, Sybase, Altibase, Cubrid.

System Requirements

• OS : Developed and tested on Linux and Windows, but work on any UNIX-like system and Windows System
• JDK : JDK 1.8 or later
• Storage : With the SAM(Sequential Access Method) file, you need to enough free space to store the original data when transferring data.
• From : Oracle(Including Oracle Spatial), SQL Server, MySQL, Sybase
• To : eXperDB, PostgreSQL

How to use

1. DB2PG DOWNLOAD(db2pg-vXX.X.X-linux64.tar)

2. db2pg-vXX.X.X-linux64.tar decompress

  tar -xvf db2pg-vXX.X.X-linux64.tar
   

3. Grant execution permission

  chmod 755 *.sh
  

4. setup.sh execution

  ./setup.sh
  

5. Create the db2pg.config file (Migration basic setting)

  vi db2pg.config
  
  ## Specifies whether to migrate data from the source DB to the target DB.
  DB_WRITER_MODE = true
  
  ## Source DBMS Connection Information
  SRC_HOST=
  SRC_USER=
  SRC_PASSWORD=
  SRC_DATABASE=
  SRC_SCHEMA=
  SRC_DB_TYPE=ORA
  SRC_PORT=1521
  SRC_DB_CHARSET=UTF8
  
  ## Specify the migration table in the source DBMS.
  ## Separate tables with [,]
  SRC_INCLUDE_TABLES=table1,table2,table3
  
  ## Target DBMS Connection Information
  TAR_HOST=
  TAR_USER=
  TAR_PASSWORD=
  TAR_DATABASE=
  TAR_SCHEMA=
  TAR_DB_TYPE=POG
  TAR_PORT=5432
  TAR_DB_CHARSET=UTF8
  TAR_CONN_COUNT=1

  ## Specifies whether to perform the Truncate command before data is migrated.
  TAR_TRUNCATE=true

6. START DB2PG

  ./db2pg -c db2pg.config

Introduction and Manual Download

License

Copyright

Copyright (c) 2016-2021, eXperDB Development Team All rights reserved.

Community

• https://www.facebook.com/experdb
• http://cafe.naver.com/psqlmaster