Send feedback Replication schema changes Stay organized with collections Save and categorize content based on your preferences. This page lists the supported schema changes to the source database when using Cloud Data Fusion Replication .
Supported data definition language (DDL) statements in Replication MySQL The following table lists supported DDL statements from the MySQL source database to the BigQuery destination.
DDL statements Supported in Replication Create table Rename table Truncate table Drop table Add nullable column Add required column Alter column to make it nullable Alter column to make it required Alter column type Rename column Drop column
Oracle The following table lists supported DDL statements from the Oracle source database to the BigQuery destination.
DDL statements Supported in Replication Create table Rename table Truncate table Drop table Add nullable column Add required column Alter column to make it nullable Alter column to make it required Alter column type Rename column Drop column
SQL Server Schema changes for SQL Server are not automatic and you must perform a few steps manually. For more information, see Change schemas in a SQL Server replication job .
The following table lists supported DDL statements from the Microsoft SQL Server source database to the BigQuery destination.
DDL statements Supported in Replication Create table Rename table Truncate table Drop table Add nullable column Add required column Alter column to make it nullable Alter column to make it required Alter column type Rename column Drop column
What's next Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-10-16 UTC.
Need to tell us more? [[["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-10-16 UTC."],[],[]]
