From owner-freebsd-ports Mon Jul 15 6:20:14 2002 Delivered-To: freebsd-ports@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9246737B400 for ; Mon, 15 Jul 2002 06:20:02 -0700 (PDT) Received: from freefall.freebsd.org (freefall.FreeBSD.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id EDB8343E4A for ; Mon, 15 Jul 2002 06:20:01 -0700 (PDT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.4/8.12.4) with ESMTP id g6FDK1JU007381 for ; Mon, 15 Jul 2002 06:20:01 -0700 (PDT) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.4/8.12.4/Submit) id g6FDK1Vh007380; Mon, 15 Jul 2002 06:20:01 -0700 (PDT) Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F35DA37B400 for ; Mon, 15 Jul 2002 06:13:50 -0700 (PDT) Received: from freebsdcluster.org (freebsdcluster.dk [195.184.98.178]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4C7D043E42 for ; Mon, 15 Jul 2002 06:13:50 -0700 (PDT) (envelope-from mich@freebsdcluster.org) Received: by freebsdcluster.org (Postfix, from userid 1001) id C9FAAAC703; Mon, 15 Jul 2002 15:13:43 +0200 (CEST) Message-Id: <20020715131343.C9FAAAC703@freebsdcluster.org> Date: Mon, 15 Jul 2002 15:13:43 +0200 (CEST) From: "Michael L.Hostbaek" Reply-To: "Michael L.Hostbaek" To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/40595: New port: databases/ora2pg Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org >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 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