Re: [GENERAL] Oracle to Pg tool
Hi, Another point regarding /contrib or other directory like /tools is to centralize tools for Pg. Also I can't be sure to always have an URL. This one is dependant on the company I'm working now. Life is moving. Regards Bruce Momjian wrote: > [ Charset US-ASCII unsupported, converting... ] > > Hi All, > > > > I'm willing to put all PostgreSQL related matter on the techdocs site, > > or link to it, as the case may be. Is that of any assistance? > > > > Some stuff is definitely better in /contrib, as it is "already there" > > with PostgreSQL, some stuff might not be. Database conversion tools > > probably are better in /contrib is my thought though... time to > > clarify rules? > > My first guess is that loadable modules clearly should be in /contrib, > and tools like pg_controldata, and things that workaround missing > features in PostgreSQL. > > Looking in /contrib, that is pretty much what we have. Now, that leaves > conversion tools as "unknown". You are voting the belong in /contrib? > If I get another "yes", I will add the xbase and Oracle tools in there > too. > > -- > Bruce Momjian| http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Oracle to Pg tool
On Wed, 9 May 2001, Bruce Momjian wrote: > > Where do people want this. Should it be in /contrib or on its own web > page? This is already linked on the related page. > I have an Xbase conversion utility too. Where should that go? What's the URL? > > > > Hi, > > > > As I previous searched a tool to convert Oracle database to PostgreSQL > > and really found nothing, there's now a piece of perl code I've written > > that > > can become a great tool to do this job. > > > > It currently extract the database schema table definition of an Oracle > > database > > and output a sql script to import into postgresql. You simply provide the > > DBI > > connection to the Oracle DB and the script do its best. It normally handle > > unique, primary and foreign keys. > > > > I need help to go further because I really don't know about Oracle and I go > > > > very slowly. Also I did not have so much Oracle database to test with. > > > > Things to do are: > > > > - Extract grants (coming soon) > > - More precision in type conversion based on length (I've no good DB to do > > that) > > - Extract triggers and internal function. > > - Extract datas. > > - SQL queries converter. > > > > For extracting data if someone know a way to dump content of an Oracle DB > > in ascii. I don't found anything than binary dump. Extracting them with > > perl/DBI > > can be very slow but if there's no other way... > > > > You can found this tools at: > > > > http://www.samse.fr/GPL/ora2pg/ > > > > > > Regards > > > > > > ---(end of broadcast)--- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > > > > -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Oracle to Pg tool
Add on on ora2pg. Table grant extraction is done. It is based on group/users grants. Oracle has ROLES that I understand as groups and users associated to these roles. So I create a group for each role and alter it by adding the users. And then set grants to each tables. Let me now if I have to stop to send new update on the list. Regards ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]