web hosting database issue

Discussion in 'Databases' started by emjsync, Feb 25, 2006.

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

    emjsync

    I will be hosting my website in a couple of days, but I have some database issues that I would like to resolve.

    a. Can I move my database from msde 2000 to the web hosting site

    b. Do i have to rename my database to the DiscountASP.net defaut database assigned to me during the sql 2000 setup
    i.e. my database name is cteSurvey
    i.e. discountASP.net database name is DB_12322_cteSurvey.


    any help is appreciated
     
    emjsync, Feb 25, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    a. yes. msde is compatible w/ ms sql 200. you should be able to move the database to our sql server

    b. no. you do not have to rename the database. all you want is to move the data to the remote server. The easiest way is to move the databse using SQL import / export wizard.

    If you intend to develop in sql, i recommend you upgrade to SQL Developer version. It's pretty reasonablely priced (~$50) and you get all the tools.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Feb 28, 2006
    #2
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