Installing a JDBC driver v55

Suggest edits

Migration Toolkit requires Java version 1.8.0 or later.

Choosing a driver

Your selection of the JDBC drivers to use depends on the databases you're migrating from and to. For example, if you're migrating from Oracle to EDB Postgres Advanced Server, you need the Oracle JDBC driver and the EDB JDBC driver.

  • If you're migrating to or from EDB Postgres Advanced Server, use the EDB JDBC driver. To download the latest driver, see EDB Connectors on the EDB Downloads page. For installation instructions, see Installing and configuring EDB JDBC Connector.

    Note

    The EDB JDBC driver is not available for Mac OS.

  • If you're migrating to or from PostgreSQL, use the PostgreSQL JDBC driver. To download the latest supported driver, see the JDBC drivers section on the PostgreSQL Downloads page.

  • If you're migrating from Oracle, MySQL, Microsoft SQL Server, or Sybase, use the freely available, source-specific JDBC driver:

    Note

    The open-source jTDS driver also supports older versions of Microsoft SQL Server (version 2012 and earlier) and can be used with Migration Toolkit. We recommend the Microsoft-provided JDBC driver for SQL Server for the newer versions of SQL Server supported by Migration Toolkit.

Adding the driver to lib

After downloading the driver, move the driver file into the <mtk_install_dir>/lib directory.

For the EDB JDBC driver

If the EDB JDBC driver is installed prior to installing Migration Toolkit it should not be necessary to place a copy of it in the <mtk_install_dir>/lib directory. A symbolic link to the edb-jdbc18.jar file is created during installation of Migration Toolkit.

After installing Migration Toolkit, you can verify whether the symbolic link exists by executing the following command:

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

Installing Migration Toolkit on SLES 15 ppc64le

↑ Up

Installing Migration Toolkit

Next →

Installing on Mac OS X