Thread: Transparent exchange BDE from Oracle to PostgreSQL

Transparent exchange BDE from Oracle to PostgreSQL

From
Edson Richter
Date:
It is possible to put a PostgreSQL database in substitution of a Oracle
database for an app running BDE?
Any tips (beyond obvious "check Oracle specific funcionality")?

Regards,

Edson


Re: Transparent exchange BDE from Oracle to PostgreSQL

From
John R Pierce
Date:
On 2/1/2014 3:18 PM, Edson Richter wrote:
> It is possible to put a PostgreSQL database in substitution of a
> Oracle database for an app running BDE?
> Any tips (beyond obvious "check Oracle specific funcionality")?

what is BDE  ?


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



Re: Transparent exchange BDE from Oracle to PostgreSQL

From
Adrian Klaver
Date:
On 02/01/2014 03:26 PM, John R Pierce wrote:
> On 2/1/2014 3:18 PM, Edson Richter wrote:
>> It is possible to put a PostgreSQL database in substitution of a
>> Oracle database for an app running BDE?
>> Any tips (beyond obvious "check Oracle specific funcionality")?
>
> what is BDE  ?

http://en.wikipedia.org/wiki/Borland_Database_Engine

>
>


--
Adrian Klaver
adrian.klaver@gmail.com


Re: Transparent exchange BDE from Oracle to PostgreSQL

From
John R Pierce
Date:
On 2/1/2014 4:26 PM, Adrian Klaver wrote:
> On 02/01/2014 03:26 PM, John R Pierce wrote:
>> On 2/1/2014 3:18 PM, Edson Richter wrote:
>>> It is possible to put a PostgreSQL database in substitution of a
>>> Oracle database for an app running BDE?
>>> Any tips (beyond obvious "check Oracle specific funcionality")?
>>
>> what is BDE  ?
>
> http://en.wikipedia.org/wiki/Borland_Database_Engine

if its using ODBC or something to connect to Oracle, then you should be
able to use ODBC to connect to PostgreSQL.

Will the Borland TurboWhatever code run as-is?  well, that depends on
what its doing with Oracle.  good luck.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



Re: Transparent exchange BDE from Oracle to PostgreSQL

From
Edson Richter
Date:
Em 02/02/2014 04:24, John R Pierce escreveu:
> On 2/1/2014 4:26 PM, Adrian Klaver wrote:
>> On 02/01/2014 03:26 PM, John R Pierce wrote:
>>> On 2/1/2014 3:18 PM, Edson Richter wrote:
>>>> It is possible to put a PostgreSQL database in substitution of a
>>>> Oracle database for an app running BDE?
>>>> Any tips (beyond obvious "check Oracle specific funcionality")?
>>>
>>> what is BDE  ?
>>
>> http://en.wikipedia.org/wiki/Borland_Database_Engine
>
> if its using ODBC or something to connect to Oracle, then you should
> be able to use ODBC to connect to PostgreSQL.
>
> Will the Borland TurboWhatever code run as-is?  well, that depends on
> what its doing with Oracle.  good luck.
>

Thanks - my thoughts, perhaps, was if someone with experience on BDE
could give some light here :-) - I'm not a BDE expert myself; that's why
I'm looking for help.
BDE is some kind of "obscure" technology - it needs some special
drivers, and I honestly don't know if it will work with pure ODBC. Even
with Oracle, I had trouble because I've to install those software in
certain sequence otherwise drivers are not added to Windows registry (I
hate it).
I appreciate your insights and your time.

Regards,

Edson



Re: Transparent exchange BDE from Oracle to PostgreSQL

From
Gavin Flower
Date:
On 03/02/14 01:18, Edson Richter wrote:
> Em 02/02/2014 04:24, John R Pierce escreveu:
>> On 2/1/2014 4:26 PM, Adrian Klaver wrote:
>>> On 02/01/2014 03:26 PM, John R Pierce wrote:
>>>> On 2/1/2014 3:18 PM, Edson Richter wrote:
>>>>> It is possible to put a PostgreSQL database in substitution of a
>>>>> Oracle database for an app running BDE?
>>>>> Any tips (beyond obvious "check Oracle specific funcionality")?
>>>>
>>>> what is BDE  ?
>>>
>>> http://en.wikipedia.org/wiki/Borland_Database_Engine
>>
>> if its using ODBC or something to connect to Oracle, then you should
>> be able to use ODBC to connect to PostgreSQL.
>>
>> Will the Borland TurboWhatever code run as-is?  well, that depends on
>> what its doing with Oracle.  good luck.
>>
>
> Thanks - my thoughts, perhaps, was if someone with experience on BDE
> could give some light here :-) - I'm not a BDE expert myself; that's
> why I'm looking for help.
> BDE is some kind of "obscure" technology - it needs some special
> drivers, and I honestly don't know if it will work with pure ODBC.
> Even with Oracle, I had trouble because I've to install those software
> in certain sequence otherwise drivers are not added to Windows
> registry (I hate it).
> I appreciate your insights and your time.
>
> Regards,
>
> Edson
>
>
>
Possibly you could consider up grading to Linux first?
(Not being entirely facetious!)

PostgreSQL runs better on Linux, as I suspect Oracle also does.


Cheers,
Gavin


Re: Transparent exchange BDE from Oracle to PostgreSQL

From
Erik Darling
Date:
unsubscribe


On Sun, Feb 2, 2014 at 11:28 AM, Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:
On 03/02/14 01:18, Edson Richter wrote:
Em 02/02/2014 04:24, John R Pierce escreveu:
On 2/1/2014 4:26 PM, Adrian Klaver wrote:
On 02/01/2014 03:26 PM, John R Pierce wrote:
On 2/1/2014 3:18 PM, Edson Richter wrote:
It is possible to put a PostgreSQL database in substitution of a
Oracle database for an app running BDE?
Any tips (beyond obvious "check Oracle specific funcionality")?

what is BDE  ?

http://en.wikipedia.org/wiki/Borland_Database_Engine

if its using ODBC or something to connect to Oracle, then you should be able to use ODBC to connect to PostgreSQL.

Will the Borland TurboWhatever code run as-is?  well, that depends on what its doing with Oracle.  good luck.


Thanks - my thoughts, perhaps, was if someone with experience on BDE could give some light here :-) - I'm not a BDE expert myself; that's why I'm looking for help.
BDE is some kind of "obscure" technology - it needs some special drivers, and I honestly don't know if it will work with pure ODBC. Even with Oracle, I had trouble because I've to install those software in certain sequence otherwise drivers are not added to Windows registry (I hate it).
I appreciate your insights and your time.

Regards,

Edson



Possibly you could consider up grading to Linux first?
(Not being entirely facetious!)

PostgreSQL runs better on Linux, as I suspect Oracle also does.


Cheers,
Gavin


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: Transparent exchange BDE from Oracle to PostgreSQL

From
Alfonso Afonso
Date:
Hi everybody

I have not follow all the advices and answer you probably has received, so my apologises if I repeat something ;)

I have been working with Delphi/BDE over 14 years and some projects had to be moved from one database system to another
thanksto ODBC layer BUT you have to consider that if you are using some storeproc or functions in your querys, most of
themcould not be compatible. 

So, in my personal case, that transparent movement was imposible but not too hard to fix.... mainly functions in querys
andsome internals on RDBMS (triggers and procs). 

Anyway, there are some other connection methods today rather than the old BDE (it's a bit obsolete) that maybe you
wouldconsider now as you have this changing work plan ahead... maybe it worth the time and efforts. 

Best luck with all that stuff.

Regards

Alfonso

El 02/02/2014, a las 16:28, Gavin Flower <GavinFlower@archidevsys.co.nz> escribió:

> On 03/02/14 01:18, Edson Richter wrote:
>> Em 02/02/2014 04:24, John R Pierce escreveu:
>>> On 2/1/2014 4:26 PM, Adrian Klaver wrote:
>>>> On 02/01/2014 03:26 PM, John R Pierce wrote:
>>>>> On 2/1/2014 3:18 PM, Edson Richter wrote:
>>>>>> It is possible to put a PostgreSQL database in substitution of a
>>>>>> Oracle database for an app running BDE?
>>>>>> Any tips (beyond obvious "check Oracle specific funcionality")?
>>>>>
>>>>> what is BDE  ?
>>>>
>>>> http://en.wikipedia.org/wiki/Borland_Database_Engine
>>>
>>> if its using ODBC or something to connect to Oracle, then you should be able to use ODBC to connect to PostgreSQL.
>>>
>>> Will the Borland TurboWhatever code run as-is?  well, that depends on what its doing with Oracle.  good luck.
>>>
>>
>> Thanks - my thoughts, perhaps, was if someone with experience on BDE could give some light here :-) - I'm not a BDE
expertmyself; that's why I'm looking for help. 
>> BDE is some kind of "obscure" technology - it needs some special drivers, and I honestly don't know if it will work
withpure ODBC. Even with Oracle, I had trouble because I've to install those software in certain sequence otherwise
driversare not added to Windows registry (I hate it). 
>> I appreciate your insights and your time.
>>
>> Regards,
>>
>> Edson
>>
>>
>>
> Possibly you could consider up grading to Linux first?
> (Not being entirely facetious!)
>
> PostgreSQL runs better on Linux, as I suspect Oracle also does.
>
>
> Cheers,
> Gavin
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Alfonso Afonso








Re: Transparent exchange BDE from Oracle to PostgreSQL

From
Adrian Klaver
Date:
On 02/02/2014 04:18 AM, Edson Richter wrote:
> Em 02/02/2014 04:24, John R Pierce escreveu:
>> On 2/1/2014 4:26 PM, Adrian Klaver wrote:
>>> On 02/01/2014 03:26 PM, John R Pierce wrote:
>>>> On 2/1/2014 3:18 PM, Edson Richter wrote:
>>>>> It is possible to put a PostgreSQL database in substitution of a
>>>>> Oracle database for an app running BDE?
>>>>> Any tips (beyond obvious "check Oracle specific funcionality")?
>>>>
>>>> what is BDE  ?
>>>
>>> http://en.wikipedia.org/wiki/Borland_Database_Engine
>>
>> if its using ODBC or something to connect to Oracle, then you should
>> be able to use ODBC to connect to PostgreSQL.
>>
>> Will the Borland TurboWhatever code run as-is?  well, that depends on
>> what its doing with Oracle.  good luck.
>>
>
> Thanks - my thoughts, perhaps, was if someone with experience on BDE
> could give some light here :-) - I'm not a BDE expert myself; that's why
> I'm looking for help.
> BDE is some kind of "obscure" technology - it needs some special
> drivers, and I honestly don't know if it will work with pure ODBC. Even
> with Oracle, I had trouble because I've to install those software in
> certain sequence otherwise drivers are not added to Windows registry (I
> hate it).
> I appreciate your insights and your time.

You might get more traction on the Embarcadero forums:

https://forums.embarcadero.com/index.jspa

>
> Regards,
>
> Edson
>
>
>


--
Adrian Klaver
adrian.klaver@gmail.com