search

smartstore / Smartstore

A modular, scalable and ultra-fast open-source all-in-one eCommerce platform built on ASP.NET Core 7
http://www.smartstore.com/
GNU Affero General Public License v3.0
1.15k stars 426 forks source link

Migrate from sql compact to sql express #289

Open LoraVi opened 4 years ago

LoraVi commented 4 years ago

Hi there, we were using sql compact but it turned out import/export doesn't work with it. so now we have 3 shops full with products that should be migrated to sql express. what should we do?

mgesing commented 4 years ago

What comes to my mind spontaneously are two possibilities. One is to use a specialized tool, like this one. Or try to copy the data manually from one database to the other (by script, CSV etc.). With this tool you can open Compact databases in Visual Studio. It also has a command "Script database", even "Script data for SQL Server" but I've never tried this.

As far as I know Microsoft no longer supports opening Compact databases in SQL Server Management Studio.

LoraVi commented 4 years ago

Hi Marcus, after various trials we managed to migrate manually to sql express. Now there’re 2 issues:

  1. whatever we do we can’t upgrade to 4.0.0 version, we get this error message:

  2. the migrated shop works on safari, but not on chrome. on chrome we get this message:

Any suggestions? thanks a lot! kind regards Lora