is it possible to open mdf file in sql 2008

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RomeoX
    New Member
    • Jan 2010
    • 25

    is it possible to open mdf file in sql 2008

    hi everyone here, hope u r doing well


    My question that I want to make a page in ASP.Net based on database and I'm a newbie, recently I have got a complete project that one of my friend gave it to me, made in ASP.Net plus SQL Server. I want to add pages and some code in that and I want to start it in my local server in Win 7 ultimate for a test. I saw the mdf DB file in APP_DATA folder and I want to open for editing and add tables and change the data inside. So how can I open MDF file was made in SQL 2005 Express to open it in MS SQL 2008 Developer Ed?

    By the way, When I open the file under Database node and choose attach and add the file and click ok I get this msg

    Code:
    "an error occurrred when attaching the database. click the hyperlink in the message column for details"
    Also when I open the file in MS Visual studio 2008 pro and point to the file mdf and click on it I get this msg

    Code:
    "Required components missing
    connections to SQL Server files (*.mdf) require SQL server express 2005 to function properly. Please verify the installation of the component or download from the url: http://go.microsoft.com/fwlink/?linkid= 94251"
    Please tell me how can I open it.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    I found this somewhere...

    Good Luck!!!

    ~~ CK

    Comment

    Working...