Solved

read MDF file

Posted on 2004-10-06
4
12,443 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 52

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
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…

867 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

13 Experts available now in Live!

Get 1:1 Help Now