| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Josh Harrison" <joshques(at)gmail(dot)com> |
| Cc: | "General postgres mailing list" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Online Oracle to Postgresql data migration |
| Date: | 2008-01-11 18:14:59 |
| Message-ID: | dcc563d10801111014q7055d08dpb9401e8e7efcb139@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2008-01-11 18:20:56 | Re: Search connections created per day |
| Previous Message | Scott Marlowe | 2008-01-11 18:11:59 | Re: Search connections created per day |