Installing a JDBC driver v55
Migration Toolkit requires Java version 1.8.0 or later.
Choosing a driver
Which JDBC drivers you use depends on the source and target databases for the migration. For example, to migrate from a Oracle Database instance to EDB Postgres Advanced Server, you require the Oracle Database JDBC driver and the EDB JDBC driver.
These are reference sources where JDBC drivers are freely available for download. However, there are other sources where you can obtain the same drivers.
| Source or target database | JDBC driver |
|---|---|
| PostgreSQL | PostgreSQL JDBC driver |
| EDB Postgres Advanced Server | EDB JDBC connector |
| Oracle Database | Oracle Database JDBC driver |
| Microsoft SQL Server | Microsoft JDBC driver for SQL Server |
| MySQL | Connector/J JDBC driver |
| SAP Adaptive Server Enterprise (ASE) | Sybase ASE (jTDS) JDBC driver (See note) |
Note
The open-source jTDS driver also supports older versions of Microsoft SQL Server (version 2012 and earlier) and may be used with Migration Toolkit. The Microsoft-provided JDBC driver for SQL Server is recommended for the newer versions of SQL Server supported by Migration Toolkit.
Driver version compatibility
After selecting the appropriate drivers for your migration, verify that their versions are compatible with the Migration Toolkit you are using. EDB recommends using the latest available version of the Migration Toolkit to ensure broader compatibility with various database versions and JDBC drivers.
- If you're migrating from Oracle, MySQL, Microsoft SQL Server, or Sybase, use the freely available, source-specific JDBC driver:
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
- On this page
- Choosing a driver
- Adding the driver to lib