After running into some issues this morning with an outdated database and the new theme I wanted, I decided it was time to upgrade TexasViking.com to Graffiti 1.2! Here are the steps I took:

1. Backup your site! Or at least the folders that are going to be replaced/updated with 1.2. Also backup your database.
2. Unzip the “Graffiti 1.2.zip” download somewhere.
3. Copy the folders from the “Upgrade 1.1 to 1.2\Web” directory over your existing site root.
4. (And this is the one of my “Gotchas”) Run “Tools\Migration\DataMover.exe”.
   1. Select your existing database (in my case Graffiti.vdb3)
   2. Select your new database (use the Graffiti.vdb3 found in the Migration folder!)
   3. Click “Copy Data”
5. Copy the newly generated Graffiti.vdb3 database into your App_Data folder.
6. (Here is the other “Gotcha”) There’s a line that needs to be added to your web.config.
   1. In your AppSettings node add the following line if it doesn’t already exist:
      <add key="Graffiti:Roles:Everyone" value="gEveryone"/>

That was everything I needed to do to get 1.2 up and running!

The errors:

1. Error 572 (Provider v. 3.4.1.73): Table doesn't exist:  graffiti_RoleCategoryPermissions
   Line #: 1; Column #: 122
   1. This is fixed with Step 4 above.
2. “access-denied” error
   1. This is fixed with step 6 above.

Update:

Our wonderful Graffiti PM Terri has informed me that there was a "ReadMe" doc in the 1.2 download... (doesn't she know some guys don't read install files?? HAHA)

Anyhow, it states to replace your entire web directory (thus including the web.config). I went ahead and did so out of the need to be "correct", and found that there was 1 other config file addition. KUDOS TERRI!