X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 69FB811F6B91 for ; Wed, 19 Apr 2006 04:49:16 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.919 X-Spam-Level: * X-Spam-Status: No, score=1.919 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id lDOJKQqYdpL2 for ; Wed, 19 Apr 2006 04:49:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DA20411F6B86 for ; Wed, 19 Apr 2006 04:49:13 -0300 (ADT) Received: from hotmail.com (bay115-f3.bay115.hotmail.com [65.54.250.13]) by svr4.postgresql.org (Postfix) with ESMTP id E83E85AF663 for ; Wed, 19 Apr 2006 07:49:13 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 19 Apr 2006 00:49:11 -0700 Message-ID: Received: from 65.54.250.200 by by115fd.bay115.hotmail.msn.com with HTTP; Wed, 19 Apr 2006 07:49:11 GMT X-Originating-IP: [61.120.196.130] X-Originating-Email: [osadakoji@hotmail.com] X-Sender: osadakoji@hotmail.com From: "koji osada" To: pgsql-admin@postgresql.org Subject: Migration from oracle Date: Wed, 19 Apr 2006 16:49:11 +0900 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 19 Apr 2006 07:49:11.0760 (UTC) FILETIME=[BF47ED00:01C66385] X-Archive-Number: 200604/178 X-Sequence-Number: 21347 I'm planning to migrate database from Oracle to PostgreSQL. I think there are some challenges in migrating Pro*C/COBOL, binary data(especially move to different endian platform), stored procedures. I think that I can apply swissql to PL/SQL, but I don't have any idea to migrate Pro*C/COBOL without doing hands on changes. 1. Is there any good solution? 2. Can I use ecpg instead of Pro*C? How can I migrate? regards, kojio