Solved

read MDF file

Posted on 2004-10-06
4
12,437 Views
Last Modified: 2012-08-13
Hi
I have a MDF file from MSSQL serwer 2000. Is there any possibilty to read data from this file using any free program.
Can PostgreSQL read it??
0
Comment
Question by:czaron
4 Comments
 
LVL 15

Accepted Solution

by:
mcmonap earned 50 total points
ID: 12237415
Hi czaron,

you can download and use MSDE to read an MDF file, MSDE is cut down version of SQL server that has most features but a reduced user capacity, you can get it here: http://www.microsoft.com/sql/msde/downloads/default.asp
0
 
LVL 51

Expert Comment

by:Julian Hansen
ID: 12241250
See PAQ

http://www.experts-exchange.com/Databases/Q_21028889.html?query=msde+julianH+Access&clearTAFilter=true

It discusses this problem quite thoroughly.

Also if you can get hold of a copy of Enterprise Manager with MSDE you can use a simple attach database as an alternative to the MS Access method discussed above
0
 

Expert Comment

by:srinivasuk
ID: 12451527
You can Install MSDE which is a freeware and Use OSQL from DOS prompt to Attach the Database and find available Objects( Tables, Procedures and Triggres etc) also find the Contents of those.
0
 
LVL 4

Expert Comment

by:daluu
ID: 25193898
How to attach the database using osql, or for the new SQL 2005/2008, using SQL Management Studio and sqlcmd.exe?
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Change variables in SQL table 6 66
MySQL 11 67
SQL Insert Query Help, part2 6 42
SQL Database connect change in Access 2015 5 34
Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
This article describes some very basic things about SQL Server filegroups.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now