Re: DDL components for Oracle, MSSQL and PostgreSQL

Ruediger Kabbasch wrote:
Hi everybody,

does anybody can recommend any components/libraries that can be used to
execute DDL script for Oracle, MSSQL or PostgreSQL databases (like CREATE
TABLE, ALTER TABLE, ...)

Any help is wellcome.
Kind regards,
Rudiger Kabbasch


If you are using Kylix you can use DBexpress which has a PostgreSQL
driver. For whatever reason they never deemed it NOT a priority to ship that driver with win32 Delphi.

If you are doing .net then there are .net data providers available for all 3.
PostgreSQL one is here: http://npgsql.projects.postgresql.org/

There is also a 3rd party DBexpress driver from vitavoom software:
http://www.vitavoom.com/ That works with Kylix and win32 Delphi

--
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL and MySQL
http://www.amsoftwaredesign.com
.

Relevant Pages

  • Re: AM Lightning Debugger for PostgreSQL 8.2 and up
    ... There's a strange lack of such a driver. ... There's vitavoom driver, ... a .net provider for postgresql). ... If only we could have source code of that driver (that actually has no value ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Trouble Installing ODBC 1.13 on Linux 64
    ... I've taken a quick look at some of the errors you are getting with the postgres ODBC driver - see below: ... ok 3 # skip SQLDescribeParam not supported using PostgreSQL ... ok 3 # skip Microsoft SQL Server tests not supported using PostgreSQL ...
    (perl.dbi.users)
  • Re: Error in devenv.exe when trying to insert OLEDB consumer
    ... I am trying to create a connection to a PostgreSQL database via a ATL ... Selecting the driver works (I have the OLEDB driver from the postgres ...
    (microsoft.public.vc.atl)
  • Re: Are you Looking for a nice Postgresql Admin program similar to IB Expert ?
    ... Isn't there a bunch of tdataset products for Oracle? ... PostgreSQL and Oracle with a single codebase without noticeable problems.. ... ODBC and PostgreSQL ODBC driver... ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: DDL components for Oracle, MSSQL and PostgreSQL
    ... execute DDL script for Oracle, MSSQL or PostgreSQL databases (like CREATE ... You take care to write the DDL in such a way that it will be accepted by any database you might need to support. ... The ADO driver that is available for PostgreSQL is not very good. ... You could use DBGO against the PostgreSQL ODBC driver and that may be ok just to execute scripts. ...
    (borland.public.delphi.thirdpartytools.general)