5 files changed, 55 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index ef4bd3602dea..885833c2c17a 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -242,6 +242,7 @@
     SUBDIR += openark-kit
     SUBDIR += opendbx
     SUBDIR += opentsdb
+    SUBDIR += ora2pg
     SUBDIR += oracle8-client
     SUBDIR += p5-Amazon-SimpleDB
     SUBDIR += p5-Amon2-DBI
diff --git a/databases/ora2pg/Makefile b/databases/ora2pg/Makefile
new file mode 100644
index 000000000000..3bc66d91d400
--- /dev/null
+++ b/databases/ora2pg/Makefile
@@ -0,0 +1,30 @@
+# Created by: Jov amutu@amutu.com
+# $FreeBSD$
+
+PORTNAME=	ora2pg
+PORTVERSION=	18.1
+DISTVERSIONPREFIX=	v
+CATEGORIES=	databases
+
+MAINTAINER=	amutu@amutu.com
+COMMENT=	Oracle to PostgreSQL database schema converter
+
+LICENSE=	GPLv3
+
+BUILD_DEPENDS=	p5-Class-DBI-Pg>=0:databases/p5-Class-DBI-Pg \
+		p5-Class-DBI-mysql>=0:databases/p5-Class-DBI-mysql \
+		p5-Class-DBI-Oracle>=0:databases/p5-Class-DBI-Oracle
+
+RUN_DEPENDS:=	${BUILD_DEPENDS}
+
+USES=		perl5
+USE_PERL5=	configure
+USE_GITHUB=	yes
+GH_ACCOUNT=	darold
+
+do-patch:
+	${REINPLACE_CMD} -e '/install_all :/,/};/s=$$CONFDIR=${STAGEDIR}${ETCDIR}=g' \
+		-e '/install_all :/,/};/s=$$DOCDIR=${STAGEDIR}${DOCSDIR}=g' \
+		${WRKSRC}/Makefile.PL
+
+.include <bsd.port.mk>
diff --git a/databases/ora2pg/distinfo b/databases/ora2pg/distinfo
new file mode 100644
index 000000000000..a1b0d6c76e28
--- /dev/null
+++ b/databases/ora2pg/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1496212996
+SHA256 (darold-ora2pg-v18.1_GH0.tar.gz) = b8d330b4b4f57d3bc32624880e37f25077656be6c4b5c9f8e9042a6ea83e20da
+SIZE (darold-ora2pg-v18.1_GH0.tar.gz) = 358395
diff --git a/databases/ora2pg/pkg-descr b/databases/ora2pg/pkg-descr
new file mode 100644
index 000000000000..38b8e4ed8b60
--- /dev/null
+++ b/databases/ora2pg/pkg-descr
@@ -0,0 +1,10 @@
+Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL
+compatible schema. 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. Ora2Pg can be used from reverse
+engineering Oracle database to huge enterprise database migration or simply
+to replicate some Oracle data into a PostgreSQL database. It is really easy
+to used and doesn't need any Oracle database knowledge than providing the
+parameters needed to connect to the Oracle database.
+
+WWW: https://github.com/darold/ora2pg
diff --git a/databases/ora2pg/pkg-plist b/databases/ora2pg/pkg-plist
new file mode 100644
index 000000000000..d60f3a3714fe
--- /dev/null
+++ b/databases/ora2pg/pkg-plist
@@ -0,0 +1,11 @@
+bin/ora2pg
+bin/ora2pg_scanner
+%%ETCDIR%%/ora2pg.conf.dist
+%%SITE_PERL%%/Ora2Pg.pm
+%%SITE_PERL%%/Ora2Pg/GEOM.pm
+%%SITE_PERL%%/Ora2Pg/MySQL.pm
+%%SITE_PERL%%/Ora2Pg/PLSQL.pm
+%%PERL5_MAN3%%/ora2pg.3.gz
+%%PORTDOCS%%%%DOCSDIR%%/INSTALL
+%%PORTDOCS%%%%DOCSDIR%%/README
+%%PORTDOCS%%%%DOCSDIR%%/changelog