PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: David Owen <dowen at midsomer dot org>
Subject: ANN: New version of dbschema.pl
Date: Jan 6 2001 11:19AM

The following message is a courtesy copy of an article
that has been posted to sybase.public.sqlserver.general,comp.databases.sybase as well.

I have just put up a new release of dbschema.pl.  This release has a number
of improvements, such as better handling of non dbo-owned objects,
separating the index and table build scripts so that data can be migrated
faster as well as a neat new feature, the ability to generate bcp-in/out
scripts.  There are obviously a number of bug fixes etc.

For those who don't know, dbschema.pl is a Sybperl script that reverse
engineers a Sybase ASE database.  The extraction process can either create
one file with all of the DDL for a database, or one file for each type of
object (table, trigger, index etc) or one file per object.  This last one
is particular useful in development environments.  How many times do you
tell developers *not* to store the definitive version of stored procedures
in ASE alone!  How much of a hero do you look when you inform them that you
*may* just have a copy from the previous evening!!

Thanks to Todd Boss, Andreas Mahling and Yevgeniy Tishkin for the fixes,
features and patches.

dowen
-- 
David Owen     Midsomer Consultants Inc.      dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ