Re: How to convert Oracle database to Postgresql.

It would be great if besides SmallTalk, the scripts could be written in
plain Linux scripts or Python
Regards

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Shridhar
Daithankar
Sent: Wednesday, June 18, 2003 8:42 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to convert Oracle database to Postgresql.


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

> ** Reply to message from "Carlos Oliva" <carlos@pbsinet.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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)