Migrating Content Databases from RTM to SP1

We did a migration, copying a content database from an RTM farm with a SQL 2000 back end in North America to an SP1 farm (no infrastructure update) with a SQL 2005 back end in Europe (and another in Asia) in order to give a starting point for replication (using a certain major replication software).

It was easy. We restored a backup of to the new database server. It's now a SQL 2005 database. If you try to simply attach this database to the SP1 farm in the Central Admin GUI, when you browse to it you will get an error with a useless link to a Microsoft site (that's what we got). 

To make it work, with the database not attached, we ran:

Stsadm.exe -o addcontentdb -url -databasename

If you want to check the database version, you can run:

SELECT * FROM Versions

There is a nice table of the database versions here http://blogs.msdn.com/shaden/archive/2008/01/10/migrated-to-sp1-checking-your-database-schema-version.aspx. You are looking for 12.0.0.4518 for RTM, 12.0.0.6219 for SP1. You can see the rest of the database versions in the post linked above.

Where's my Easy button? I hope this is really as good as it looks.