Re: Oracle Conversions Tools

From: mikeo <mikeo(at)spectrumtelecorp(dot)com>
To: "Erich K(dot) Oliphant" <ericho(at)vantixnet(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle Conversions Tools
Date: 2000-09-19 12:59:03
Message-ID: 3.0.1.32.20000919085903.00937160@pop.spectrumtelecorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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><<<<<<<<

Attachment Content-Type Size
unknown_filename text/enriched 1.6 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philipp Käser 2000-09-19 13:33:40 libpq: large objects
Previous Message Danny 2000-09-19 12:06:19 Psql Question