GBase Migration Toolkit User Guide

Published on 2020-10-16

I. Tool Introduction
 

GBase Migration Toolkit is a data object migration tool independently developed by GBase, providing a graphical interface for automated migration of metadata and user data between different databases on a per-task basis.

This tool is developed based on a client-server architecture. Users can configure, manage, and monitor tasks through a visual interface, or run it via command line for better cross-platform compatibility. The graphical component primarily provides functions for migration configuration, task management, task execution, and monitoring. The actual extraction, transformation, and loading of migration content into the target database are handled by the execution engine.

The existing product supports Oracle, SQL Server 2005, DM, DB2, MySQL, GBase 8s V8.3, GBase 8s, and other databases. It has been extended to include PostgreSQL support and can automatically match database types based on predefined rules, enabling automated migration of table structures and data.

II. PG to 8s Migration Steps
 

1. Launch the migration tool

2. Create a new migration task

3. Select source and target databases

4. Configure connection information
 

PG connection info:

8s connection info:

5. Configure migration objects, select table t1, and check “Migrate table structure” and “Migrate data”:

6. Configure data type mapping:

7. Click “Finish” to complete task creation:

8. Start the migration task