Saturday, October 16, 2010

Development Tools

I'm setting up a new development environment, and I thought I'd share the list of tools and technologies I'm putting into place there.  Please add any you'd recommend in the comments.  Everything here is free except the OS, SmartSVN, and RedGate SQL Source Control.
 
Operating System:   Windows Server 2008 R2 x64 ($$)
Application Server:  IIS 7 with .Net 4.0
Database Server:  SQL Server 2008 Developer Edition R2 x64 ($35)
(yes, that's right - Microsoft has a fully-featured version of SQL server for development that is dirt cheap)

Installation Tools used:
  • Web Platform Installer - tool to help install IIS, .Net, MVC, and other components
  • NuPack - helps to add extra assemblies / web.config merges, etc. for third party DLLs for your project

Thursday, October 14, 2010

Migrating Umbraco from MySQL to MSSQL

So you've been running the Umbraco CMS for a while on MySQL, but you've been told you need to move it to Microsoft SQL Server. Does it sound intimidating? It doesn't have to be. With the SQL script and instructions in this post, it's not too bad. First, let's start with an overview of the process.

Overview:
1. Use the Umbraco installer scripts to create blank Umbraco tables on your SQL server
2. Set up a linked database in SQL Server to your MySQL database
3. Migrate the data (using my script below)
4. Update your web.config to point to the new database