dm: add a faq about view in dm faq (#12155) (#13185)

pingcap · Apr 7, 2023 · d08def8 · d08def8
1 parent cde84c5
commit d08def8
Show file tree

Hide file tree

Showing 2 changed files with 6 additions and 0 deletions.
diff --git a/dm/dm-faq.md b/dm/dm-faq.md
@@ -34,6 +34,10 @@ When you encounter a DDL statement unsupported by TiDB, you need to manually han
 >
 > Currently, TiDB is not compatible with all the DDL statements that MySQL supports. See [MySQL Compatibility](/mysql-compatibility.md#ddl).
 
+## Does DM replicate view-related DDL statements and DML statements to TiDB?
+
+Currently, DM does not replicate view-related DDL statements to the downstream TiDB cluster, nor does it replicate view-related DML statements to the downstream TiDB cluster.
+
 ## How to reset the data migration task?
 
 When an exception occurs during data migration and the data migration task cannot be resumed, you need to reset the task and re-migrate the data:

diff --git a/dm/dm-overview.md b/dm/dm-overview.md
@@ -57,6 +57,8 @@ Before using the DM tool, note the following restrictions:
 
     - DM reports an error when it encounters an incompatible DDL statement. To solve this error, you need to manually handle it using dmctl, either skipping this DDL statement or replacing it with specified DDL statements. For details, see [Skip or replace abnormal SQL statements](/dm/dm-faq.md#how-to-handle-incompatible-ddl-statements).
 
+    - DM does not replicate view-related DDL statements and DML statements to the downstream TiDB cluster. It is recommended that you create the view in the downstream TiDB cluster manually.
+
 + GBK character set compatibility
 
     - DM does not support migrating `charset=GBK` tables to TiDB clusters earlier than v5.4.0.