2.0 to 2.1 CE Upgrade

Here is the command-line utility that I used to upgrade my SQL Server Compact Edition database from 2.10 to 2.20. Currently, the utility only works to upgrade from 2.10 to 2.20. It will not upgrade earlier versions of a nopCommerce database.

I cannot stress this enough: backup your data! I am not responsible for any data loss that might occurr when you use this application.

Requirements:
Microsoft Windows Operating System
.NET 4.0
Copy of a nopCommerce 2.10 SQL Server CE database

Usage example:
UpdateNopComCE.exe -i C:\Nop.Db.sdf -o C:\upgraded\Nop.Db.sdf -sv 2.10 -dv 2.20

After you run the above command, if the upgrade is successfull, you should see the following output:
Creating destination database...
Opening connection to database...
Updating language id 1
Creating missing settings...
Creating missing tables...
Upgrade Complete.

In my testing, I was able to take the resulting database (in C:\upgraded\Nop.Db.sdf) and drop it over an existing SQL CE database from a test copy of nopCommerce 2.20 and everything seemed to function properly.

Please report back here with your results.

Download the utility here.

Hi Centrolsolutions

Good work, would love to try this utility, is there a way to update the code to work upgrading from v2.00 to v2.10.

Best Regards
Steve

hello

exist this utility to update nopcommerce from 2.40 to 2.50 or source utility??

Hi

Something wrong with nopcommerce 2.1 . could not go with upgrade process further or installation as separate project, so what I did to get around of this,

1. run upgrade script for database in a sequence (1.9>2.0>2.1.....>3.5) make a backup of every step.
2. download project version same as the upgraded database version. (e.g data base has been upgraded to 3.5 (final script of 3. version has run through) and then need to download nopCommerce3.5 source to run with the same database version).

  Note: nopCommerce version would be same as the version of database upgrade script has run through.

3. Rebuild project, add App_Data\Settings.txt , App_Data\InstalledPlugins.txt  
note: make sure your project is setup as debug mode.

Then you debug project then should go through successfully.

you could skip all the project version to go through.


Cheers