Migrating a Database
You can migrate your database from one major release of TimesTen Classic (such as 18.1) to another major release of TimesTen Classic (such as 22.1). You run the ttMigrate
utility to achieve this. ttMigrate
saves database objects in a binary file and upgrades or downgrades database objects by restoring the objects from the binary file into the target database.
The binary files are platform-dependent. For example, a binary file produced on Linux must be restored on Linux. However, you can use the ttMigrateCS
utility to copy a database between platforms (for example, between Linux and UNIX).
For more information, see ttMigrate in the Oracle TimesTen In-Memory Database Reference.
Note:
This section discusses the migration of databases in TimesTen Classic. For information on migrating databases from TimesTen Classic to TimesTen Scaleout and on migrating databases in TimesTen Scaleout, see Migrating, Backing Up and Restoring Data in the Oracle TimesTen In-Memory Database Scaleout User's Guide.
Examples using ttMigrate
include:
Moving to a Different Major Release of TimesTen Classic
In TimesTen Classic, you can migrate data between major releases (for example, from TimesTen 18.1
to 22.1
) by using the ttMigrate
utility to export the data from the old release and import it to the new release.
Prerequisites before migrating a database from one major release to another:
-
Install the new release by unzipping the installation zip file. See Installation of TimesTen Classic on Linux or UNIX for more information.
-
For the database in the old release, create a backup of the database. See ttBackup and ttRestore in Oracle TimesTen In-Memory Database Reference and "Backing Up and Restoring a Database" for details.
Follow these steps:
Once the database is operational in the new release, create a backup of this database to have a valid restoration point for your database. Once you have created a backup of your database, you may delete the ttMigrate
copy of your database (in this example, /tmp/database1.data
). You can also delete the instance and installation from the old release.
Ensure you recompile and relink existing ODBC applications after you perform the upgrade and before you use the new release of TimesTen. See Overview of ODBC API Incompatibilities in the Oracle TimesTen In-Memory Database C Developer's Guide for more information.