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

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

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

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