X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6FEA353877 for ; Thu, 5 May 2005 09:40:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51253-06 for ; Thu, 5 May 2005 12:40:31 +0000 (GMT) Received: from hightowergroup.com (mail005.readyhosting.com [63.99.209.11]) by svr1.postgresql.org (Postfix) with ESMTP id 1F27B5383E for ; Thu, 5 May 2005 09:40:30 -0300 (ADT) Received: from hightower10.mail.hightowergroup.com [66.109.231.196] by hightowergroup.com with ESMTP (SMTPD32-8.05) id A43F1B0D00DC; Thu, 05 May 2005 07:40:31 -0500 Message-Id: <6.1.2.0.2.20050505084425.0322f048@mail.hightowergroup.com> X-Sender: dleedom@hightowergroup.com@mail.hightowergroup.com X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Thu, 05 May 2005 08:46:31 -0400 To: Gourish Singbal , pgsql-admin From: "David A. Leedom" Subject: Re: Need help in data migration In-Reply-To: <674d1f8a05050505224f231a5c@mail.gmail.com> References: <674d1f8a05050505224f231a5c@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_218005875==.ALT" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.805 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200505/48 X-Sequence-Number: 17477 --=====================_218005875==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Gourish I have worked on a similar project If you are interested give me a call or we can go back and forth here. Enthusiastically, Dave Leedom At 08:22 AM 5/5/2005, Gourish Singbal wrote: >I need help to transfer data from postgreql to oracle database on >regular basis. > >The original productin application runs on oracle. >We need this setup temporarily for certain time period till we are >confortable that our application can survive on postgresql. > >Please help if somebody has worked on such projects. > >I tried taking pg_dump as follows from postgresql 7.4.5 > >pg_dump -t tablename_test -a -D -O rpt_production > tablename_test.sql > >and than ran below on oracle but i got many errors. >One reason i can think of is becase i have column names like > "version", "type", in the insert command?. > >SQL>@$HOME/tablename_test.sql > >Am i misssing any thing >please help >Awaiting reply >-- >Best, >Gourish Singbal > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings The Hightower Group, Inc. Custom Software Solutions Designed To Fit Your Business Like A Glove. 165 West Airport Road, Suite B/Lititz, PA 17543 V:717-560-4002, 877-560-4002 x: 114 F:717-560-2825 www.hightowergroup.com --=====================_218005875==.ALT Content-Type: text/html; charset="us-ascii" Gourish

I have worked on a similar project

If you are interested give me a call or we can go back and forth here.

Enthusiastically,

Dave Leedom

At 08:22 AM 5/5/2005, Gourish Singbal wrote:
I need help to transfer data  from postgreql to oracle database on
regular basis.

The original productin application runs on oracle.
We need this setup temporarily for certain time period till we are
confortable that our application can survive on postgresql.

Please help if somebody has worked on such projects.

I tried taking pg_dump as follows from postgresql 7.4.5

pg_dump -t tablename_test -a -D -O rpt_production > tablename_test.sql

and than ran below on oracle but i got many errors.
One reason i can think of is becase i have column names like
 "version", "type", in the insert command?.

SQL>@$HOME/tablename_test.sql

Am i misssing any thing
please help
Awaiting reply
--
Best,
Gourish Singbal

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



The Hightower Group, Inc.
Custom Software Solutions Designed To Fit Your Business Like A Glove.
165 West Airport Road, Suite B/Lititz, PA 17543
V:717-560-4002, 877-560-4002 x: 114
F:717-560-2825
www.hightowergroup.com --=====================_218005875==.ALT--