Unable to import database

Hello we try to import the database…

A error show up… see pic.

Please advise what to do.

You are running SQL server and trying to import a CE database. You can’t import a CE database intol SQL. CE is horrible as well you would not want tok use CE. Additionally it’s not good idea to use prebuilt databases.

We created a .zip file from the database on the old laptop… now i would like to restore the database on a new laptop. No idea what you mean with CE database - could you explain what the problem is.

The SDF file is from SQL Compact Edition (CE). It is not compatible with SQL Server Express which uses MDF/LDF files.

You need to create a new DB in SQL Express (MDF) and convert data from CE (SDF) to use it in SQL Express (MDF).

1 Like