Hi, I have got v2 running locally with our skin etc (all working well) and am planning to upgrade our db (v1.4004) to try it out. Can I use 'UpdateSQL_1.4000_To_2.000.sql' in the resources folder to do this?
Edit 1: Stuff it, I'm going to try it anyway. will report back.
Edit 2: SQL ran with the following result -
(4 row(s) affected)
Caution: Changing any part of an object name could break scripts and stored procedures.
(263 row(s) affected)
Caution: Changing any part of an object name could break scripts and stored procedures.
(149941 row(s) affected)
The module '_spKartrisCategories_Delete' depends on the missing object 'dbo._spKartrisProducts_DeleteByCategory'. The module will still be created; however, it cannot run successfully until the object exists.
The module '_spKartrisCategories_Delete' depends on the missing object 'dbo._spKartrisPromotions_DeleteByParent'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 207, Level 16, State 1, Procedure _spKartrisLogins_Add, Line 36
Invalid column name 'LOGIN_PushNotifications'.
Msg 207, Level 16, State 1, Procedure _spKartrisLogins_GetList, Line 20
Invalid column name 'LOGIN_PushNotifications'.
Msg 207, Level 16, State 1, Procedure _spKartrisLogins_Update, Line 43
Invalid column name 'LOGIN_PushNotifications'.
The module '_spKartrisProducts_Delete' depends on the missing object 'dbo._spKartrisVersions_DeleteByProduct'. The module will still be created; however, it cannot run successfully until the object exists.
The module '_spKartrisProducts_Delete' depends on the missing object 'dbo._spKartrisPromotions_DeleteByParent'. The module will still be created; however, it cannot run successfully until the object exists.
The module '_spKartrisUsers_Delete' depends on the missing object 'dbo._spKartrisUsers_DeleteOrders'. The module will still be created; however, it cannot run successfully until the object exists.
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)