Re: PowerBuilder->Ingres to PowerBuilder->Oracle, anyone?

In article <enduser-1012952329080001_at_204.247.5.29>, enduser_at_enduser.com (EndUser) says...
>
>depends, are you still going to use the powerbuilder apps, or are
>you going to rewrite them in Developer 2000, or OPO?
>
>also, ingres does not support SQL in the same way Oracle does,
>and of course youll rewrite all your stored procedures and 4GL code.
>
>--
>
>In article <4a9ga4$o3i_at_dingo.cc.uq.oz.au>, amcb_at_acslink.net.au (Andrew
>McBurnie) wrote:
>
>> We're faced with the possibility of moving a PowerBuilder v4 front
>> end, originally developed to work with an Ingres back end database,
>> to Oracle, v7.
>> I don't have much more information than this, as it's just landed
>> on us, with somebody else airily waving their hand and saying
>> that moving from Ingres to Oracle will be straight forward.
>>
>> Has anybody out there had any experience changing PowerBuilder
>> applications from one database to another?
>>

We're not planning to re-write the PowerBuilder appliation in Developer 2000 or anything else. The proposal is that we take a PowerBuilder App, presently sitting on an Ingres database, and convert it to sit on an Oracle database --- doing only the modifications necessary to make it work. I
suspect this may not be simple, as we haven't even seen the PowerBuilder source code yet. I don't know what sort of special Ingres facilities they
are using that might be incompatible with Oracle, whether they used an ANSI standard sort of SQL, or what. I'm presuming that wherever the PowerBuilder code makes a database access, we're faced with a mod. of some sort.

What are the diffences between Ingres SQL and Oracle SQL?   Received on Fri Dec 15 1995 - 00:00:00 CET