RE: :Sybase
"Richter, John D" <[email protected]> Thu, 23 Oct 2008 09:15:29 -0400
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <107121FC34FA184F9379E97BE12DA8DA03020C45@usahm201.amer.corp.eds.com> |
Ed, I see you have answers on the ddl. For tables, assuming you want something more customized than the output from sp_spaceused, you can can always look at the code for that procedure and go from there. You might also take a look at the Rob Vershoor's site, sypron.nl, or Ed Barlow's, edbarlow.com. John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Edward Peschko Sent: Wednesday, October 22, 2008 6:54 PM To: [email protected] 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