Ora2Pg Migrates Oracle databases to PostgreSQL

Help support Ora2Pg!

 

Requirement

You need a modern Perl distribution (perl 5.6 and above), the DBI and DBD::Oracle Perl modules to be installed. These are used to connect to the Oracle database. 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.

Note that the Oracle and the PostgreSQL databases doesn't need to be on the host running Ora2Pg but this host must have at least the Oracle client libraries installed and the PostgreSQL client if you want to use psql or DBD::Pg to import data.

Optional

By default Ora2Pg dumps export to flat files, to load them into your PostgreSQL database you need the PostgreSQL client (psql). 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. If you prefer to load export 'on the fly', the perl module DBD::Pg is required.

Ora2Pg allow output compression as gzip file, to do that you need the Compress::Zlib Perl module. If you prefer using bzip2 compression, program bzip2 must be available.

Installing Ora2Pg

Like any other Perl Module installation Ora2Pg can be installed with the following commands:

	tar xjf ora2pg-8.7.tar.bz2
	cd ora2pg-8.7/
	perl Makefile.PL
	make && make install

This will install Ora2Pg.pm into your site Perl repository, ora2pg into /usr/local/bin/ and ora2pg.conf into /etc/ora2pg/.

Packaging

If you want to build binary package for your prefered Linux distribution take a look at the packaging/ directory of the source tarball. There's everything to build RPM, Slackware and Debian packages. See README file in that directory.