Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Allow Schema Comparison to ignore differences in integer "size"

In versions of MySQL prior to 8.0, integer values were specified with a "size", such as "INT(11)". In MySQL 8.0 and newer, the size property of integers is removed, resulting in the same value having the type "INT". This results in Schema Comparison across MySQL versions (5.7 vs 8.0) reporting false-positive differences for tables.

The "ignore data types" option in Schema Comparison does not resolve the false positives, and is also probably too blunt, because column size does matter for text and binary data. Please add an option to specifically ignore differences in the "size" of integers.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Eric Rasmussen shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Dear User,

    Thank you for your post!

    We wanted to inform you that we were unable to reproduce the behavior you described in Schema Compare. Could you please specify the version of Schema Compare you're using and provide a screenshot of the issue?

    You can send it directly to our Support Team using this contact form: https://www.devart.com/company/contactform.html

    Best,
    Devart Team