Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Contains Unsupported Generated Columns
Updated on 2024-06-07 GMT+08:00
View PDF
Share

Checking Whether the Source Database Contains Unsupported Generated Columns

If there are tables where a generated column is a primary key or unique key in the source database, DRS cannot synchronize the structure of generated columns. As a result, data may be inconsistent after being synchronized to the destination database.

Failure Cause

There are tables where a generated column is a primary key or unique key in the source database.

Handling Suggestion

  • Create a table structure in the destination database to ensure that logic and constraints of generated columns in the destination database are the same as those in the source database. Return to the object selection page, deselect Table structure for Synchronization Object Type and perform the pre-check again.
  • Return to the object selection page, delete the tables where a generated column is a primary key or unique key from the synchronization object, and perform the pre-check again.
Parent topic: Database Parameters