Re: How to convert Oracle database to Postgresql.
От | Shridhar Daithankar |
---|---|
Тема | Re: How to convert Oracle database to Postgresql. |
Дата | |
Msg-id | 3EF0AB6D.11302.675C51C@localhost обсуждение исходный текст |
Ответ на | Re: How to convert Oracle database to Postgresql. ("Wayne Armstrong" <wdarmst@bacchus.com.au>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: