I've got a problem with my top level table.

The primary was built as an autonumber and set to Primary Key..

However, when I import to SQL Express, the field goes in as a Primary Key but is not set as the Identity field.

Any ideas what is going on here ?

How are you putting it into SQL Server Express? You should be using the SSMA (SQL Server Migration Assistant).

Yes.. I'm using the SSMA tool..

What happens if you go into design view in the SQL Server table and change Identity to YES?

I've tried, but I cannot change it.. there is no drop down.. and cannot overwrite the value 'NO'

This is a database i have upsized on my own desktop to use for initial testing..

Think I have found the problem.. For some reason the field was being upsized with a Default Value of zero.

Thanks