Move site to another host? RRS feed

  • Question

  • User-680927624 posted

    How do you move a Club site from one host (godaddy) to another? I tried the following and get an error when I go to the site:

    • Set up new sql database on new host with new user name/pw 
    • Backup sql database from current site
    • Use restore funtion on new host to restore the db to the new host (visually checked the table to confirm)
    • Change connection string to new host's settings
    • upload all files to new host

    Is there anything else I need to do? I get an ASP error page saying "Invalid object name 'Announcements'."



    Monday, December 10, 2007 12:14 PM

All replies

  • User2069888697 posted

    Did you check to see who the table owner was.

    I believe that error is common if the table owner is something other then DBO in the actual site code.  It has been a long time but I believe with GoDaddy when you ran the Club-add.sql it gave your database username as the Table owner.  If this is the case find out who the table owner is on the new site and then do a find and replace on the site.

    Monday, December 10, 2007 2:00 PM
  • User-680927624 posted

    I created a new sql login that matched my godaddy sql login and everything works now. The clubsite is now running a happily on a server that is not godaddy! [cool]

    Monday, December 10, 2007 4:38 PM