The Wayback Machine - https://web.archive.org/web/20201103143026/https://github.com/smartstore/SmartStoreNET/issues/1998
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migrate from sql compact to sql express #1998

Open
LoraVi opened this issue Jul 2, 2020 · 2 comments
Open

Migrate from sql compact to sql express #1998

LoraVi opened this issue Jul 2, 2020 · 2 comments
Labels

Comments

@LoraVi
Copy link

@LoraVi LoraVi commented Jul 2, 2020

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
Copy link
Contributor

@mgesing mgesing commented Jul 2, 2020

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.

@mgesing mgesing added the question label Jul 2, 2020
@LoraVi
Copy link
Author

@LoraVi LoraVi commented Jul 3, 2020

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
2 participants
You can’t perform that action at this time.