czaron
asked on
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??
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??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
How to attach the database using osql, or for the new SQL 2005/2008, using SQL Management Studio and sqlcmd.exe?
https://www.experts-exchange.com/questions/21028889/convert-mdf-ldf-files-to-another-format-mdb-csv-etc.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