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 (
Schema comparison between DB and database projects shows differences even though objects are equal
-
- Posts: 7
- Joined: Mon 15 Jun 2020 15:41
Re: Schema comparison between DB and database projects shows differences even though objects are equal
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.
You can send the reply straight to our support system at supportATdevartDOTcom.
-
- Posts: 7
- Joined: Mon 15 Jun 2020 15:41
Re: Schema comparison between DB and database projects shows differences even though objects are equal
I sent some samples by email.
Re: Schema comparison between DB and database projects shows differences even though objects are equal
Thank you for the reply.
We have received your e-mail and will answer you as soon as possible.
We have received your e-mail and will answer you as soon as possible.