Red Gate forums :: View topic - Table compare should ignore AUTO_INCREMENT value?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Compare
MySQL Compare forum

Table compare should ignore AUTO_INCREMENT value?

Search in MySQL Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
senorplankton



Joined: 15 Jul 2010
Posts: 8

PostPosted: Fri Jul 16, 2010 11:09 am    Post subject: Table compare should ignore AUTO_INCREMENT value? Reply with quote

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)
Back to top
View user's profile Send private message
michabb



Joined: 24 Aug 2010
Posts: 3

PostPosted: Wed Aug 25, 2010 12:45 am    Post subject: Reply with quote

yes, please make this optional, every table is marked as changed, all because of this auto-increment ;-(((
Back to top
View user's profile Send private message
kAlvaro



Joined: 18 Jan 2010
Posts: 9
Location: Spain

PostPosted: Thu Oct 14, 2010 9:33 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group