Autonumbers and Upsizing to SQL Server

[winshent]

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 ?

 

[boblarson]

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

 

[winshent]

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

 

[boblarson]

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

 

[winshent]

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..

 

[winshent]

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

Thanks