Migrate from ODAC to PostgreSQL Data Access Components

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
vassot
Posts: 5
Joined: Mon 13 Feb 2012 08:09

Migrate from ODAC to PostgreSQL Data Access Components

Post by vassot » Tue 04 Feb 2014 09:43

Hello, our company is thinking about migrating from Oracle to PostgreSQL. How easy is it to convert all my odac components to pgdac - as there are too many of them in my projects!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Migrate from ODAC to PostgreSQL Data Access Components

Post by AlexP » Tue 04 Feb 2014 12:33

Hello,

You can use any utility (or plugin for Delphi), which allows to globally modify data in files. You can also replace ODAC classes (ToraSession, TOraQuery, etc.) with respective PgDAC classes (TPgConnection, TPgQuery, etc.). However, since these products contain methods, events and properties, that don't match each other (or don't exist), you will have to modify them manually.

vassot
Posts: 5
Joined: Mon 13 Feb 2012 08:09

Re: Migrate from ODAC to PostgreSQL Data Access Components

Post by vassot » Tue 04 Feb 2014 14:05

Thank you!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Migrate from ODAC to PostgreSQL Data Access Components

Post by AlexP » Wed 05 Feb 2014 10:12

If you have any further questions, feel free to contact us.

Post Reply