Home
Migrating and upgradingYou can upgrade to the 2.0.0.0 version of HCL OneDB™ or migrate from other database servers to HCL OneDB™. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the HCL OneDB™ database server can affect upgrading from a previous release.
HCL OneDB™ Migration GuideThe HCL OneDB™ 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.
Use dbschema output as DB-Access inputYou can use the dbschema utility to get the schema of a database and redirect the dbschema output to a file. Later, you can import the file into DB-Access and use DB-Access to re-create the schema in a new database.
Inserting a table into a dbschema output fileYou can insert CREATE TABLE statements into the dbschema output file and use this output as DB-Access input.

Inserting a table into a dbschema output file

You can insert CREATE TABLE statements into the dbschema output file and use this output as DB-Access input.

The following example copies the CREATE TABLE statements for the customer table into the dbschema output file, tab.sql:

dbschema -d db -t customer > tab.sql

Remove the header information about dbschema from the output file, tab.sql, and then use DB-Access to re-create the table in another database, as follows:

dbaccess db1 tab.sql

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.