Table fails to upsize

[David Anderson]

I am using SSMA to migrate a back end Access 2003 database to an MDF file
(in SQL Server Express 2005). All but one of my tables convert to SQL Server
format, complete with all data. The report for the problem table only lists
a bunch of information messages, none of which look very important. Despite
there being no errors or warnings, no data is transferred to the new table.
What might be going wrong here?

David

[David Anderson]

This problem is now resolved, after getting advice on another forum. One of
the field definitions in the problem table had been changed in Access to
disallow nulls but some existing records already contained nulls in that
field. Access did not complain about this situation but it was enough to
give SSMA a headache.

David

Post by David Anderson
I am using SSMA to migrate a back end Access 2003 database to an MDF file
(in SQL Server Express 2005). All but one of my tables convert to SQL
Server format, complete with all data. The report for the problem table
only lists a bunch of information messages, none of which look very
important. Despite there being no errors or warnings, no data is
transferred to the new table. What might be going wrong here?
David