sybase

Hi,

I am trying to shrink the database size while taking dump so I can load the dump in smaller size database. I guess it is not possible in sybase 12.5. So I am trying to extract only the table structure and load just the table structure into smaller size database so I can use it for simple testings. My objective is NOT to use same size database for my testing purposes.

Please let me know if it possible and if possible I am looking command to extract only table structure and command to load it in smaller size database.

Thanks

Sybase Database

Last Comment

wilcoxon

8/22/2022 - Mon

wilcoxon

4/19/2016

There is a ddlgen utility as part of Sybase. If that doesn't work (or doesn't exist in your version), you could try dbschema downloaded from peppler.org (it is a very old script but worked well the last time I used it but that was quite a while ago).

The only other option I'm aware of (though there are probably others) is DB Artisan but that's a pay product.

Newton

4/19/2016

ASKER

I will try ddlgen sybase utility.
Do you have any sample command as how to extract table structure and load it into another database.
lets say i need to transfer the table structure from DatabaseA which is in InstanceA to DatabaseB which is in InstanceB.

ASKER CERTIFIED SOLUTION

wilcoxon

4/19/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck