Thread: Transparent exchange BDE from Oracle to PostgreSQL
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
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
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
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
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
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
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:Possibly you could consider up grading to Linux first?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
(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
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
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