[pbassi]

Hi,

is there any way to generate the DDL for an entire schema within the database?
I have MyEclipse 5.5.1 installed
Thanks in advance

[eostermueller]

I’m trying to figure out how to generate the DDL for an entire schema.
I’m using 6.0.1.
I can right-click on a single table and get DDL for that — and it looks great.

But when I select multiple tables / Generate / DDL,
I only get the DDL for the first table selected.

We have well over 1000 tables, and we will likely need to export multiple times as changes are introduced.

I’ve also started down the ‘hibernate’ route of doing this, without much luck.

An internal error occurred during: “Generating Artifacts”.
Duplicate names found for primarykey. Existing name: TJD JDBC name: CID on table org.hibernate.mapping.Table(PROFILESCHEMA.ABPJNL)

I don’t quite understand how it thinks there are duplicate names.
Here is the DDL generated from the DB Browser:

create table “ABPJNL”(
“TJD” DATE not null,
“CID” NUMERIC(12) not null,
“ACTIBPAY” BIT,
constraint “TJD” primary key (“TJD”,”CID”)
);

Thanks,

–Erik Ostermueller

[eostermueller]

I guess I should have searched the forum first.
So it looks like generating all DDL for the db is now a requested enhancement.

In the mean time, is there a way to write a BeanShell script (or similar) to do this?
The algorithm would be: Iterate over all tables, invoke some “generate ddl” API function for each one.

Thanks,

–Erik Ostermueller

[Loyal Water]

In the mean time, is there a way to write a BeanShell script (or similar) to do this?

Im sorry there is no way to do this at the moment.

[Author]

Posts