i have written a few programs in perl that produce create table and index
scripts and also will produce a pipe delimited,(you can always change the
delimiter),
data file. i used these to transfer my oracle "stuff" to postgres at the
beginning
of our conversion. i'd be more than happy to share them with you and you
can modify
them to suit your specific needs. let me know...
mikeo
At 03:53 PM 9/18/00 -0400, Erich K. Oliphant wrote:
>>>>
<excerpt><smaller>Hi,
I've been poking through the archive and PostgreSQL sites looking for
tools that would allow me to migrate from an Oracle DB. I'm getting the
impression that there aren't any. Are there any projects underway to
work on a tool like this (or a general Other DB -> PostgreSQL framework)?
If not would anyone be interested in starting one up or working on it?
</smaller>
<smaller>I think that this would help PostgreSQL enormously. It's one
thing thing to have a great OpenSource product but another to get
acceptance in the "enterprise". I think one of Linux's undersung killer
apps is Samba, because it greatly reduces the pain of moving to
Linux/UNIX. By the same token, If I can pop up a window, go through a
few dialogs, and end up with a PostgreSQL schema that makes this a lot
easier to sell. Granted converting PL/SQL and what have you is just a
bit more complicated :-) But I think at least a schema and data
migration tool would be a powerful addition to the PostgreSQL arsenal.
</smaller>
<smaller>Just my two cents,
Erich
</smaller>
Attachment Converted: "C:\TEMP\smime2.p7s"
</excerpt><<<<<<<<