Hello everyone!

I need an advice on a very simple task. I am looking to create exact
copy of the existing Sybase database (all underlying structure, size,
procedures, functions, segments, objects, etc. are the same only name
is different). I DON'T need to copy any data, just to create a
database itself.

Ideally, I would like the new database to use same segments in the
same space proportion as an existing source.

What is the quick and easy way for me to do that?

I know in DB2 UDB I can extract just the DDL including the
environmental variables into the script, create the new database name
with desired size and run the script to populate the internal data
base layout. Unfortunately, I am not Sybase savvy. Is there a similar
way to do that in the Sybase?

Thanks,

PerlUser.

There are various ways of reverse-engineering a database. In 12.0+ ,
you can use 'ddlgen' (see www.sypron.nl/ddlgen.html). Other
possibilities are the 'generate DDL' options in Sybase Central or
David Owen's excellent 'dbschema.pl' script (see
www.sypron.nl/syblinks.html for the URL of this tool).

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Dmitry" <perluser (AT) optonline (DOT) net> wrote

Rob,

Thanks so much for a quick response and point in the right direction!

I have also checked your website and it's an excellent source of
information. Please keep up the good work.

Best regards,

Dmitry, (PerlUser)

UDB DBA
Independent consultant and Certified IBM professional.