Visual Web Developer 2008 Express DB to SQL Server 2005

Discussion in 'Databases' started by Himself, Nov 26, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I'm developing sites with Visual Web Developer 2008 Express Edition 2008 and they are now running online with SQL Server 2005. If I update entries in the offline database, can I then upload ASPNETDB.MDF and aspnetdb_log.ldf, overwriting the equivalent online files? Will everything work okay or do I have to do something else?

    Thanks.
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    You will need to detach the database, upload the mdf file (we don't need the ldf) to your site then use the SQL attach tool to attach the database.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. I found the FAQ on SQL 2005 Management Tools (Q10431) on detaching, uploading and attaching. As mentioned, I am using Visual Web Developer 2008 Express Edition which, I assume, uses SQL 2008 Express. However, the online version of the database is SQL 2005. Should I use Microsoft's SQL 2005 Management Studio to do the detach? After uploading, is the attach done via the tool at DASP? As you might guess, this is all new to me. BTW, someone else set this up for me originally. Can you send me a reminder as to the password for the database which appears to be required? How do I request this?

    Thanks.
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    detach it using SQL management Studio 2005 if the db is SQL2k5. Use the database management in the hosting control panel.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  5. Can this be done with the Management Studio 2005 Express Edition?

    Thanks for your ongoing help.
     
  6. Bruce

    Bruce DiscountASP.NET Staff

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page