Migrate SQL Server Express Edition to SQL Server 2005

Discussion in 'Databases' started by michaelw22, Jun 6, 2006.

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

    michaelw22

    I am running Visual Web Developer 2005 and SQL Express Express Edition. My SQL Express database is populated with records.

    I intend to purchase SQL Server 2005 hosting with DiscountASP.NET.
    What steps should I take to migrate my database from my local machine to DiscoutASP.NET servers?

    thanks.
     
    michaelw22, Jun 6, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Bruce, Jun 6, 2006
    #2
  3. jonny_s

    jonny_s

    Likewise I am running VWD 2005 using SQL Express 2005 database to develop my site. I have just purchased SQL server 05 hosting with discountASP.NET in order to start testing the site on the web.


    I have used the new SQL management tool to attach my SQL 2k5 Express .mdf file but am having trouble getting it to work. Ihave tried alteringthe connection string in the web config file using the sample connection stringon the discountASP.NET databasemanagement pagesbut as yet have been unsuccesful.


    My attached SQLExpress database lies in the folder \App_Data\dev_base.mdf


    Can anyone advise me how to do this?


    thanks.
     
    jonny_s, Jun 14, 2006
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    i am confused!!

    are you having problem attaching the database or are you having problem getting your application to talk to the SQL2k5 DB?

    please provide more details!!

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 14, 2006
    #4
  5. jonny_s

    jonny_s

    the latter Ithink ... the SQL management tool says that I have attached my database file succesfully


    I therefore wonder if I need to ammend the connection string in the web config file


    cheers
     
    jonny_s, Jun 15, 2006
    #5
  6. Bruce

    Bruce DiscountASP.NET Staff

    yes, most definitely.

    You'll have to modify your connection string in either the web.config or your application to point to the SQL 2005 server hosted on our server.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 15, 2006
    #6
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