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/