I've recently been trying to save space on my machine and started using TreeSize to analyse folder structures / sizes
This led me to the discovery that a lot of my Visual Studio projects have SDF files inside them. In one case, an app folder is 80Mb, 50Mb of which is this SDF file. This app doesn't use SQL Server Compact (although it has a SQLite database). The SDF file doesn't appear in the project files in Visual Studio.
Where do these files come from, and are they safe to remove?
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.
Right click on No SQL Compact Data Connections Found and select Add SQL Server Compact 4.0 Connection… A small window will pop up where you will enter your desired password. After your password has been entered, click Create at the top of the window where you will you will name your new .
sdf”, “SD File”, or just an “SDF” • SD Files have an “. sdf” file extension SD Files encode chemical structure data using the molfile connection table format. This format depicts chemical structures using a block of text that lists the atoms, bonds, connectivity, and coordinates.
Found an answer here: Why does the Visual Studio conversion wizard 2010 create a massive SDF database file?
It turns out this is the code browser database, and I can delete it
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With