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.
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.
Synonym creationThe dbschema -s command generates information about synonym creation.

Synonym creation

The dbschema -s command generates information about synonym creation.

The following syntax diagram fragment shows the creation of synonyms.

Synonyms


Element	Purpose	Key Considerations
-s *ownername*	Displays the CREATE SYNONYM statements owned by ownername	None.
-s all	Displays all CREATE SYNONYM statements for the database, table, or view specified	None.

Output from dbschema that ran with the specified option -s alice might appear as the following example shows:

CREATE SYNONYM 'alice'.cust FOR 'alice'.customer

For more information about the CREATE SYNONYM statement, see the HCL OneDB™ Guide to SQL: Syntax.

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.