Checking Whether Destination Database Contains the Same Object Names As Those of the Synchronization Objects
MySQL -> PostgreSQL Synchronization
| Check Item | Whether destination database contains the same object names as those of the synchronization objects. |
|---|---|
| Description | The destination database contains the same table names as those of the synchronization objects. If a table of the same name exists in the destination database, the migration cannot be performed. |
| Failure Cause and Handling Suggestion | Failure cause: The source and destination database tables cannot have the same names. Handling suggestions: Check whether the tables with the same names need to be retained. If yes, select another object for synchronization. If no, delete the tables with the same names. |
| Failure cause: The destination database contains the same table names as those of the synchronization objects. Handling suggestions: Check whether the tables with the same names need to be retained. If yes, select another object for synchronization. If no, delete the tables with the same names. |
Oracle -> PostgreSQL Migration
| Check Item | Whether destination database contains the same object names as those of the synchronization objects. |
|---|---|
| Description | The destination database contains the same object names as those of the source database. If the same object names exist, the migration cannot be performed. |
| Failure Cause and Handling Suggestion | Failure cause: The destination database contains the same object names as those of the source database. Handling suggestions: Check whether the objects with the same names need to be retained. If yes, select another object for migration. If no, delete the objects with the same names. |
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.