<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(dot)gust(at)spiegel(dot)de">thorsten(dot)gust(at)spiegel(dot)de</a>><br>
Date: Wed, October 25, 2017 8:19 am<br>
To: "<a href="mailto:pgsql-admin(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)org</a>" <<a href="mailto:pgsql-admin(at)postgresql(dot)org">pgsql-admin(at)postgresql(dot)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(dot)gust(at)spiegel(dot)de"><span style="color:#0563C1" lang="DE">thorsten(dot)gust(at)spiegel(dot)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>