How to duplicate a database

Dear Friends, I would appreciate if someone could tell me how do I duplicate a database (all objects)? what is the exact command to copy the current database into a new database? I tried with dbload but its not working, I just want the structure without data. For example, if I have database called db_1 I want to copy the whole structure into a new database called db_2 without data. Your help much appreciated. Syed. -- Syed Ibrahim Sapura Advanced Systems Sdn. Bhd. Level 7 - Bangunan Sapura Jalan Tasik 43300 Sri Kembangan Tel: 03-9497000 (main line) Fax: 03-9421230

Syed wrote: > Dear Friends, > > I would appreciate if someone could tell me how do I duplicate a > database (all objects)? what is the exact command to copy the current > database into a new database? I tried with dbload but its not working, I > just want the structure without data. For example, if I have database > called db_1 I want to copy the whole structure into a new database > called db_2 without data. > > Your help much appreciated. > > Syed. > > -- > Syed Ibrahim > Sapura Advanced Systems Sdn. Bhd. > Level 7 - Bangunan Sapura > Jalan Tasik > 43300 Sri Kembangan > Tel: 03-9497000 (main line) > Fax: 03-9421230 Use dbschema to dump the schema in a .sql file , edit for database_name and any triggers, use the file to create the new database. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible. Some features are: True Windows GUI Clients. ActiveX support. HTML Report Generation. More rigorous error handling. Connection to other RDBMS such as Oracle. Connection to all versions of Informix 4GL with no need to change compiler. For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------