MySQL Bugs: #10823: It does not migrate always autoincrement fields from MS-Access or SQLServer

Bug #10823	It does not migrate always autoincrement fields from MS-Access or SQLServer
Submitted:	24 May 2005 11:51	Modified:	9 Jun 2006 12:06
Reporter:	Dimitris Nikos Theodorakopoulos	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S1 (Critical)
Version:	1.06Beta	OS:	Windows (Windows XP Pro SP2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
I am trying to migrate a database schema of 320 tables from an MS-Access database (I am using MS-Office 2003) to a MySQL database 4.0.22 standard (on the internet). In some of the tables, it transforms auto_increment (primary key) fields to simple integer(10) fields.

How to repeat:
OS: Microsoft Windows XP Pro SP2
MS-Access DB: MS-Office 2003
MySQL version: 4.0.22 standard
MySQL Migration Toolkit version: 1.06beta
MySQL JDBC Drivers: MySQL J Connector 3.1.8a

Try to migrate an Access Database with tables with autoincrement primary keys.

Verified against SQLServer as well.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Bug: http://bugs.mysql.com/bug.php?id=17234 was marked as
duplicate of this one.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html