MichelleButler
IS-IT--Management
I would like to find a way to export the db_schema from informix. Could anybody help!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
export informix schema 1
- Thread starter MichelleButler
- Start date
- Status
-
1
- #2
Michelle:
Informix provides the dbschema command. In a very simple form:
dbschema -t all -d testdb all.sql
sends all schema info for testdb database to the file all.sql. You can also do individual tables.
dbschema -t individual_table -d testdb ind_table.sql.
There are other options, so execute 'dbschema' for other options such as displaying views, stored procedures, etc.
You might also check out dbexport/dbimport if you want the schema plus all the data in your database.
Regards,
Ed
Schaefer
Informix provides the dbschema command. In a very simple form:
dbschema -t all -d testdb all.sql
sends all schema info for testdb database to the file all.sql. You can also do individual tables.
dbschema -t individual_table -d testdb ind_table.sql.
There are other options, so execute 'dbschema' for other options such as displaying views, stored procedures, etc.
You might also check out dbexport/dbimport if you want the schema plus all the data in your database.
Regards,
Ed
Schaefer
- Status
Similar threads