Question: Why Microsoft Upsizing Wizard 2002/2003 crashed when I was trying to upsize Northwind database?
I changed field size property of Customers!CustomerID from 5 to 6. I was unable to upsize Northwind database using Microsoft Upsizing Wizard 2002/2003.
If I used Microsoft Upsizing Wizard 97/2000 it falls over without reporting any errors.
SQL Server cannot have this and the Microsoft Upsizing Wizard 2002/2003 will crash and Microsoft Upsizing Wizard 97/2000 fall over with this message:
>Server Error 1753: Column Customers!CustomerID is not the same length as referencing column column Orders!CustomerID.
The solution is to change the field size of Customers!CustomerID back from 6 to 5."