Schema comparison between DB and database projects shows differences even though objects are equal

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
SchmittDotNet
Posts: 7
Joined: Mon 15 Jun 2020 15:41

Schema comparison between DB and database projects shows differences even though objects are equal

Post by SchmittDotNet » Mon 13 Jul 2020 10:14

Hi,
I am using dbForge Studio for MySQL 9.0.338 to connect to Azure Database for MySQL 5.7.29.

We have a database with 114 tables and an associated database project. Schema comparison claims that 6 of the 114 tables are different in DB and project even though they are not. The lower part of the result window does not show any differences.

Actually, on each synchronization of the "different" tables a new Create table comment block is added at the top of the SQL script file:

--
-- Create table `contracts`
--
--
-- Create table `contracts`
--
--
-- Create table `contracts`
--
--
-- Create table `contracts`
--
CREATE TABLE contracts (

alexa

Re: Schema comparison between DB and database projects shows differences even though objects are equal

Post by alexa » Mon 13 Jul 2020 15:46

Could you please provide us the CREATE definitions of the compared Source and Target objects you are experiencing the issue with?

You can send the reply straight to our support system at supportATdevartDOTcom.


alexa

Re: Schema comparison between DB and database projects shows differences even though objects are equal

Post by alexa » Wed 15 Jul 2020 08:25

Thank you for the reply.

We have received your e-mail and will answer you as soon as possible.

Post Reply