Page 1 of 1

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

Posted: Mon 13 Jul 2020 10:14
by SchmittDotNet
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 (

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

Posted: Mon 13 Jul 2020 15:46
by alexa
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.

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

Posted: Tue 14 Jul 2020 15:28
by SchmittDotNet
I sent some samples by email.

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

Posted: Wed 15 Jul 2020 08:25
by alexa
Thank you for the reply.

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