Document Type | Technical Information
Category | Migration
Applicable Product Versions l Tibero 5,6,7
Document Number | TMITI023
Overview
T-Up is a utility provided by Tibero DB that can be used for compatibility assessment and migration.
Note
T-Up is available for download from Technet.
- Implemented in Java language, usable from Java 1.5.17 and above
- After decompression, run the executable file matching the jre bit version you want to run
- Connects to Source database and Target database using third-party JDBC drivers
Example) t-up\lib\ojdbcx.jar attachment required
Method
Introduction to T-up
T-Up Screen
The migration tool T-Up consists of an Analyzer that evaluates Tibero migration compatibility and a Migrator that automatically converts schemas and data based on the evaluation.
T-Up Migration
Provides a method for data transfer using the GUI environment of T-Up Migrator, ensuring easy and fast migration without additional work for data transfer.
User Permissions for Connection
Users connecting to the source and target databases must be granted the necessary permissions for migration tasks. (It is recommended to use users granted DBA privileges)
- If SELECT ANY TABLE permission is not granted, there may be issues with querying tables to be migrated.
Required User Permissions When Connecting to Source Database (When migrating in full mode from third-party products)
| Permission | Description |
|---|---|
| CONNECT | Permission to connect to the database |
| SELECT ANY TABLE | Permission to select any table |
| SELECT ANY DICTIONARY | If SELECT ANY DICTIONARY permission does not include query rights on SYS DATA DICTIONARY TABLE, additional permissions need to be granted on the following tables โ constraint : sys.user$, sys.con$, sys.cdef$ โ mview : sys.snap$ |
| ALTER SESSION | Permission to alter the session |
Migration Process
1. Verify Connection Information
source database
| Item | Description |
|---|---|
| DB Type | Select the third-party DB to connect |
| Connection Name | Assign an arbitrary connection name |
| User ID | DB user ID |
| Password | Password for accessing user |
| Address | IP address of the DB |
| Port | Port number of the DB |
| DB SID | Database SID Name |
| File Path | Location to save connection information |
| Connect As | Password of the accessing user |
| Target | Type of Target DB |
| ORACLE p.ervicelD | Additional connection information storage |
2. Data Type Conversion
Type Mapping Rule
| Item | Description |
|---|---|
| Rule Name | Assign an arbitrary Rule Name |
| Selectable Mapping | Select Data Type Conversion |
| Default Mapping | Default Data Type Conversion between heterogeneous DBs |
3. Select Schema Objects
Select the schema objects to be converted
4. Verify Migration Options
Data Transfer
| Item | Description |
|---|---|
| Data Transfer | Select whether to migrate table data |
| Conventional Path Loading | Migrate table data using Conventional Path Loading method |
| Use Direct Path Loading | Migrate table data using Direct Path Load method |
| Direct Path Loading with HyperLoader | Migrate table data using Direct Path Load method with Details option |
| Read as Bytes | Option used when fetching and transferring data in binary form |
| Double Character Column Size | Option to change the length to twice the size specified in the source DB |
| Truncate Data Exceeded Max Length | Option to choose whether to truncate or error out when column length exceeds the maximum length specified by Tibero |
| TSN | Set TSN unit during migration |
DDL
| Item | Description |
|---|---|
| DDL Execution | Decide whether to execute the extracted DDL statements on the target database |
| Export DDL Script | Save extracted DDL statements to a file by setting Filename and Path |
| Character Semantic as CHAR | Perform string semantic analysis on related objects |
5. Proceed with Data Migration
| Item | Description |
|---|---|
| Migrate | Proceed with migration based on selections in Schema Object and Migration Option |
| Current Schema | Schema currently being migrated |
| Current Stage | Current stage of migration progress |
| Stage Progress | Migration progress status |
| Start Time | Time when migration started |
| End Time | Time when migration ended |
| Created Objects | Number of created objects |
| Errors | Number of errors during migration |
Compatibility Assessment
Provides functionality for pre-compatibility assessment and review before migrating data and schemas, offering users a more reliable and efficient working environment.