Re: DDL::Sybase

Take a look at SQL Fairy aka SQL::Translator  http://search.cpan.org/~jrobinson/SQL-Translator/lib/SQL/Translator.pm for one way to do it

 Jason L. Froebe


Tech log http://www.froebe.net/blog
MyDatabases (free) magazine: http://froebe.net/blog/category/databases/my-databases/
Froebe Fibers http://www.froebe-fibers.com


The opinions expressed within are the sole rantings of a raving lunatic and in no way reflect the rantings, fits, tantrums, errors, corrections, allocutions, or aimless thoughts of Sybase or its employees or of TeamSybase or ISUG. Any resemblence to reasonable thought, or any official or published opinion of Sybase, TeamSybase or ISUG is merely coincidental, and should be totally ignored.




----- Original Message ----
From: Edward Peschko <[email protected]>
To: [email protected]
Sent: Wednesday, October 22, 2008 5:53:57 PM
Subject: DDL::Sybase

All,

Oracle has a very nice perl module associated with it - DDL::Oracle -
it allows for dumping of procedures, indexes, tables, stored
procedures, and so on, in a way that can be highly configured (ie:
sizing can be kept, tweaked or removed, partitioning tweaked, table
allocation changed)

Does something like this exist for sybase? I basically want to be able
to dump a database's ddl out and change how much space is allocated
for each table (likewise with indexes). If not, does anybody have any
ideas on where I could start, aside from scratch?

Thanks,

Ed