Schema comparison between DB and database projects shows differences even though objects are equal
Posted: 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 (
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 (