Download

Download the latest binary distribution here .



If you have not yet downloaded the required JDBC database drivers for your migration, please do so now. Try using the vendor's JDBC driver instead of jdbc:odbc driver. Ensure that your JDBC drivers are set in the CLASSPATH or within the /lib directory of opendbcopy.

Install

Install the binary distribution using the following command:



java -jar opendbcopy-xx-install.jar (substitute xx with version number you have downloaded)



A setup wizard will guide you through the installation.



Non Windows users please modify security properties of start.sh. Opendbcopy requires execution right.

Run

Linux / Mac OS10 / Unix users please use the provided start.sh script to launch opendbcopy.



Windows users may launch opendbcopy via Icon, Start Menu or start.bat.

Configure Database Migration Project

• Choose single or dual database mode (in most cases you may want to use dual mode)
• Provide database URL, user name and password if required
• Once tested you can choose catalog/schema to capture
• Once captured you can define which tables shall be processed. If the Destination Table Column is empty click on it and choose from available destination tables.
• On the Column Mapping tab you can speci fy column mappings for each table marked to process. If a destination column is empty, click on it and choose from available unmapped destination columns. For each table to process a SQL filter can additionaly be specified and tested.
• Select String filters to apply
• Select the plugin to execute and go for a coffee ...
• Execution log is saved in /logs directory, same for application log. By default all plugins save output within this directory!