1

I have created a C# application that connects to a Microsoft SQL Server Express Edition (64-bit) database. However, I want to transition the project from SQL Server to a local database and convert the .mdf file to a .sdf file.

The best solution I have found is SQL Server Compact Toolbox written by ErikEJ also pointed out by this post. When attempting to install the add-in to Visual Studio I receive an error:

This extension is not installable on any currently installed products.

even though the installer recognizes that Microsoft Visual Studio Express 2012 for Windows Desktop is installed. I believe this is only targeted for Professional and above.

I have also attempted to use the standalone tool. However, the option I want is grayed out and it's for version 3.5 instead of the current version 4.0.

enter image description here

I have also looked at trying to export/convert from Microsoft SQL Server Management Studio 11.0.3128.0. However, I have had no luck.

Is there a solution for VS Express Edition, or am I out of luck?

Community
  • 1
  • 1
Harrison
  • 3,843
  • 7
  • 22
  • 49

1 Answers1

2

Just use the standalone edition for SQL Server Compact 4.0, available here: https://sqlcetoolbox.codeplex.com/releases/view/104096

ErikEJ
  • 40,951
  • 5
  • 75
  • 115