Migrating Oracle to TiDB

Translated
1

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

Original topic: oracle迁入tidb

| username: 喵父666

Has anyone migrated from Oracle to TiDB? Are there any precautions to take?

2
| username: Soysauce520 | Original post link

Table structure, character set

3
| username: zhanggame1 | Original post link

I’ve been working on it recently. TiDB does not support custom functions or stored procedures, but other issues are fine. For import and export, you can use CSV files and load them with Lightning, or use some tools for data transfer. The character set conversion from GBK to UTF-8 has no impact.

4
| username: Fly-bird | Original post link

Oracle stored procedures are not supported; directly use Dumpling for export and import.

5
| username: Kongdom | Original post link

You can refer to this column

6
| username: YuchongXU | Original post link

Does not support incremental, special fields.

7
| username: 托马斯滑板鞋 | Original post link

:upside_down_face: If using OGG, you need to be aware of the license issues (the article above didn’t mention this).

8
| username: heiwandou | Original post link

Table structure, field conversion, large fields, functions, stored procedures

9
| username: TiDBer_小阿飞 | Original post link

There is no difference from migrating from ORACLE to MySQL, modifying the character set and table structure conversion, and some large fields are not supported.

10
| username: 喵父666 | Original post link

Yeah :grinning:

11
| username: 喵父666 | Original post link

The main issues are still the lack of support for incremental updates, special fields, oversized data, and custom fields.

12
| username: 喵父666 | Original post link

Other normal support

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

There is a tool that supports heterogeneous data structure conversion from Oracle to MySQL/TiDB:

14
| username: 喵父666 | Original post link

Thank you, expert.

15
| username: 喵父666 | Original post link

I’ll go take a look at this.

16
| username: TiDBer_小阿飞 | Original post link

I’ll bookmark this first out of habit!

17
| username: Kongdom | Original post link

:+1: :+1: :+1: Perfect tool~

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

It was developed by a certain expert within PingCAP and has not been released to the public.

19
| username: Kongdom | Original post link

:yum: I want to be in front of the users~

20
| username: zhanggame1 | Original post link

The Navicat tool has a data transfer feature that will work.