Moving between 32-bit and 64-bit data stores, Moving to a different major release of timesten – Oracle Audio Technologies B31679-01 User Manual
Page 109
Data Store Upgrades
101
Note: The temporary partition size of a data store may be changed by
simply modifying the
TempSize
attribute of the DSN, unloading the
data store from memory, and then reconnecting to it. See
for the steps to unload a data store from memory.
Moving between 32-bit and 64-bit data stores
The internal format of a 32-bit TimesTen data store differs from that of a
64-bit data store. To convert a 32-bit data store to a 64-bit data store:
1.
Export the 32-bit data store using the TimesTen 32-bit
ttMigrate
utility
with the -
noRepUpgrade
option.
2.
Create a Data Source Name (DSN) for the 64-bit data store. See
“Creating, connecting to and disconnecting from a data store”
in the
TimesTen Developer’s Guide.
3.
Import the file created in Step 1 into the 64-bit data store DSN using the
64-bit
ttMigrate
utility with the -
noRepUpgrade
option.
For example, suppose that the 32-bit data store DSN is
salesdata32
while the 64-bit data store DSN is
salesdata64
. If a 32-bit instance of
TimesTen is installed in
/opt/TimesTen/giraffe32
and a 64-bit
instance is installed in
/opt/TimesTen/giraffe64
, the required steps
are:
1.
/opt/TimesTen/giraffe32/bin/ttMigrate
-c DSN=salesdata32
-
noRepUpgrade
/tmp/salesbackup
2.
/opt/TimesTen/giraffe64/bin/ttMigrate -r
"DSN=salesdata64;AutoCreate=1"
-
noRepUpgrade
/tmp/salesbackup
Note: TimesTen does not support replication between 32-bit and 64-bit
data stores.
Moving to a different major release of TimesTen
You can have multiple TimesTen major releases installed on a system at
the same time. However, TimesTen data stores created by one major
release cannot be accessed directly by applications of a different major
release. To migrate data between TimesTen major releases, for example
from TimesTen 5.1 to 7.0, you need to export the data using the
ttMigrate
utility from the old release and import it using the
ttMigrate
utility from the new release. The procedure for this upgrade is similar to