# Migration Methods: Overview

__*Migration Methods*__

| Preferred Method | `TiDB` to `TiDB` | `MySQL(5.6、5.7 and 8.0)-compatible` to `TiDB` | Heterogeneous Database(`Oracle`，`PostgreSQL` and `SQL Server`) to `TiDB` |
| :--------------- | :-------------------------------------------------------- | :---------------------------------------------------------------- |
| Database Migration Service | Yes | Yes | Yes |
| Data migration by `DM`、`TiCDC` | Yes | Yes | NO |
| Data migration by `lightning`、`TiCDC` | Yes | Yes | NO |
| Conventional `Data Export(SQL\CSV)` and `Import(lightning)`  | Yes | Yes | Yes |
| Conventional `BR` Backup and Recovery | Yes | NO | NO |

---------------------------------------------------------------------------

The methods shown in the table are applicable when migrating an `TiDB`, `MySQL(5.6、5.7 and 8.0)-compatible`, Heterogeneous Database(`Oracle`，`PostgreSQL` and `SQL Server`) or On-Premises or Cloud databases to an `TiDB` database cluster in the cloud.
Note: Some of these methods will be discussed in detail in subsequent lessons.