I got an error when using MSSMAA and cannot migrate to SQL Server

RENE COUZINIER 20 Reputation points
2024-02-04T21:43:19.5533333+00:00

When I start MSSMAA i got an error: Starting conversion... Analyzing metadata... Converting table Samod_Relèves.[AMaTable_Elec] ... Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ResultID' was converted to a check constraint. Conversion finished with 0 errors, 0 warnings, and 1 informational messages. An unexpected error occurred. Please send the log file to product support. For more information, see "Getting SSMA Assistance" in the product documentation. La référence d'objet n'est pas définie à une instance d'un objet.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 questions
{count} votes

Accepted answer
  1. Tom van Stiphout 1,606 Reputation points MVP
    2024-02-04T23:36:47.9733333+00:00

    (Please change the misspellings of SSMA in your post, so others can find it too in future). I would encourage you to do what the error message says: Please send the log file to product support. The ZLS warning is completely normal and not the cause of this issue. Then I would remove this table from being upgraded, and see how well the other tables work.


0 additional answers

Sort by: Most helpful