Bug #29132 MS Access-2-MySql create script missing certain not null clauses

• Submitted: 15 Jun 2007 9:18
• Modified: 16 Jul 2007 0:29
• Reporter: Darren S. Eyers
• Status: No Feedback
• Category: MySQL Migration Toolkit
• Severity: S2 (Serious)
• Version: 1.1.12
• OS: Windows (Win Xp Sp2)
• CPU Architecture: Any
• Tags: NOT NULL, required

[15 Jun 2007 9:18] Darren S. Eyers

Description:
Mugrating an MS Access 2000 db to MySql 5.0 using migration wizard on Windows XP SP2.

Go though the wizard and specify a file to place the create statements in.  Looking at the file I can see that some columns which were specified as "Required" (not null) do not appear with "Not Null" in the generation script.

The only one that came across as "Not Null" was the ID Primary key column (which is implicitly required and has no Required option).

Other fields like Date, Text did not come across with required "Not Null" paramater to the file....

How to repeat:
Create a MS Access 2K db.  Create a table with some columns with required set to "Yes".  Use Migration wizard and specify an output creates sql file.

Open file and Not Null missing on non primary key columns!

Suggested fix:
Lookup the required attribute to see whether set to Yes or No.

[16 Jun 2007 0:29] MySQL Verification Team

Thank you for the bug report. Could you please provide a small *.mdb
sample file?. Thanks in advance.

[16 Jun 2007 10:42] Darren S. Eyers

Emplyee Example Db & Created DDL & DML Scripts

Attachment: EmployeeDb.zip (application/zip, text), 22.40 KiB.

[16 Jul 2007 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".