From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | "Josh Harrison" <joshques(at)gmail(dot)com>, "General postgres mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Online Oracle to Postgresql data migration |
Date: | 2008-01-11 18:22:20 |
Message-ID: | EE7629DC-102A-4516-A37D-0B4BD9CFE3B4@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote:
> On Jan 11, 2008 12:02 PM, Josh Harrison <joshques(at)gmail(dot)com> wrote:
>> Hi
>> We have an Oracle production database with some terbytes of data.
>> We wanted
>> to migrate that to Postgresql (rigt now...a test database and not
>> production) database.
>> What are the good options to do that?
>> Please advise me on where to look for more information on this topic
>
> You're going to need to use your brain for a fair portion of this,
> because how you use oracle will be just different enough from everyone
> else that no boxed solution.
>
> You have two steps to work on. The first is the DDL, to create
> equivalent tables in pgsql as in oracle, the second is to migrate over
> your data.
>
> I've generally done the ddl conversion by hand in an editor, and
> migrated data over with some scripting language like perl or php.
Another option is to talk to the folks at EnterpriseDB as Oracle-
Postgres compatibility is their specialty.
Erik Jones
DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Harrison | 2008-01-11 18:44:59 | Re: Online Oracle to Postgresql data migration |
Previous Message | Erik Jones | 2008-01-11 18:20:56 | Re: Search connections created per day |