Help please with FMS SQL2008 Migration
Hope someone can help me with an FMS SQL 2005/08migration.
Server 1 = Currently hosting FMS 6.132 (only FMS module as we use Facility as our MIS) server 2003 / Sql 2005 (full version)
Server 2 = New server running Server 2008R2 & full version of SQL 2008
Firstly Solus has never worked properly for us so we get our updates via the Capita helpdesk - we did not have the migration tool, so had to contact Capita to get these - they are not happy we have left it so late as the official migration support has ended ...
If I run the migration tool on Server 1, it does not "see" server 2. the destination server is blank - Capita says
that I need to run the migration tool on server 2. So I copy the FMS database onto server 2, run the migration tool, I can select my file,
"see" the SQL 2008 server (I am able to connect either with windows or sql authentication) but when I click "next" to start the conversion I get
the following error :-
FMS SQL2008 Migration - Unable to get the registry keys for SQLBinnRoot or SQLData from the registry - please seek advice.
Any ideas as to how I can proceed ? In order to get the FMS databases trasferred should any
settings / software be loaded onto the SQL2008 server ?
Any help much appreciated (before I go tinkering with the registry...)