Home : File Types : SDF File

.SDF File Extension

File Type 1SQL Server Compact Database File

3.9 (78 Votes)
CategoryDatabase Files

What is an SDF file?

An SDF file contains a compact relational database saved in the SQL Server Compact (SQL CE) format, which is developed by Microsoft. It is designed for applications that run on mobile devices and desktops and contains the complete database contents, which may be up to 4GB in size.

More Information

You will most likely only encounter SQL CE SDF files if you are a database architect or developer. 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.

To open an SDF file with LINQPad, follow these steps:

  1. Click "Add connection" in the top-left pane
  2. Select "Build data context automatically," choose "LINQ to SQL," and click Next >.
  3. Select "SQL CE 4.0 (auto-install)" in the Provider section.
  4. Click "Attach database file" in the Database section, click "Browse," and choose the SDF file.

NOTE: Previous versions of SQL Server Compact were distributed as SQL Server for Windows CE and SQL Server Mobile Edition.

Open over 400 file formats with File Viewer Plus.

Programs that open SDF files

Updated 2/11/2020

File Type 2Spatial Data Format File

3.7 (43 Votes)
CategoryGIS Files

.SDF File Association 2

Geodatabase format used to store infrastructural and geospatial data; supports multiple feature classes, which may each contain multiple geometric properties; optimized for large datasets of spatial information.

More Information

The SDF format was developed by Autodesk and is used by several Autodesk programs, including Autodesk MapGuide Enterprise and AutoCAD Map 3D.

Programs that open SDF files

Updated 8/29/2016

File Type 3Standard Data File

3.6 (19 Votes)
CategoryData Files

.SDF File Association 3

Standard database format used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.

Programs that open SDF files

Free Trial
Updated 11/4/2016

File Type 4Structure Data File

DeveloperSymyx Technologies
3.5 (17 Votes)
CategoryData Files

.SDF File Association 4

Chemical data file created in the Structure Data File (SDF) format, which was developed by Molecular Design Limited (MDL); saved in plain text and contains chemical structure records; used as a standard exchange format for chemicals information.

More Information

Molecular Design Limited was renamed to MDL Information Systems and then later was acquired by Symyx Technologies, the organization that now maintains the SDF format.

Programs that open SDF files

Updated 3/21/2018

File Type 5World in Conflict Game Map

DeveloperMassive Entertainment
3.5 (14 Votes)
CategoryGame Files

.SDF File Association 5

Map file used by World in Conflict, a real-time tactics war simulation game; stores the terrain, spawn points, item locations, and other map details; used for multiplayer gameplay.

More Information

Custom maps can be created using WicEd, the World in Conflict map editor.

Programs that open SDF files

Updated 11/18/2011

About SDF Files

Our goal is to help you understand what a file with a *.sdf suffix is and how to open it.

All file types, file format descriptions, and software programs listed on this page have been individually researched and verified by the FileInfo team. We strive for 100% accuracy and only publish information about file formats that we have tested and validated.

If you would like to suggest any additions or updates to this page, please let us know.