Re: How to convert Oracle database to Postgresql.

On 18 Jun 2003 at 22:33, Wayne Armstrong wrote:

> ** Reply to message from "Carlos Oliva" <carlos(at)pbsinet(dot)com> on Wed, 18 Jun
> 2003 08:12:00 -0400
> Hi Carlos,
> We've just been through this recently.
> We used db2look to get the ddl for the database, ran some editing scripts over
> it (just ex) and fed that into postgres.
> To load data from the db2 database, I wrote a smalltalk program that for each
> table, read from the db2 dtabase and inserted into the postgres database. The
> smalltalk needs no prior knowledge of the table layouts to do that- queries
> syscat.tables in the db2 database to get a list of tables etc. You are welcome
> to the smalltalk executable (and source if you want it (it is not really
> production code though :) )
>
> We used bytea in place of blob.
> Triggers we did manually (we are not big users of triggers).
>
> All in all it was pretty easy. Places we came unstuck were on views using the
> "with temp" syntax, and some recursive sql which we rewrote using pgplsql and
> temp tables. Also Db2 will hapilly store 24:00:00 as well as 00:00:00 for
> midnight. It's worth updateing any occurennces of 24:00:00 to 00:00:00 before
> you convert.

I would say this is worth a HOWTO. Would you do that?

Bye
Shridhar

--
Decision maker, n.: The person in your office who was unable to form a task
force before the music stopped.