I know that it's been a while since I first posted about our migration from .Text to Subtext, but I now I'm actually getting down to it. The recipe is as follows:
- 1 Install of .Text 0.92
- SQL Server 2005
- 1 Zip of SubText 1.5.2
- 1 Zip of SubText 1.9.5b
- 1 IIS Server
- A desire to upgrade to a new blog platform
Once you have all your ingredients gathered, it's time to start the upgrade! The first step in any preparation is to prepare the environment. To do this, we first backed up our .Text database and created a new one to hold our new SubText install. Next, we did the same backup to all the files in the web root directory.
The hard part is going to be upgrading the database. The reason why we listed both versions of SubText in this ingredient list is because we first have to upgrade the database to 1.5.2 and THEN move it to 1.9.5b. Supposedly, there is an importer in 1.9.5b that works, but we were never able to get it working. To solve this, what I did was installed SubText 1.5.2 (which didn't have the upgrade script built in) and then I upgraded the rest of the way to 1.9.2. Once the files are installed and IIS is configured, it's time to upgrade the database. To do the database upgrade, I recommend downloading this script from this blog, opening up your SQL Manager, pasting the script in the query builder and executing some Ctrl-Shift-M Fu on it. A quick entering of credentials later, and you can run the query to update your database. Once you have your .Text migrated to SubText 1.5.2, it's easy to then update to the most recent release of 1.9.5b.
I don't want to actually host the upgrade script here, since it is the work of the fine folks of another blog, but I do want to stress that this is what worked for us. I'm sure that there are people out there who might be reading this and scoff at such a simplistic approach, but hey, it worked for us.
There were still a few more things that we had to do to make everything work right, but I think that's fodder for another post.