Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3
| От | |
|---|---|
| Тема | Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3 |
| Дата | |
| Msg-id | 20171025090558.2b8d81ae03f6297615f26284cd7372ff.7aba2ca340.wbe@email18.godaddy.com обсуждение исходный текст |
| Ответ на | [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3 ("Gust, Thorsten" <thorsten.gust@spiegel.de>) |
| Список | pgsql-admin |
At the Mississippi State Supreme Court, we just recently finished up our migration from Informix to PostgreSQL.
I was writing a pub on how to convert to Postgres primarily aimed at the Informix to Postgres move,
but it was generic enough to be used on other databases.
My conversion also used several Python programs to manage parsing the SCHEMA dumps and creating the
necessary setup sql for tables, primary keys, secondary keyes, foreign keyes as well as Functions.
However, informix's triggers WERE a big pain, and I basically had to review each and do them by hand.
BUT I did document the differences in the pub I was doing.
All's I need is somewhere submit this publication for reference by others (I've released it under the creative commons).
Any suggestions?
It might help in what you are doing.
Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212
"Never attribute to malice, that which can be adequately explained by stupidity"
- Hanlon's Razor
"Never attribute to malice, that which can be adequately explained by stupidity"
- Hanlon's Razor
-------- Original Message --------
Subject: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3
From: "Gust, Thorsten" <thorsten.gust@spiegel.de>
Date: Wed, October 25, 2017 8:19 am
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>#wmQuoteWrapper /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}#wmQuoteWrapper @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}#wmQuoteWrapper /* Style Definitions */ p.MsoNormal, #wmQuoteWrapper li.MsoNormal, #wmQuoteWrapper div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Calibri",sans-serif;}#wmQuoteWrapper a:link, #wmQuoteWrapper span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;}#wmQuoteWrapper a:visited, #wmQuoteWrapper span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;}#wmQuoteWrapper span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}#wmQuoteWrapper span.msoIns {mso-style-type:export-only; mso-style-name:""; text-decoration:underline; color:teal;}#wmQuoteWrapper .MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif;}#wmQuoteWrapper @page WordSection1 {size:595.0pt 842.0pt; margin:70.85pt 70.85pt 2.0cm 70.85pt;}#wmQuoteWrapper div.WordSection1 {page:WordSection1;} Hi All,I’m looking for a solution regarding migrate a user from Oracle DB to PostgreSQL having the same permissions, Tablespace Quota, Table Privileges, Roles and so on afterwards.Any help would be much appreciated!!Thanks in advance and bets regardsThorsten GustIT-System ManagementSPIEGEL-Verlag Rudolf Augstein GmbH & Co. KG
Ericusspitze 1
20457 Hamburg
Tel: +49 40 3007-2759
Fax: +49 40 3007-85 2759
E-Mail: thorsten.gust@spiegel.de
SPIEGEL-Verlag Rudolf Augstein GmbH & Co. KG, Sitz und Registergericht Hamburg HRA 61 755
Komplementärin Rudolf Augstein GmbH, Sitz und Registergericht Hamburg HRB 13 105
Geschäftsführer Thomas Hass
В списке pgsql-admin по дате отправления: