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.
849 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,058 questions
Accepted answer
  1. Tom van Stiphout 1,701 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
Most helpful Newest Oldest