Moving from SQL CE to SQL Server 2008 R2

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

Total Posts: 15
Karma: 115
Joined: 10/24/2011
Location: United States

Posted: 11 years ago

Hi Everybody,

I'm tired of never being able to upgrade to the latest version, so I'm moving away from SQL CE. Thanksfully, I can afford to buy a SQL server database from my host.

Anyway, I have downloadable products that my customers have purchased. How do I keep my customer accounts and their associated purchases when I move to the new SQL Server database? Which tables do I need to copy the data from/to?

So far this is what I've done:
1) Setup a new instance of NopCommerce and pointed it to the new SQL Server database.
2) I've walked through all of the settings in the old and new instances and made sure both stores are setup the same
3) I have not re-created any products or product categories; I hope to do this by copy data from the old tables to the new tables.

Thanks for any help you can provide.
-Jason

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

Still have questions or need help?

. Premium support services . Get dedicated support from the nopCommerce team with a guaranteed response within 24 hours.

. Online course for developers . Get the practical and technical skills you need to run and customize nopCommerce websites.