Like any other Perl Module Ora2Pg can be installed with the following commands: tar xjf ora2pg-x.x.tar.bz2 Ora2Pg allows you to dump all output in a compressed gzip file, to do that you need the Compress::Zlib Perl module or if you prefer using bzip2 compression, the program bzip2 must be available in your PATH. If you prefer to load export ‘on the fly’, the perl module DBD::Pg is required. If you don’t have it on the host running Ora2Pg you can always transfer these files to a host with the psql client installed. Optionalīy default Ora2Pg dumps export to flat files, to load them into your PostgreSQL database you need the PostgreSQL client (psql). On some Perl distribution you may need to install the Time::HiRes Perl module. If you plan to export a MySQL database you need to install the Perl module DBD::mysql which requires that the mysql client libraries are installed. To install DBD::Oracle and have it working you need to have the Oracle client libraries installed and the ORACLE_HOME environment variable must be defined. These modules are used to connect to the database but they are not mandatory if you want to migrate DDL input files. To migrate a MySQL database you need the DBD::MySQL Perl modules. To migrate an Oracle database you need the DBD::Oracle Perl modules to be installed. To connect to a database and proceed to his migration you need the DBI Perl module > 1.614. You also need a modern Perl distribution (perl 5.10 and more). Or simply download the corresponding ZIP archives from Oracle download center and install them where you want, for example: /opt/oracle/instantclient_12_2/ You can download the RPM from Oracle download center: rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm The Oracle Instant Client or a full Oracle installation must be installed on the system. Installing the free version of ActiveState Perl ( ) could help as they seems to have an already packaged DBD::Oracle easy to install. It seems that compiling DBD::Oracle from CPAN on Windows can be a struggle and there be little documentation on that (mostly outdated and not working).

Under Windows you should install Strawberry Perl ( ) and the OSes corresponding Oracle clients. Just type the full name of the module (ex: DBD::Oracle) into the search input box, it will brings you the page for download. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.Īll Perl modules can always be found at CPAN ( ).

Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema.

Activeperl 5.14.2 free download