.sdf?

  • Thread starter Thread starter Elmo Watson
  • Start date Start date
E

Elmo Watson

I just tried something in VS.Net 2008 that gave me a little surprise (using
SQL Server 2005)

I've had previous 2005 projects, in which I've added a new database to the
project, and it gave me a .mdf file,
However, my surprise came when I got
MyDatabaseName.sdf

I'm assuming it can be used, just like the .mdf files before - - I'm just
curious as to what new features this gives me, etc
What's up with this?
 
*.sdf is the data file of SQL Server CE (Compact Edition).
*.mdf (along with *.ldf) is the data file of SQL Server/Express.

No, you cannot use *.mdf the same way as *.sdf. SQL Server CE is file based
database engine, aimed for single user use (can also be used by multiple
users, though). You cannot use *.mdf file directly. It can only be used by
SQL Server/Express exclusively.
 
Back
Top