Jump to main content
Product Documentation
Customer Support
HCL OneDB 2.0.1
What's new in
HCL OneDB™
2.0.1
Getting Started
Installing
Administering
Migrating and upgrading
Data warehousing
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Troubleshooting
HCL OneDB™
OneDB PDF guides
Search
HCL OneDB Documentation Homepage
Version 2.0.1
Version 2.0.0.0
Version 1.0.1
Version 1.0.0.1
Version 1.0.0.0
HCL OneDB Containerized Deployment Guide
English
Home
Migrating and upgrading
You 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 Guide
The
HCL OneDB™
Migration Guide
describes how to move data manually between databases, servers, and computers.
Data migration utilities
Migrating and upgrading
You 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 Guide
The
HCL OneDB™
Migration Guide
describes how to move data manually between databases, servers, and computers.
Overview of
HCL OneDB™
migration
Before you upgrade to the new version of
HCL OneDB™
, ensure that you understand the migration process and prerequisites.
Overview of moving data
If you are installing the new version of the database server on another computer or operating system (non-in-place migration), you can use one of several tools and utilities to move data from your current database server.
Migration to OneDB 2.0.0.0
Migration of data between database servers
Data migration utilities
External tables
External tables are a fast and versatile method for moving data between database servers. External tables are the fastest method for loading data into a RAW table with no indexes.
The dbexport and dbimport utilities
The
dbexport
and
dbimport
utilities import and export a database and its schema to disk or tape.
The dbload utility
The
dbload
utility loads data into databases or tables that
HCL® OneDB®
products created. It transfers data from one or more text files into one or more existing tables.
The dbschema utility
The
dbschema
utility displays the
SQL
statements (the
schema
) that are necessary to replicate database objects.
Migrating existing keystores
Data migration utilities
External tables
External tables are a fast and versatile method for moving data between database servers. External tables are the fastest method for loading data into a RAW table with no indexes.
The dbexport and dbimport utilities
The
dbexport
and
dbimport
utilities import and export a database and its schema to disk or tape.
The dbload utility
The
dbload
utility loads data into databases or tables that
HCL® OneDB®
products created. It transfers data from one or more text files into one or more existing tables.
The dbschema utility
The
dbschema
utility displays the
SQL
statements (the
schema
) that are necessary to replicate database objects.
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.