Table compare should ignore AUTO_INCREMENT value?

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

Table compare should ignore AUTO_INCREMENT value?

Postby senorplankton » Fri Jul 16, 2010 11:09 am

When comparing databases on a Windows MySQL system, the table create script seems to include the AUTO_INCREMENT value.

The table comparison then picks this up as a difference between tables.

Looking in the comparison window shows that the AUTO_INCREMENT is included when there is data in the table.

This does not occur when comparing on a Linux system, even though the result of 'copy CREATE to clipboard' includes the AUTO_INCREMENT on both systems.

When comparing a db on a Linux system to one on a Windows system, the AUTO_INCREMENT is included only on table create on the Windows db.

It would make sense that the AUTO_INCREMENT=xx part of the creation script should be removed before comparison.

(I can provide a backup that demonstrates this behaviour if needed)
Posts: 8
Joined: Thu Jul 15, 2010 6:11 pm

Postby michabb » Wed Aug 25, 2010 12:45 am

yes, please make this optional, every table is marked as changed, all because of this auto-increment ;-(((
Posts: 3
Joined: Tue Aug 24, 2010 4:16 pm

Postby kAlvaro » Thu Oct 14, 2010 9:33 am

Furthermore, AUTO_INCREMENT is added to the ALTER TABLE statements. It doesn't make any sense when table data is not even considered in the synchronization.
Álvaro G. Vicario - Burgos, Spain
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain

Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 0 guests