What migration tools and solutions are available for moving from MongoDB to TiDB?

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

Original topic: 从 mongo 到 tidb 都有什么迁移工具、方案?

| username: ShawnYan

There was a post introducing the migration from Mongo to TiDB before. Is there any update or supplement? Or new migration tools or considerations?

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

I have seen a Python script that implements the migration from MongoDB to MySQL before. I haven’t tried it, so I’m not sure if it works, but you can refer to it.

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

Noted, but is it appropriate to migrate Mongo to TiDB? Mongo stores non-relational data, and TiDB’s support for this type of data is generally average…

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

Yes, the issue with field types is significant, and very few people handle it this way.

| username: 随缘天空 | Original post link

  1. TiDB Lightning: This is a tool developed by PingCAP that enables high-speed data import and provides features such as automatic schema conversion and data type mapping.

  2. DMS (Data Migration Service): This is a data migration service provided by Alibaba Cloud, offering a user-friendly interface and configuration options.

| username: 路在何chu | Original post link

I feel it’s safer to find a third-party vendor. It’s fine to migrate a few tables, but migrating the entire business is too risky.

| username: 大飞哥online | Original post link

Field types can drive people crazy; there are many that need to be converted.

| username: ShawnYan | Original post link

Could you please elaborate? Is there an optimal solution for field mapping?

| username: 大飞哥online | Original post link

I tried using DataX to transfer data from MongoDB to MySQL. Later, I handed it over to third-party companies like Yingfang and DSG to handle it.