Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Copy Sybase dataabse without any data



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.



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.