Can't upgrade or import my database from v 1.4 to v 1.7

Hi,

I am trying to copy the database of version 1.4 to version 1.7 and get Foreign Key constraints errors.

Does anyone know how to import my data from version 1.4 database to version 1.7?

Thank you.

you're updating a database 1.4->1.5->1.6->1.7 or 1.4->1.7?

1.4 to 1.7

you must upgrade the database step by step 1.4->1.5->1.6->1.7.

Actually I had v 1.5. Now I tried to upgrade to v 1.6 and I am getting the error:

An error occured: Cannot insert the value NULL into column 'ShortDescription', table 'albert_store.dbo.Nop_Product'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Running scripts from file: C:\inetpub\wwwroot\nopCommerce_1.60\NopCommerceStore\install\Scripts\1.60\nopCommerce_upgrade.sql


I checked and the field allows nulls - the box for nulls is checked. So how can it say cannot insert NULL

Any help appreciated.