Re: Migrating data from DB2 zOS to PostgreSQL

From: <bend(at)linux4ms(dot)net>
To: "Swapnil Vaze" <swapvaze28(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating data from DB2 zOS to PostgreSQL
Date: 2016-12-06 18:51:00
Message-ID: 20161206115100.2b8d81ae03f6297615f26284cd7372ff.26151c5677.wbe@email18.godaddy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>We have recently done something similar - Converting Informix zLinux to Postgres x86_64.</div><div>Short answer - We used unloads to put out csv files, wrote some python programs to cleanup data, then</div><div>imported them into our Postgres instance ...<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: [GENERAL] Migrating data from DB2 zOS to PostgreSQL<br>
From: Swapnil Vaze &lt;<a href="mailto:swapvaze28(at)gmail(dot)com">swapvaze28(at)gmail(dot)com</a>&gt;<br>
Date: Mon, December 05, 2016 11:36 pm<br>
To: <a href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a><br>
<br>
<div dir="ltr">Hello,<div><br></div><div>We need some help on how we can migrate data from DB2 zOS database to postgres database.<br clear="all"><div><br></div><div>Are there any utilities present? Any thoughts how we should approach?</div><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div>Thanks &amp; Regards,</div> <div>Swapnil Vaze</div></div> </div></div>
</div>
</blockquote></span></body></html>

Attachment Content-Type Size
unknown_filename text/html 1.6 KB

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Brenner 2016-12-06 19:04:21 Re: Select works only when connected from login postgres
Previous Message Rich Shepard 2016-12-06 18:50:51 Re: PDF files: to store in database or not