pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigrate from Oracle 12g to PostgreSQL 9.3
7+ messages / 4 participants
[nested] [flat]
* Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-25 13:19 Gust, Thorsten <thorsten.gust@spiegel.de>
0 siblings, 2 replies; 7+ messages in thread
From: Gust, Thorsten @ 2017-10-25 13:19 UTC (permalink / raw)
To: pgsql-admin
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 regards
Thorsten Gust
IT-System Management
SPIEGEL-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<mailto: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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-25 16:05 bend@linux4ms.net
0 siblings, 0 replies; 7+ messages in thread
From: bend@linux4ms.net @ 2017-10-25 16:05 UTC (permalink / raw)
To: pgsql-admin
<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>At the Mississippi State Supreme Court, we just recently finished up our migration from Informix to PostgreSQL.</div><div><br></div><div>I was writing a pub on how to convert to Postgres primarily aimed at the Informix to Postgres move,</div><div>but it was generic enough to be used on other databases.</div><div><br></div><div>My conversion also used several Python programs to manage parsing the SCHEMA dumps and creating the</div><div>necessary setup sql for tables, primary keys, secondary keyes, foreign keyes as well as Functions.</div><div><br></div><div>However, informix's triggers WERE a big pain, and I basically had to review each and do them by hand.</div><div>BUT I did document the differences in the pub I was doing.</div><div><br></div><div>All's I need is somewhere submit this publication for reference by others (I've released it under the creative commons).</div><div><br></div><div>Any suggestions?</div><div><br></div><div>It might help in what you are doing.</div><div><br></div><div><br></div><div><br></div><div><span style="font-size: 8pt;"></span><span style="font-size: 8pt;">Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212<br>"Never attribute to malice, that which can be adequately explained by stupidity"<br>- Hanlon's Razor<br></span></div><div><br><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3<br>
From: "Gust, Thorsten" <<a href="mailto:thorsten.gust@spiegel.de">thorsten.gust@spiegel.de</a>><br>
Date: Wed, October 25, 2017 8:19 am<br>
To: "<a href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>" <<a href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>><br>
<br>
<style>
#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;}
</style> <div class="WordSection1"> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt">Hi All,<o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt"><o:p> </o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt">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.<o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt"><o:p> </o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt">Any help would be much appreciated!!<o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt"><o:p> </o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-size:11.0pt">Thanks in advance and bets regards</span><span style="font-family:"Times New Roman",serif"><o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif"><o:p> </o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE">Thorsten Gust<o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE">IT-System Management<o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE"><o:p> </o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE">SPIEGEL-Verlag Rudolf Augstein GmbH & Co. KG <br> Ericusspitze 1<br> 20457 Hamburg <br> Tel: +49 40 3007-2759<br> Fax: +49 40 3007-85 2759<br> E-Mail: </span><span style="font-family:"Times New Roman",serif"><a target="_blank" href="mailto:thorsten.gust@spiegel.de"><span style="color:#0563C1" lang="DE">thorsten.gust@spiegel.de</span></a></span><span style="font-family:"Times New Roman",serif" lang="DE"><o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE"><br> SPIEGEL-Verlag Rudolf Augstein GmbH & Co. KG, Sitz und Registergericht Hamburg HRA 61 755 <br> Komplementärin Rudolf Augstein GmbH, Sitz und Registergericht Hamburg HRB 13 105 <br> Geschäftsführer Thomas Hass<o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE"><o:p> </o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span style="font-family:"Times New Roman",serif" lang="DE"> <o:p></o:p></span></div> <div class="MsoNormal" style="font-size:12pt;"><span lang="DE"><o:p> </o:p></span></div> </div>
</div>
</blockquote></span></body></html>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-25 18:40 Julien Rouhaud <rjuju123@gmail.com>
parent: Gust, Thorsten <thorsten.gust@spiegel.de>
1 sibling, 1 reply; 7+ messages in thread
From: Julien Rouhaud @ 2017-10-25 18:40 UTC (permalink / raw)
To: Gust, Thorsten <thorsten.gust@spiegel.de>; +Cc: pgsql-admin
On Wed, Oct 25, 2017 at 3:19 PM, Gust, Thorsten
<thorsten.gust@spiegel.de> wrote:
> 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.
You should try http://ora2pg.darold.net/, it handles many things automatically.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-26 02:18 Ian Barwick <ian.barwick@2ndquadrant.com>
parent: Gust, Thorsten <thorsten.gust@spiegel.de>
1 sibling, 1 reply; 7+ messages in thread
From: Ian Barwick @ 2017-10-26 02:18 UTC (permalink / raw)
To: Gust, Thorsten <thorsten.gust@spiegel.de>; pgsql-admin
On 10/25/2017 10:19 PM, Gust, Thorsten wrote:
> 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!!
Out of interest, any reason why you're targetting PostgreSQL 9.3? It's currently
the oldest of the community-supported releases and will probably be EOL'd some
time in late 2018 [*]
[*] https://www.postgresql.org/support/versioning/
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-26 07:36 Gust, Thorsten <thorsten.gust@spiegel.de>
parent: Ian Barwick <ian.barwick@2ndquadrant.com>
0 siblings, 0 replies; 7+ messages in thread
From: Gust, Thorsten @ 2017-10-26 07:36 UTC (permalink / raw)
To: Ian Barwick <ian.barwick@2ndquadrant.com>; pgsql-admin
Hi Ian, All,
Oops, many thanks for the very fast answers and sorry a mistake of mine, it’s 9.6.3 I’m running at the moment.
Thanks in advance and best regards
Thorsten
Thorsten Gust
IT-System Management
SPIEGEL-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
On 26.10.17, 04:18, "Ian Barwick" <ian.barwick@2ndquadrant.com> wrote:
On 10/25/2017 10:19 PM, Gust, Thorsten wrote:
> 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!!
Out of interest, any reason why you're targetting PostgreSQL 9.3? It's currently
the oldest of the community-supported releases and will probably be EOL'd some
time in late 2018 [*]
[*] https://www.postgresql.org/support/versioning/
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-26 08:21 Gust, Thorsten <thorsten.gust@spiegel.de>
parent: Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Gust, Thorsten @ 2017-10-26 08:21 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: pgsql-admin
Hello Julien,
Thanks for that answer, but because we migrated our Oracle Database already to a PostgreSQL one. That’s because we don’t need to install
such tools like ora2pg as we only need a solution to migrate 2 users from Oracle to Postgres, what should not mean that ora2pg is a very nice
tool.
Thank in advance and best regards
Thorsten Gust
IT-System Management
SPIEGEL-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
On 25.10.17, 20:41, "Julien Rouhaud" <rjuju123@gmail.com> wrote:
On Wed, Oct 25, 2017 at 3:19 PM, Gust, Thorsten
<thorsten.gust@spiegel.de> wrote:
> 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.
You should try http://ora2pg.darold.net/, it handles many things automatically.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Migrate from Oracle 12g to PostgreSQL 9.3
@ 2017-10-26 09:34 Julien Rouhaud <rjuju123@gmail.com>
parent: Gust, Thorsten <thorsten.gust@spiegel.de>
0 siblings, 0 replies; 7+ messages in thread
From: Julien Rouhaud @ 2017-10-26 09:34 UTC (permalink / raw)
To: Gust, Thorsten <thorsten.gust@spiegel.de>; +Cc: pgsql-admin
On Thu, Oct 26, 2017 at 10:21 AM, Gust, Thorsten
<thorsten.gust@spiegel.de> wrote:
> Hello Julien,
>
> Thanks for that answer, but because we migrated our Oracle Database already to a PostgreSQL one. That’s because we don’t need to install
> such tools like ora2pg as we only need a solution to migrate 2 users from Oracle to Postgres, what should not mean that ora2pg is a very nice
> tool.
Well, ora2pg can be configured to only migrate users and ACL, see the
GRANT export type.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2017-10-26 09:34 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-10-25 13:19 Migrate from Oracle 12g to PostgreSQL 9.3 Gust, Thorsten <thorsten.gust@spiegel.de>
2017-10-25 18:40 ` Julien Rouhaud <rjuju123@gmail.com>
2017-10-26 08:21 ` Gust, Thorsten <thorsten.gust@spiegel.de>
2017-10-26 09:34 ` Julien Rouhaud <rjuju123@gmail.com>
2017-10-26 02:18 ` Ian Barwick <ian.barwick@2ndquadrant.com>
2017-10-26 07:36 ` Gust, Thorsten <thorsten.gust@spiegel.de>
2017-10-25 16:05 Re: Migrate from Oracle 12g to PostgreSQL 9.3 bend@linux4ms.net
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox