Date: Mon, 15 Jul 2002 15:13:43 +0200 (CEST) From: "Michael L.Hostbaek" <mich@freebsdcluster.org> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/40595: New port: databases/ora2pg Message-ID: <20020715131343.C9FAAAC703@freebsdcluster.org>
next in thread | raw e-mail | index | archive | help
>Number: 40595 >Category: ports >Synopsis: New port: databases/ora2pg >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Mon Jul 15 06:20:01 PDT 2002 >Closed-Date: >Last-Modified: >Originator: Michael L. Hostbaek >Release: FreeBSD 4.6-STABLE i386 >Organization: FreeBSDCluster.org >Environment: System: FreeBSD freebsdcluster.dk 4.6-STABLE FreeBSD 4.6-STABLE #0: Sat Jul 6 13:54:50 CEST 2002 root@freebsdcluster.dk:/space1/usr-linked/obj/space1/usr-linked/src/sys/COP_KERNEL_1 i386 >Description: Ora2Pg can export an Oracle DB to a PostgreSQL schema >How-To-Repeat: >Fix: # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # ora2pg/Makefile # ora2pg/distinfo # ora2pg/pkg-comment # ora2pg/pkg-descr # ora2pg/pkg-plist # echo x - ora2pg/Makefile sed 's/^X//' >ora2pg/Makefile << 'END-of-ora2pg/Makefile' X# ex:ts=8 X# Ports collection makefile for: ora2pg X# Date created: Thu Jun 13, 2002 X# Whom: Michael L. Hostbaek (mich@freebsdcluster.org) X# X# $FreeBSD$ X# X XPORTNAME= ora2pg XPORTVERSION= 1.9 XCATEGORIES= databases XMASTER_SITES= http://www.samse.fr/GPL/ora2pg/ \ X ${MASTER_SITE_LOCAL} X XMAINTAINER= mich@freebsdcluster.org X XRUN_DEPENDS= ${SITE_PERL}/${PERL_ARCH}/DBD/Oracle.pm:${PORTSDIR}/databases/p5-DBD-Oracle \ X ${SITE_PERL}/${PERL_ARCH}/DBI.pm:${PORTSDIR}/databases/p5-DBI \ X ${SITE_PERL}/${PERL_ARCH}/DBD/Pg.pm:${PORTSDIR}/databases/p5-DBD-Pg X XSITE_PERL= ${LOCALBASE}/lib/perl5/site_perl/${PERL_VER} XUSE_PERL5= yes XNO_BUILD= yes XWRKSRC= ${WRKDIR}/${PORTNAME} XDOCSDIR?= ${PREFIX}/share/doc/${PORTNAME} X Xdo-install: X ${INSTALL_SCRIPT} ${WRKSRC}/${PORTNAME}.pl ${PREFIX}/bin/${PORTNAME}.pl X ${INSTALL_SCRIPT} ${WRKSRC}/Ora2Pg.pm ${SITE_PERL}/Ora2Pg.pm X X.if !defined(NOPORTDOCS) X ${MKDIR} ${DOCSDIR} X ${INSTALL_DATA} ${WRKSRC}/README.ora2pg ${DOCSDIR}/README X ${INSTALL_DATA} ${WRKSRC}/TODO ${DOCSDIR}/TODO X ${INSTALL_DATA} ${WRKSRC}/CHANGES ${DOCSDIR}/CHANGES X ${INSTALL_DATA} ${WRKSRC}/ora2pg.html ${DOCSDIR}/ora2pg.html X.endif X X.include <bsd.port.mk> END-of-ora2pg/Makefile echo x - ora2pg/distinfo sed 's/^X//' >ora2pg/distinfo << 'END-of-ora2pg/distinfo' XMD5 (ora2pg-1.9.tar.gz) = 2eadb661b3ee4b42b58bf345277df1aa END-of-ora2pg/distinfo echo x - ora2pg/pkg-comment sed 's/^X//' >ora2pg/pkg-comment << 'END-of-ora2pg/pkg-comment' XOra2Pg can export an Oracle DB to a PostgreSQL schema END-of-ora2pg/pkg-comment echo x - ora2pg/pkg-descr sed 's/^X//' >ora2pg/pkg-descr << 'END-of-ora2pg/pkg-descr' XOra2Pg is a Perl module to export an Oracle database schema to a XPostgreSQL compatible schema. It connects your Oracle database, Xextracts its structure, and generates an SQL script that you can Xload into your PostgreSQL database. It dumps the database schema X(tables, views, sequences, indexes, grants) with primary, unique, Xand foreign keys into PostgreSQL syntax without editing the SQL Xcode generated. It also dump Oracle data into PostgreSQL DB as Xonline process or into a file. You can choose what columns can be Xexported for each table. X XRequires perl. X XWWW: http://www.samse.fr/GPL/ora2pg/ X X- Michael L. Hostbaek Xmich@freebsdcluster.org END-of-ora2pg/pkg-descr echo x - ora2pg/pkg-plist sed 's/^X//' >ora2pg/pkg-plist << 'END-of-ora2pg/pkg-plist' Xbin/ora2pg.pl Xlib/perl5/site_perl/%%PERL_VER%%/Ora2Pg.pm Xshare/doc/ora2pg/CHANGES Xshare/doc/ora2pg/README Xshare/doc/ora2pg/TODO Xshare/doc/ora2pg/ora2pg.html X@dirrm share/doc/ora2pg END-of-ora2pg/pkg-plist exit >Release-Note: >Audit-Trail: >Unformatted: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020715131343.C9FAAAC703>