@(#)README 1.4 4/2/93
This directory contains a number of example scripts for Sybperl.
space.pl Report the space used by your database.
capture.pl Create a table with information from
/etc/passwd.
report.pl Report information from the above table.
sql.pl Utility used by the above three scripts.
dbschema.pl Extract an Isql script to re-create a database
dbtext.pl A very simple example of usage of dbwritetext.
Read the code before using!
Dbschema.pl Documentation:
--------------------------
This is a Sybperl script that extracts a Sybase database definition
and creates an Isql script to rebuild the database.
dbschema.pl is NOT a production script, in the sense that it does
not do ALL the necessary work. The script tries to do the right
thing, but in certain cases (mainly where the owner of an object
is not the DBO) it creates an invalid or incorrect Isql command. I
have tried to detect these cases, and log them both to stdout and to a
file, so that the script can be corrected.
Please note also that dbschema.pl logs in to Sybase with the
default (Unix) user id, and a NULL password. This behaviour is
maybe not OK for your site.
Usage:
itf1% dbschema.pl -d excalibur -o excalibur.isql -v
Run dbschema on database 'excalibur', place the resulting script
in 'excalibur.isql' (and the error log in 'excalibur.isql.log')
and turn on verbose output on the console. The default database is
'master', the default output file is 'script.isql'.
I hope this will prove of some use, and I would be more than happy
to hear of any improvements :-)
Michael Peppler mpeppler@itf.ch
These are the contents of the former NiCE NeXT User Group NeXTSTEP/OpenStep software archive, currently hosted by Netfuture.ch.