.SDF File Extension

SQL Server Compact Database File

Developer: Microsoft

Learn about .SDF files and view a list of programs that open them.

What is a .sdf file?

Learn about .SDF files and view a list of programs that open them.

Properties

Related Formats
3d3d23dm3ds3ds-to-dae3ds-to-dwg3ds-to-fbx3ds-to-glb3ds-to-gltf3ds-to-obj3ds-to-pdf3ds-to-ply3ds-to-stl3ds-to-usdz3mf3mf-to-3ds3mf-to-dae3mf-to-glb3mf-to-html3mf-to-obj

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.

Technical Details

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.

How to open .sdf files

To open a .sdf file, you need compatible software that supports this file format.

Programs that open .sdf files:

Windows
Open over 400 file formats with File Viewer Plus.Free Download
Microsoft SQL Server 2019
Microsoft Visual Studio 2022
Safe Software FME Desktop
Avogadro
NISS PowerMV
dBase

Quick Facts

File Extension
.sdf
Developer
Microsoft
File Type
SQL Server Compact Database File
Last Updated
2025-11-02T02:43:26.534Z

Related File Types