Given that the release notes indicated that all files had changed, I took the handful of very minor changes we made to our 1.2 installation and copied them manually to the 1.4 code files. The release changes log indicated I needed to upgrade the database manually, so I found the upgrade sql files.
I tried executing the 1.3 script (to upgrade from 1.2 to 1.3) and I got a heap of errors (too many to post but the first are here - can post all of them if you need)
Msg 515, Level 16, State 2, Line 14
Cannot insert the value NULL into column 'SettingID', table 'RGShop1.4.dbo.Nop_Setting'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Line 8
Cannot insert the value NULL into column 'SettingID', table 'RGShop1.4.dbo.Nop_Setting'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Then I tried executing the 1.4 script on the off chance that might work better - it did not.
I then tried creating an empty database, using CreateDatabase.sql and CreateData.sql, then attempted an import of the data from the 1.2 store but that failed validation.
Is there an official procedure for upgrading from 1.2 to 1.4? What have I done wrong? Thanks! :)