[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

read MDF file

Posted on 2004-10-06
4
Medium Priority
?
12,458 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 200 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 61

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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

612 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