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.
David Owen Midsomer Consultants Inc. email@example.com
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ