EDB Migration Toolkit supports migrate data from following databases to BigAnimal:
- Oracle
- EDB Postgres Advanced Server(EPAS)
- PostgreSQL
- MySQL
- SQL Server
Document has the configuration instructions.
Frequently Asked Questions
Q:Does Migration Toolkit support migrate data to both BigAnimal database types?
A: BigAnimal supports PostgreSQL and Oracle Compatible database type. Both are supported by Migration Toolkit.
At `postgres_type` at the connection properties — Specify `edb` if you're using Oracle Compatible or `postgresql` if you're using PostgreSQL.
Q: Is there an example of `TARGET_DB_URL` at `toolkit.properties`?
A: The sample for BigAnimal `Oracle Compatible`:
TARGET_DB_URL=jdbc:edb://p-hclnrngoqn.xgv7pbg.biganimal.io:5432/targetdb?sslmode=require
The sample for BigAnimal `PostgreSQL`:
TARGET_DB_URL=jdbc:postgresql://p-zwvfm6n34l.xgv7pbg.biganimal.io:5432/targetdb?sslmode=require
Q: Do `-targetdbtype` and `-sourcedbtype` require to be set at `runMTK` command?
A: If they are not set, default is Oracle to EPAS.
-sourcedbtype db_type The -sourcedbtype option specifies the source database type. db_type may be one of the following values: mysql, oracle, sqlserver, sybase, postgresql, enterprisedb. db_type is case-insensitive. By default, db_type is oracle.
-targetdbtype db_type The -targetdbtype option specifies the target database type. db_type may be one of the following values: oracle, sqlserver, postgresql, enterprisedb. db_type is case-insensitive. By default, db_type is enterprisedb.
Q: Any common connection errors?
| MTK version | Connection errors | Solution |
| Version 55.2.3 | Connecting with target EDB Postgres database server... MTK-11009: Error Connecting Database "EDB Postgres" java.lang.NullPointerException: Cannot invoke "java.sql.Connection.createStatement()" because "this.conn" is null |
To resolve this error, check if `-targetdbtype` is set correctly at `runMTK`. For example, use default `enterprisedb` on PostgreSQL can trigger the error. |
| Version 55.2.3 | Connecting with target EDB Postgres database server... MTK-11009: Error Connecting Database "EDB Postgres" DB-08001: com.edb.util.PSQLException: The connection attempt failed. java.net.UnknownHostException: p-hclnrngoqn.xgv7pbgfawhhnakq.biganimal.io |
To resolve this error, check if `TARGET_DB_URL` is set correctly at `toolkit.properties`. For example, use `jdbc:edb://$HOSTNAME:5432/DB` on PostgreSQL can trigger the error. |
| Version 55.2.2 | Connecting with target EDB Postgres database server... MTK-11009: Error Connecting Database "EDB Postgres" java.lang.NullPointerException |
To resolve this error, check if `-targetdbtype` is set correctly at `runMTK`. For example, use default `enterprisedb` on PostgreSQL can trigger the error. |