Open, delete, and use SQL server express. sdf (SQL Server Compact Edition Database File) files

Source: Internet
Author: User
Tags compact microsoft sql server management studio sql management studio sql server express visual studio 2010

First, we need to know what. sdf is? The sdf File is a localized Database File in Visual Studio 2010: SQL Server Compact Edition Database File. It has been verified that this file is saved as a database file by project information. If you have not participated in a large team project and do not involve a deep debugging process, this file is useless to you, you can safely delete the file. If you need it again later, it's easy to open the file in the project. the link for re-compiling the sln file is OK.

Official notes:

File Type 1: SQL Server Compact Database File

File description:

Compact relational database developed by Microsoft, also known the SQL Server Compact (SQL CE) format; designed for applications that run on mobile devices and have tops; contains the complete database contents and can be up to 4 GB in size.

NOTE:

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


Note:

The file format can be opened under vs2010 and vs2012. Vs2013 cannot be opened.

To enable it, install:

Microsoft SQL Server Compact

Flyhoward SDF Viewer


Browsing in vs2013 requires: CompactView or l SQL Server Compact Toolbox extension

Or install SQL management Studio 2008.


If you do not need this file, simply delete it.

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.