Hi. We often use the SQL Dump option to generate a structure-only script of our database objects. This is used in diffs and stored in a repository to track changes. It’s a very convenient approach.
The only thing that makes it hard for us is that the SQL Dump includes the “AUTO_INCREMENT” value in the table script. For example:
CREATE TABLE foo ( id int(11) NOT NULL AUTO_INCREMENT, data text NOT NULL, created_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8
Over time as we run the SQL Dump that AUTO_INCREMENT value increases, leading our repository and diffs to think the table has changed but it hasn’t.
It would be great if there was a checkbox in the SQL Dump tool to say “don’t generate AUTO_INCREMENT value” or the like.