We've been running outlook 2007 with BCM successfully for several years but recently hit the 4Gb SQL express database limit. We've purchased Office 2010 and installed BCM 2010 and then installed the 'BCM 2010 database tool' to migrate the database.
Every time we run the migration wizard in the database tool it successfully creates the backup of the database during the first stage but then fails the actual migration simply stating "migration failed". (The installation and migration have been run on the administrators account - which created the original 2007 BCM and shared it)
Have also tried backing up the 2007 BCM to restoring it to the 2010 BCM. There is plenty of hard drive space available to complete the operation.