Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Tables Contain Data Types Not Supported for Migration
Updated on 2022-12-30 GMT+08:00

Checking Whether the Source Database Tables Contain Data Types Not Supported for Migration

Microsoft SQL Server as the Source in Synchronization

Table 1 Checking whether the source database tables contain data types not supported for migration

Check Item

Whether the source database tables contain data types not supported for migration

Description

The source database tables cannot contain the SQL_VARIANT, GEOMETRY, and GEOGRAPHY data types. Otherwise, the synchronization task fails.

Item to Be Confirmed and Handling Suggestion

Failure cause: The source database tables contain data types that are not supported.

Handling suggestions: Check whether the tables to be migrated in the source database meet the synchronization requirements.