Re: DDL components for Oracle, MSSQL and PostgreSQL

yannis wrote:
Ruediger Kabbasch formulated the question :
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

DBGO components AKA CodeGear wrappers for ADO can do all of the above
with out a problem when the drivers for the required database are installed either OLEDB or ODBC.

You take care to write the DDL in such a way that it will be accepted by any database you might need to support.

regards
Yannis.


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.

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

Relevant Pages

  • Re: Windows Ada database support.
    ... >>for example) promote the use of Object IDs (basically Row IDs). ... >>Still others don't support the concept at all (MySQL). ... >>within certain database design restrictions). ... PostgreSQL uses an API that opens/creates etc. and returns ...
    (comp.lang.ada)
  • Running queries on large data structure
    ... the money) that parses multiple large text files containing nested data ... data from the PostgreSQL database by different criteria. ... Networks ...
    (comp.lang.python)
  • Re: PHP + PostgreSQL
    ... >database from a program running on the same machine, ... ...again) hold the main rule of this techtables web apps. ... 2-3 - PostgreSQL ... you should have passwords on the various accounts. ...
    (Debian-User)
  • Re: Access and Postgresql
    ... end on the same machine that is hosting the Postgresql program. ... If you have a split Access database with back-end (tables, data, and ... relationships) on the server, and the front-end (queries, forms, reports, ... the fact is they are _hoping_ that it is some other software interfering ...
    (comp.databases.ms-access)
  • Re: Ever thought about using PostgreSQL? Ever wonder what it is all about?
    ... But since Firebird is becoming a better ... me 4GB) database files, I don't have motivations to make a profound ... PostgreSQL's PLpgsql language. ... Not to mention that PostgreSQL has Schemas and things like DBI_link ...
    (borland.public.delphi.thirdpartytools.general)