convert sql ce to sql express

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 years ago
Does anyone knows how to switch from SQL CE to SQL Express in nopCommerce?

I'm using nopCommerce 2.30. I converted the database from sql ce to sql express and executed two scripts that are available in App_Data to create indexes and stored procedures and changes connection string (and tested it so the connection string is ok) and now after browsing to the same address it keeps getting an error that says there is an invalid column in database.

I did the above procedure again to make sure there is no human error happening.
0
12 years ago
not sure but you can copy the tables if push come to shove. Copy and paste. I had problem when I tried to upgrade express. Just do this to a brand a new database and copy the tables.

There is an upgrade program for SQL 2008 r2

programs >SQL> import and export data X32 or x64


maybe you can get this a stand alone


SQL Import and Export Wizard found on r2


Hope this helps

Mikw
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.