Problem with SSMA Access 2008 Migration Tool RRS feed

  • Question

  • I have tried to upgrade a Access-2007 Database to SQL-Server 2008 with the Tool SSMA for Access-2008.

    This was so far successfull (some minor errors/warnings) but many relations between tables were not transferd to the SQL-Server DB

    without any Error/Warning-Messages in the SSMA Tool ...

    The problem seems to be if ther are more than one relations from the same Code-Table to the same Main-Table (Code1,Code2,Code3)

    only one of this 3 relation is transfed to the SQL-Server-DB and other relation of the Main-Table are missing without any error/warnings.

    This problem occures only if more than one Relations (from same Code-Table) is set to "Cascade Update" in Access.

    How can i solve this problem or is this a bug off the SSMA Tool ?

    Thanks in advance, Mark G.


    Tuesday, August 31, 2010 9:22 AM


  • Hi Mark,


    This is Ramesh from SSMA Team. Can you please share your .mdb file to reproduce the same issue here and provide you with the solution?

    Also, please mention the table name for which relations are not converted and describe the issue. If the .mdb file is too large and can’t be send it through mail, please send the SSMA Access project.


    Please post all your details to ssmahelp@microsoft.com


    Steps to save SSMA Project:


    Please send us the SSMA Sybase project to analyze further. Please follow the following steps to save the metabase in project folder.

    (1)    Create a new project in SSMA

    (2)    Load Access .mdb file

    (3)    After metadata is loaded, press Save Project

    (4)    When asked which databases to load, choose the database which have objects which you are trying to convert and the dependent objects.


    (5)    After save operation finishes, close SSMA.

    (6)    Go to project folder and ensure that source-metabase.mb file exists.

    (7)    Remove report folder  if any.

    (8)    Pack the project folder and send it.

    • Proposed as answer by Ramesh Buddepu Thursday, September 2, 2010 1:52 PM
    • Marked as answer by Keshav Ramarao Wednesday, September 15, 2010 5:51 PM
    Thursday, September 2, 2010 1:49 PM