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.
The only other option I'm aware of (though there are probably others) is DB Artisan but that's a pay product.