Local SQLEXPRESS Database to DiscountASP SQL Database???

Discussion in 'Databases' started by objectinvent, May 9, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am new to SQL and I am running MS VS Web Dev 05 w/SQLEQPRESS 05.

    Locally - My web app. is running great. I just need some help on deploying it to (discountASP) sever.

    for example: my local database is currently in the 'App_Data' folder, while the database on the (discountASP) server is in the 'database' folder.

    Any help would be greatly appreciated, maybe just a rough outline of a step by step - anything - or references, links?

    Thanks
     
  2. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    SQL express is not supported on our webservers. You would need to add the SQL 2005 addon.

    Eric
    DiscountASP.NET
    http://www.DiscountASP.NET
     
  3. I have already added SQL 2005. I just need to migrate from local to DASP.
     
  4. If your schemais the same, you should be able to just change the connection string.







    Joel Thoms
    DiscountASP.NET
    http://www.DiscountASP.NET
     
  5. Thank you
     
  6. Update

    My SQL 2005 db is set up and ready to go the on DASP server.
    I am running Visual Web Developer 2005 and SQL Express.

    I have a a simple asp.net app. that will log customers info into my db.
    It runs perfect on my machine.

    Now
    I have also downloaded the SQL Server Managment Studio Express.
    I have created the new table in my DB I need on the DASP server.

    I also created a db and table - all with the same names (as on the DASP server) on my local server.
    My db and table are empty. Its going to be used to log user info on my site.
    Now my guess would be that I only need to modify the conn. string before I deploy?

    Please help
     
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