.SDF File Extension
SQL Server Compact Database File
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
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:
Quick Facts
- File Extension
- .sdf
- Developer
- Microsoft
- File Type
- SQL Server Compact Database File
- Last Updated
- 2025-11-02T02:43:26.534Z