Is there a migration solution for TiDB to Oracle?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb对于oracle,也有迁移方案吗?

| username: yytest

Can Oracle migrate data to TiDB?

| username: hacker_77powerful | Original post link

I also support migrating Oracle to TiDB, let’s adapt the code first.

| username: lemonade010 | Original post link

The usual methods for migrating data (incremental + full) from DB2 and Oracle to TiDB are:

  • Using Oracle’s official migration tools, such as OGG, Gateway (Transparent Gateway), CDC (Change Data Capture).
  • Developing custom data export and import programs.
  • Exporting (Spool) to text files and then importing through Load infile.
  • Using third-party data migration tools.

Currently, OGG seems to be the most suitable.

| username: 健康的腰间盘 | Original post link

Third-party tools, cc is pretty good.

| username: tidb菜鸟一只 | Original post link

If the main goal is to migrate from Oracle to TiDB, the amount of program modification required is relatively large. However, migration is possible, and tools like CanalCloud can be used for the migration.

| username: forever | Original post link

It can be migrated, but the modifications after migration are too extensive, such as stored procedures, functions, packages, etc., and there are also differences in SQL. TiDB is compatible with MySQL.

| username: 像风一样的男子 | Original post link

You can try CloudCanal
It supports migration from Oracle to TiDB

| username: TiDBer_QYr0vohO | Original post link

CanalCloud

| username: zhanggame1 | Original post link

I recently also migrated from Oracle to TiDB, using Navicat for data transfer.

| username: 友利奈绪 | Original post link

Both cc and manual client migration are possible.

| username: kelvin | Original post link

Currently, TiDB does not support stored procedures, functions, etc. If migrating from Oracle, the subsequent modifications could be quite extensive.

| username: 小于同学 | Original post link

Sure.

| username: 鱼跃龙门 | Original post link

Canalcloud, Navicat, and the client can all be used, but the changes after migration are significant.

| username: TiDBer_HUfcQIJx | Original post link

Navicat works.

| username: dba-kit | Original post link

The commercial version of TiDB also has a migration solution from Oracle to TiDB, but it has not been open-sourced. For details, you can see: Oracle 到 TiDB 迁移解决方案 | PingCAP

| username: zhaokede | Original post link

I have used the third-party Kettle tool to migrate small-scale databases.

| username: 濱崎悟空 | Original post link

There are many points to consider when migrating from Oracle to TiDB.

| username: zhanggame1 | Original post link

Navicat’s data transfer is quite fast even for tens of gigabytes. You can open multiple transfer windows, and as long as the database performance is sufficient, it can handle tens of thousands of records per second. Do not select transactions, otherwise TiDB will OOM.

| username: vincentLi | Original post link

Paid tools can use DSG, which supports both full and incremental backups. It’s very powerful. It has been used in production environments without any issues.

| username: Jack-li | Original post link

Those who enjoy tinkering can give it a try.