Murphee K dot com | MPK Adventures | Updated when possible |

Where rainchecks are legal tender


10/14/2007

Where I've been (hiding) | ep.27 

Filed under: Site News , Comic @ 5:30:22 PM
I actually haven't been playing Guitar Hero, which makes today's comic a four-panel lie-a-thon.  What this comic really is is a way into telling you about the recent backend upgrade to this website.  This is about to turn extremely geeky (if it weren't already), but summarily, this site has now been upgraded from MS Access to MS SQL Server 2005.  And not only that, it's using Godaddy's SQL Server backend.

I certainly haven't seen any guides on the Internets on how to do this, so I'm hoping that people doing a search would benefit from my experience.  Here are some of the things that I've done to do this:
1) Downloaded a local copy of SQL Server 2005 Express and converted my MS Access database to SQL Server automatically.
It's always a good idea to test locally, so I wanted to convert my DB into a local instance of SQL Server.  This article helped me tremendously.  The author even put out a Word document which tells step-by-step how to migrate an MS Access DB into SQL Server.  Pretty cool!  Essentially, after this step, I was able to update my connection string to point to my local instance of SQL Server.

Also, I had to re-check my code once I've migrated to SQL Server.  I've had some issues regarding the datetime type that I had to fix.
2) Exported my local instance of SQL Server into a CSV file.
There are many ways of deploying a SQL Server instance, but unfortunately Godaddy stipulated that I can only import my DB via a CSV file.  Lame!  So this meant that I had to find out how to first export my DB into a comma-separated text file, and then use Godaddy's importer to deploy my database.

I think the easiest way of exporting a SQL Server instance into a CSV file is via SSIS, but I haven't been able to do that because what I had was SQL Server Express.  Doubly lame!  I felt pretty stuck for a while until I found several shareware apps online that would do it automatically.  The one that I downloaded was pretty crappy as it would only export half the rows in a table at a time, so I don't recommend it.  But I'm pretty sure that you can find one that's better.
3) Created tables in Godaddy's SQL Server and then imported my CSV files into Godaddy.
This is pretty straightforward:  while creating tables in Godaddy's SQL Server, I made sure that I had my local instance open so that I knew which type to give to each column.  There's one BIG gotcha that I had to call customer service for:  in order to set a column as nvarchar(MAX) in Godaddy, I had to set the column as nvarchar with length of -1.  THIS IS A BUG THAT GODADDY'S CUSTOMER SERVICE SHOULD NEVER EVER HAVE HAD TO ADDRESS.  I initially felt angry at the support guy since he totally did not know what I was talking about, but then I felt really bad for him later on because this is essentially a programmer error.  What's worse is that this is an easy fix.  ANYWAY.  Once I imported my tables into Godaddy, all I had to do was...
4) Update my connection strings to point to Godaddy, upload my files with the updated connection strings, and then did a small victory dance.
This is easy because Godaddy provided me with the proper connection strings.

So far, I've tested the backend by putting out a Project Wonderful campaign for a short period of time, and it hasn't gone down since.

Attributions:  the background pics in panel 1 were taken by Addictive Picasso and Yeah Im Kenny.  The background pics in panel 2 were taken by Dominic's pics and irina slutsky.  The background pics in panels 3 and 4 were taken by Okaggi and ricardo.martins, respectively.  I've been listening to a lot of Select Start, so I made them a shirt that exists only in my mind.  Also, Dirt Bike Annie still exists in my mind, so I used a shirt of theirs as well.

Embed

Embed this comic into your website:

...or into a forum:

4 Comments | I'll comment!

MadCalicoJess, representin' Da 'Ville,

on Monday, October 15, 2007 at 12:05 said:
You are key-wretched, that was extremely geekly.

GP(MPK), representin' the dead pixels,

on Monday, October 15, 2007 at 16:15 said:
Geekly is better than silence, Terrence?

Bob, representin' C#,

on Saturday, May 16, 2009 at 12:30 said:
Thanks for the godaddy nvarmax info. You definitely saved me a couple of hours of searching.

That epitomizes some of the problems that I have with godaddy. It makes it nearly impossible sometimes to know if I screwed up, or if it's godaddy that screwed up.

GP(MPK), representin' DLINQ for now,

on Saturday, May 16, 2009 at 20:43 said:
Hey Bob, no problem. Yeah, godaddy's not bad (for the price), but I do feel limited when trying to do complex things. Ah well.

Trackbacks

Trackback URL:

Enter your comments here!

Name*:
Representin'*: (e.g., FL, TX, or whatever you'd be "representin'")
E-mail: (email will not be displayed)
Website:

Bold Italic Underline
Comments*:
(max. 1000 characters)
Character Count: