Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Compact 4.0 can't open/read sdf file

Tags:

People also ask

How do I view an SDF file?

You can open an SDF file with several programs, including Microsoft Visual Studio and LINQPad. To open an SDF file with Visual Studio, select View → Server Explorer → Data Connections → Add Connection..., change the data source to "Microsoft SQL Server Compact," click Browse..., and select the SDF file.

How do I convert a SDF file to CSV?

Replace database. sdf with the path to the database you want to convert. The file output. zip will contain a CSV file, one for each table in the given database file.

What is a SDF file extension?

The Spatial Data File (SDF) is a single-user geodatabase file format developed by Autodesk. The file format is the native spatial data storage format for Autodesk GIS programs MapGuide and AutoCAD Map 3D.


I've installed SQL Compact 4.0 CTP 2 via WPI and used NUPack to add SQLCE.EntityFramework in my project. It compiles and run perfectly but I can't open the SDF file in Visual Studio 2010's Server Explorer.

When I try I always receive the following message:


Microsoft Visual Studio

This is not a valid SQL Server Compact Database file or this file version is not supported by current SQL Server Compact Engine.

OK

I've already tried to uninstall and reinstall everything.

It cannot be opened in SQL Server 2008 R2 Management Studio also.

Please help!!