99 votes
SDF File - What is an .sdf file and how do I open it?
Learn about .SDF files and view a list of programs that open them.
Languages
Overview
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: Click "Add connection" in the top-left pane Select "Build data context automatically," choose "LINQ to SQL," and click Next > . Select "SQL CE 4.0 (auto-install)" in the Provider section. 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.
Document Icon
Breadcrumbs
DeveloperMassive Entertainment
Popularity3.4 | 16 Votes
Previous / Next
In-Depth
.SDF File Extension
5 file types use the .sdf file extension.
SQL Server Compact Database File
| Developer | Microsoft |
| Popularity |
3.5 | 99 Votes |
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:
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 . Free Download
Programs that open SDF files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Microsoft SQL Server 2019
Free Trial
Microsoft Visual Studio 2022
Free +
LINQPad
Free
Category: Database Files
Updated: February 11, 2020
Spatial Data Format File
| Developer | Autodesk |
| Popularity |
3.6 | 45 Votes |
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
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Autodesk AutoCAD Map 3D 2022
Free Trial
Autodesk AutoCAD Civil 3D 2023
Free Trial
Safe Software FME Desktop
Free Trial
MapGuide Open Source
Free
Linux
MapGuide Open Source
Free
Category: GIS Files
Updated: August 29, 2016
Structure Data File
| Developer | Symyx Technologies |
| Popularity |
3.6 | 21 Votes |
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 or reference SDF files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Avogadro
Free
NISS PowerMV
Free Trial
OpenEye Scientific VIDA
Free Trial
Advanced Chemistry Development ACD/ChemFolder
—
Discontinued
Paid
CheD
Free
Mac
Avogadro
Free
OpenEye Scientific VIDA
Free Trial
Linux
Avogadro
Free
OpenEye Scientific VIDA
Free Trial
Category: Data Files
Updated: March 21, 2018
Standard Database Format
| Developer | N/A |
| Popularity |
3.4 | 22 Votes |
An SDF file may also be a data file saved in the Standard Database Format (SDF), which stores data in a structured format that consists of values organized into fields of fixed lengths. Various database and data analysis programs can import and export SDF files, making SDF a common format for transferring data between different programs.
More Information
The Standard Database Format is one of several data formats that use the .sdf file extension. Other formats include the Spatial Data Format, SQL Server Compact Database Format, and the Structure Data Format.
While an application can open an SDF file saved in one format, it likely does not support SDF files saved in other formats. For example, the Avogadro molecule editor and visualizer can open SDF files in the Structure Data Format but cannot open SDF files in the Standard Database Format.
How to open an SDF file
You can open SDF files with various programs, including dBase , a database management system that supports many modern database engines.
Programs that open SDF files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
dBase
Free Trial
Category: Data Files
Updated: October 26, 2023
World in Conflict Game Map
| Developer | Massive Entertainment |
| Popularity |
3.4 | 16 Votes |
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 or reference SDF files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Massive Entertainment World in Conflict
Paid
Massive Entertainment WicEd
Free
Category: Game Files
Updated: November 18, 2011