[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThis page outlines the supported schema changes (DDL statements) for MySQL, Oracle, and SQL Server databases when using Cloud Data Fusion Replication to BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eMySQL and Oracle databases support a comprehensive list of automatic DDL changes, including creating, renaming, truncating, and dropping tables, as well as modifying columns.\u003c/p\u003e\n"],["\u003cp\u003eSQL Server requires manual steps for schema changes, and it also supports the same DDL changes as MySQL and Oracle within Cloud Data Fusion Replication, but they are not automatic.\u003c/p\u003e\n"],["\u003cp\u003eAll three databases (MySQL, Oracle, and SQL Server) have the same supported DDL changes.\u003c/p\u003e\n"]]],[],null,["# Replication schema changes\n\nThis page lists the supported schema changes to the source database when using\nCloud Data Fusion [Replication](/data-fusion/docs/concepts/replication).\n\nSupported data definition language (DDL) statements in Replication\n------------------------------------------------------------------\n\n### MySQL\n\n\nThe following table lists supported DDL statements from the MySQL source\ndatabase to the BigQuery destination.\n\n### Oracle\n\n\nThe following table lists supported DDL statements from the Oracle source\ndatabase to the BigQuery destination.\n\n### SQL Server\n\n\nSchema changes for SQL Server are not automatic and you must perform a few\nsteps manually. For more information, see [Change schemas in a SQL Server\nreplication job](/data-fusion/docs/how-to/change-schemas-in-replication).\n\nThe following table lists supported DDL statements from the Microsoft SQL\nServer source database to the BigQuery destination.\n\nWhat's next\n-----------\n\n- Learn more about [Replication in Cloud Data Fusion](/data-fusion/docs/concepts/replication).\n- Learn more about [SQL Server schema changes in Replication](/data-fusion/docs/how-to/change-schemas-in-replication)."]]
