Skip to main content

How to install edb-jdbc package and Oracle JDBC to use Migration tool kit (MTK)

Kshitija Karpe
  • Updated

To use the migration toolkit on Ubuntu 22.04 arch=x86_64, you will need to install the JDBC package.

Installing a JDBC driver

  • To migrate to or from EDB Postgres Advanced Server, use the EDB JDBC driver.

steps to install edb-jdbc driver (jdbc connector)

1. Install the edb-jdbc package (jdbc connector)

sudo apt-get -y install edb-jdbc

2. Install migration toolkit

sudo apt-get -y install edb-migrationtoolkit

3. After installing MTK, symbolic link for edb-jdbc.jar gets created. Check for jar symbolic link in /usr/edb/migrationtoolkit/lib 

 ls -l /usr/edb/migrationtoolkit/lib/edb-jdbc18.jar

Note : If you have installed MTK before installing edb-jdbc package, then you will need to copy edb-jdbc18.jar to /usr/edb/migrationtoolkit/lib/  and check for the jar in /usr/edb/migrationtoolkit/lib/

4. Check for connection.

  • To migrate from Oracle, utilise the freely available source-specific JDBC driver.

steps to install Oracle JDBC driver

1. Download  Oracle JDBC file ojdbc8.jar 

sudo wget https://download.oracle.com/otn-pub/otn_software/jdbc/235/ojdbc8.jar 

2. Copy ojdbc8.jar to /usr/edb/migrationtoolkit/lib/  

3. Check for ojdbc8.jar in /usr/edb/migrationtoolkit/lib

ls -l /usr/edb/migrationtoolkit/lib/ojdbc8.jar 

4. Check for connection.

  • To migrate to or from PostgreSQL, use the PostgreSQL JDBC driver.

steps to install PostgreSQL JDBC driver

1. Download  PostgreSQL JDBC file postgresql-42.7.4.jar

sudo wget https://jdbc.postgresql.org/download/postgresql-42.7.4.jar

2. Copy postgresql-42.7.4.jar to /usr/edb/migrationtoolkit/lib/  

3. Check for ojdbc8.jar in /usr/edb/migrationtoolkit/lib

ls -l /usr/edb/migrationtoolkit/lib/postgresql-42.7.4.jar

4. Check for connection.

 

Related documents

  • Document for installing jdbc_driver:

https://www.enterprisedb.com/docs/migration_toolkit/latest/installing/installing_jdbc_driver/

  • Document for edb-jdbc package (jdbc connector):

https://www.enterprisedb.com/docs/jdbc_connector/latest/installing/linux_x86_64/jdbc_ubuntu_22/

  • Document for installing the Migration Toolkit:

https://www.enterprisedb.com/docs/migration_toolkit/latest/installing/linux_x86_64/mtk_ubuntu_22/

  • Document for connection check:

https://www.enterprisedb.com/docs/migration_toolkit/latest/06_building_toolkit.properties_file/