Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 12458
  • Last Modified:

read MDF file

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
czaron
Asked:
czaron
1 Solution
 
mcmonapCommented:
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
 
Julian HansenCommented:
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
 
srinivasukCommented:
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
 
daluuCommented:
How to attach the database using osql, or for the new SQL 2005/2008, using SQL Management Studio and sqlcmd.exe?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now