I was hoping to be able to open .mdf file. I am using WebMatrix, I can view the queries there. I can read the schema too. But how can I read the file without using WebMatrix. Its SQL Server file not the Comptact edition.
I have searched for web help (Through windows). But all in vain. I will prefer any link or any method to read the basic queries.
.sdf is, in fact, a Compact Database file (unless you've changed the extension which would be problematic). SQL Server would be
SQL Server (
You can attach the database to your local SQLEXPRESS instance and view it. An example of attaching it can be found on msdn: How to: attach a Database File to SQL Server Express. Essentially you're calling:
USE [master] GO CREATE DATABASE [database_name] ON ( FILENAME = N'C:\Path\To\<database name>.mdf' ), ( FILENAME = N'C:\Path\To\<database name>.ldf' ) FOR ATTACH ; GO
SQL Compact Edition (
The best tool I've found to open them is CompactView.
SysTools SQL MDF Viewer can be used to view the table contents. I tried with the free trial version.