DDL generation

Thanuja · #1 (**permalink**) 06-24-04, 15:04

Can you please tell me how to do DDL generation of an existing database. I want the database shcema in the form of a script file.
Please tell me how this cud be achieved.
I have sybase 3.1
Thanks

willy_and_the_ci · #2 (**permalink**) 06-26-04, 11:14

ASE comes with a ddlgen utility with 12.5

It works on ASE 12.0 onwards.

Martijnvs · #3 (**permalink**) 06-27-04, 05:35

Quote:

Originally Posted by willy_and_the_ci

ASE comes with a ddlgen utility with 12.5

It works on ASE 12.0 onwards.

Does this utility, by any chance, have the same problems with P4-cpu's as the ASE-install?
I can't get DDLgen to work...it simply does nothing.

willy_and_the_ci · #4 (**permalink**) 06-27-04, 20:26

No..haven't had any troubles using it. Although it is a Java based utility, there are no interfaces and hence is command line.