Cannot update identity column SQL Server 2016

[jeffw8713]

@JamesK

Another things to consider is that if you are migrating from SQL 2008 to SQL 2016, the behavior of the identity column between restarts of the server would be different between the two versions. In SQL 2008 you can expect the values to be contiguous (with some exceptions e.g. rollbacks), but in SQL 2016, that is not guaranteed.

Unless I am reading this wrong - the OP is not upgrading from SQL Server 2008 to SQL Server 2016, rather just upgrading the OS from 2008 to 2016.

For an import process - you would have to SET IDENTITY_INSERT ON for the table to allow inserting of the existing identify values, which is what I think the OP is running into...