From: | Jeff Johnston <jeff(dot)johnston(dot)mn(at)gmail(dot)com> |
---|---|
To: | Michael Bostock <bostock83(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Ingres to Postgres migration |
Date: | 2014-04-30 13:34:45 |
Message-ID: | CABBVk+o-uUpFPjGFDfykfu9HfqJqArZ+fhvK+o-y_4u+tsrivA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We moved from Oracle to PostgreSQL recently and just used the \copy command
with csv files. To get the data out of oracle we wrote a small php script
to connect to Oracle and then generate the csv files. The way it works is
each csv file represented a database table. The copy command is amazingly
fast...like faster than you would think is possible. I did have to do the
database schema by hand, but we only had 110 tables so it was pretty easy.
And by hand I mean I used an Oracle client tool to grab the
table/index/sequence creation sql and then copied that into a separate
file. It worked really well and wasn't that much work. It also gave me a
chance to clean up the schema.
I did spend some time looking at tools (scripts, frameworks) to do the
migration automatically but none worked very well. With the \copy command
you really have all you need.
On Wed, Apr 30, 2014 at 8:06 AM, Michael Bostock <bostock83(at)gmail(dot)com>wrote:
> Hi,
>
> We are using an old version of Ingres (3.0.1) and I have been asked to
> investigate the possibility of migrating to PostgreSQL (9.3.4). I was just
> wondering if there is any general advice you can give me or if there are
> any details/tools that will help with the migration.
>
> Thanks,
> Mike
>
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2014-04-30 13:51:18 | Re: Altering array(composite-types) without breaking code when inserting them and similar questions |
Previous Message | Rob Sargentg | 2014-04-30 13:19:17 | Re: importing a messy text file |