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
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 2024-04-24 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
