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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Shridhar
Daithankar
Sent: Wednesday, June 18, 2003 8:42 AM
To: pgsql-general(at)postgresql(dot)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(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.

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