UNLOAD and RELOAD!

[johnvai]

Dear friends:
I have tried a lot using the reload and load commands from sybase.
I am using the sybase 5.
I have a used database, which means i have records in it.
I want a new virgin database with the same structure, so that i can start with for other clients. but the problem is that i need only to keep 2 tables untouched, because they are very mandatory tables like Product and Suppliers tables.

Can you give me step by step information on how to do this?
thanks.

 

[pauljt]

Here is some information that may help.

To create an identical structure of the database, you could
use Sybase Central, right click over the name of a database:

and select
Generate Create Database DDL
- to get the SQL to build the database
- which you can alter to use different devices

Generate Database Objects DDL
- to get the SQL to build all the database objects

Any tables which you require standing data for, you could
bulk copy the data out of your existing database for those
tables only.

Once the new database structure is built and in place
then bulk copy in the standing data.