Home
Migrating and upgradingYou can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix®. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix® database server can affect upgrading from a previous release.
Migrating Informix® database systemsThe Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
Data migration utilities
The dbschema utilityThe dbschema utility displays the SQL statements (the schema) that are necessary to replicate database objects.
Syntax of the dbschema commandThe dbschema command displays the SQL statements (the schema) that are necessary to replicate a specified database object. The command also shows the distributions that the UPDATE STATISTICS statement creates.
Database schema creationYou can create the schema for an entire database or for a portion of the database.
Creating schemas for databases across a UNIX or Linux networkThe dbschema -d option creates and displays the schema for databases on a UNIX™ or Linux™ network.

Creating schemas for databases across a UNIX or Linux network

The dbschema -d option creates and displays the schema for databases on a UNIX™ or Linux™ network.

You can specify a database on any accessible database server.

The following command displays the schema for the stores_demo database on the finland database server on the UNIX or Linux system console:

dbschema -d //finland/stores_demo

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.