L.K wrote:Hi All,
We have a website already in nopCommerce 1.9.We want to upgrade the site from 1.9 to latest version 3.40.We will plan to use "Traction" theme in our website.We are going to complete migration for new look and theme.We want our 1.9 version database and images.
Could you please advise me on this below.
1.For upgrading Database from 1.9 to 3.4.Is it enough to run database upgrade scripts in our database i.e executing 2.00 DB upgrade scripts in 1.9 DB and executing 2.10 DB upgrade scripts in 2.00 etc.
2.Is it required Install 2.00 nopcomerce pakage, then 2.10 nopcommerce etc.
I am new to this upgrade. Kindly help me on this.
Regards,
Elavarasi
Comments / Answers:
1) Yes
2) No - You can simply run the upgrade script against your database
(I believe in 2.0 upgrade folder, there are intructions something like "Read Me" or similar that explains steps for upgrading because that is the crucial step as 2.0 is the first MVC version after webforms)
Please feel free to ask any questions if you face any issues while upgrading process :)
Dear Support Team,
I got the following error on executing the 2.0 DB upgrade script in 1.9 DB
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Customer'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Address'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Country'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'StateProvince'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'ShippingMethod'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TaxCategory'.
Msg 208, Level 16, State 1, Line 8
Invalid object name 'Setting'.
.
.
.
etc
How can i fix this?...can I change script ex: table name 'Customer' into 'Nop_Customer'..But no column 'IsSystemAccount'
Please help on this..this break my head..
Regards,
Ela