From: David A. Leedom <daleedom@hightowergroup.com>
To: Gourish Singbal <gourish@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Need help in data migration
Date: Thu, 05 May 2005 08:46:31 -0400
Message-ID: <6.1.2.0.2.20050505084425.0322f048@mail.hightowergroup.com> (raw)
In-Reply-To: <674d1f8a05050505224f231a5c@mail.gmail.com>
References: <674d1f8a05050505224f231a5c@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: daleedom@hightowergroup.com, gourish@gmail.com
Subject: Re: Need help in data migration
In-Reply-To: <6.1.2.0.2.20050505084425.0322f048@mail.hightowergroup.com>
References: <674d1f8a05050505224f231a5c@mail.gmail.com> <6.1.2.0.2.20050505084425.0322f048@mail.hightowergroup.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox