X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id C3E2B11F655D for ; Wed, 19 Apr 2006 05:13:51 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -1.557 X-Spam-Level: X-Spam-Status: No, score=-1.557 required=5 tests=[AWL=0.546, BAYES_00=-2.599, HTML_40_50=0.496, HTML_MESSAGE=0.001, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id 972acj3Vc1Wr for ; Wed, 19 Apr 2006 05:13:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.206]) by postgresql.org (Postfix) with ESMTP id D4E6511F60B4 for ; Wed, 19 Apr 2006 05:13:47 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id z3so908452nzf for ; Wed, 19 Apr 2006 01:13:47 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=e2FSjMhg88VumpheIGptn0ywtc39UhJJmKl3d8mdDS0V4jMP3WT1Ep+XF4+jyfKu6PS6gsjaM2ZP6uqsDFdGyCfOxzC/y3WYzJx2HQfO78jVtMJ8+1bZJEBkHlqBLP4quV1j17hhlIx4Ldo+ST684KG94ARc4f9ynl70gIQzXQk= Received: by 10.65.53.8 with SMTP id f8mr270328qbk; Wed, 19 Apr 2006 01:13:46 -0700 (PDT) Received: by 10.65.249.3 with HTTP; Wed, 19 Apr 2006 01:13:46 -0700 (PDT) Message-ID: Date: Wed, 19 Apr 2006 13:13:46 +0500 From: "Shoaib Mir" To: pgsql-admin@postgresql.org Subject: Re: Migration from oracle In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2414_9513393.1145434426595" References: X-Archive-Number: 200604/179 X-Sequence-Number: 21348 ------=_Part_2414_9513393.1145434426595 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ECPG can be a good replcement for Pro*C You can see the detailed documentation for that at http://www.postgresql.org/docs/8.1/interactive/ecpg.html Hope this helps... /Shoaib On 4/19/06, koji osada wrote: > > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ------=_Part_2414_9513393.1145434426595 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ECPG can be a good replcement for Pro*C

You can see the detailed do= cumentation for that at http://www.postgresql.org/docs/8.1/interactive/ecpg.html

Hope this helps...

/Shoaib

On 4/19/06, koji osada <osadakoji@hotmail.com> wrote:<= /span>
I'm planning to m= igrate database from Oracle to PostgreSQL.
I think there are some challe= nges in migrating Pro*C/COBOL, binary
data(especially move to different endian platform), stored procedures.<= br>
I think that I can apply swissql to PL/SQL, but I don't have any ide= a to
migrate Pro*C/COBOL without doing hands on changes.

1. Is th= ere any good solution?
2. Can I use ecpg instead of Pro*C? How can I migrate?

regards,<= br>kojio



---------------------------(end of broadcast)------= ---------------------
TIP 3: Have you checked our extensive FAQ?

            = ;   http://www.pos= tgresql.org/docs/faq

------=_Part_2414_9513393.1145434426595--