GoDaddy Shared Hosting and CS2008

rated by 0 users
This post has 2 Replies | 1 Follower

Top 10 Contributor
Posts 51
Andrew Belon Posted: Mon, Oct 13 2008 9:33 PM

Has anyony had any issues upgrading to the latest build of CS2008 within the GoDaddy shared hosting environment?

Curious, because I had a bit of trouble recently.

Top 10 Contributor
Posts 51

A new version is out (cs2008.5 SP1), so I guess I'll  be spending the post holiday fiasco attempting another upgrade.  I think I have a better grasp with the concept, so I do not expect much of an issue. 

Top 10 Contributor
Posts 51

Well, I didn't wait for the holiday to upgrade to SP1 and my impatience led to about 12hours of site maintenance.  I could have fixed it faster, but I was overtaken by sleep, then daily responsibilities. 

Again, the Database Publishing Wizard proved to be a nuisance, since it does not deploy the scripts in the proper order.  This led to errors pertaining to missing dependencies and invalid columns.  Also, what really irks me is that once you get an error, the process, which can take one to two hours, suddenly ends.  I spent a few hours trying to come up with a method to script and deploy without error, so this is what I came up with:

  • Do not script the entire database at once...it is a waste of time.  Deselect "Script all objects in the entire database" and do it piecemeal.
  • Script the Object Types in the following order:
    1. Database roles + Users + Views
    2. Stored Procedures ( with the exeption of "dbo.cs_Favorites_GetUsersWatching")
    3. User Defined Functions + Stored Procedure: dbo.cs_Favorites_GetUsersWatching
    4. Tables

For me, the above method proved to be succesful.  It may not be the same for all, but worth sharing. 

Page 1 of 1 (3 items) | RSS