On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote:
On Jan 11, 2008 12:02 PM, Josh Harrison <joshques@xxxxxxxxx> 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@xxxxxxxxxx
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
