database - Generating DDLs for Sybase tables and indexes -


The

I do not need (and more complex) is a command line tool to generate DDL for both tables and indexes Looking for something in the database for Sybase tables that I take care of. I think they've used GUI tool to view individual DDLs, and I can cut and paste, but I want something that will go through all the tables in a database and some good text files that I CVS can generate checks.

I tried to use, which is a tool called ddlgen has been provided by Sybase, but it just threw this exception:

 < Code> Bash-3.00 #. / Ddlgen -SdatabaseServer: 4100 -User -pasekitpasward-Titibi -detabesnam U 64: Free: Detabesnam. Dbo.firstTable U64: Blank: Database Name. Dbo.firstType com.sybase.ddlgen.container.UserTableContainer.getDependentDDL (UserTableContainer.java:1065) at Com.sybase.ddlgen.container.UserTableContainer.open (UserTableContainer.java:1364) com.sybase.ddlgen.container.UserTableMetaContainer on .open (UserTableMetaContainer.java:94) on com.sybase.ddlgen.container.DDLBaseContainer. Com load com.ybase.ddlgen.container.DatabaseContainer.addChildren (DDLBaseContainer.java:76) (DatabaseContainer.java:552) com.sybase.ddlgen.container.DatabaseContainer.open (DatabaseContainer.java:104) com.sybase. Ddlgen.container.DatabaseMetaContainer.open (at DatabaseMetaContainer.java:114) at com.sybase.ddlgen onDDLThread.run (DDLThread.java:89)  

which was not very helpful Keep thinking that there should be a good Perlish way to do this, but I do not know what will happen.

"itemprop =" text ">

You can also use Perl-based dbschema.pl

< / P>


Comments