FMS SQL 2005-2008 without migration tool
Our Finance server became flakey the other day and I hadn't done the FMS SQL 2008 migration as yet, I decided to migrate the db over to our sims server and get rid of the accounts server all togeather(its just a powerful workstation with win2k3 installed). Before I managed to carry out the migration the server became unbootable.
Anyway... I have a full backup of the FMS db, when restoring it to our sql 2k5 instance the sysman username won't work so I've restored it directly to our SQL 2k8 instance and it appears to be working(I can logon and view various bits without error) - I noticed that the Sims migration util just detatched and reattatched the db along with doing a few file updates. Is the FMS one the same?