MIS Systems Thread, SIMS - SQL2005 > SQL2008 Migration Problem in Technical; I'm doing a dummy run of migrating our current SIMS server (setup by Capita) to a new 2008 SQL virtual ...
19th March 2010, 12:23 PM #1
SIMS - SQL2005 > SQL2008 Migration Problem
I'm doing a dummy run of migrating our current SIMS server (setup by Capita) to a new 2008 SQL virtual server.
Right I have all the new systems setup exactly how I want it so time now to migrate the database, this is where the fun begins.
Trying to use the SIMS SQL2008 Migration tool but I'm facing an error which Capita basically won't help me with unless I pay them lots of money....don't we already? Anyway the error I'm receiving when using the GUI version trying to save the updated database to a file so I can migrate it to the new server.
"SQL Binn folder is missing or inaccessible - Please seek advice"
"Unable to get registry keys for SQLBinRoot or SQLData from registry - Please seek advice"
(the please seek advice bit should be replaced with pay Capita lots of money)
Anyway Capita wont help me with this, do any of you guys know where I might locate the registry keys it missing, I've had a good poke about but can't see anything. I then tried using there command line tool which seem better, in the fact I could establish a direct connection to the new server but I then get the following error about moving the database:
18/03/2010 10:24:49 Info Migration Started on SERVER01 by admin1
18/03/2010 10:24:49 Info Command Line Parameters --Silent --Advanced --sInstance Server01\SIMS2005 --sSQLUser SA --sSQLPwd ********** --sDatabase SIMS --dInstance SQL01\SQL01 --dSQLUser MD --dSQLPwd ********** --dDatabase SIMS --DMSPath E:\DocStorage
Detach SIMS Database Server01\SIMS2005 | sims
Copy Database Files From to
Attach SIMS Database SQL01\SQL01 | SIMS
Install SIMS Server Applications
Configure SIMS Database
Move SIMS Scheduled Tasks Server01\SIMS2005 | sims
Set Recovery Model
18/03/2010 10:24:51 Info START: Detach SIMS Database
18/03/2010 10:24:51 Info SUCCEED: Detach SIMS Database
18/03/2010 10:24:51 Info START: Copy Database Files
18/03/2010 10:24:51 ***STOP*** FAIL: Copy Database Files
18/03/2010 10:24:51 Info START: RollBack System
18/03/2010 10:24:54 Info SUCCEED: RollBack System
18/03/2010 10:24:54 Info Migration Finished
I wonder if the same registry key is missing so it can't find the SQLData folder to move the files!
19th March 2010, 12:27 PM #2
Your not trying to copy it the database across the network to another server?!?
19th March 2010, 12:38 PM #3
This is the next plan, setup another server move 'SIMS' to that then run the migraton to SQL2008 on that server.
19th March 2010, 01:02 PM #4
Basically the error is because your moving the database from Server01 to SQL01. You can't do it.
It isn't Capita, it's Microsoft. SQL stuff has to be on local disc.
Either migrate SQL on the same server, or deattach the database, copy it to the new server, install SIMS, run the SQL2008 migration, tick the advance button, and select the mdf.
I think Capita are a bit worried about you doing it on your own which is why they keep saying, call us out etc. I mean they recommend a named instance of SIMS2008, you've got SQL01. A pretty school boy error (no offence meant).
21st March 2010, 01:54 PM #5
surely you can name the instance what you like...?
i'd prefer sql2008, and then name the database sims2008.
i'm fed up of the confusion of the instance and db name being the same, even Capita guys i've spoken to said the same.
i've not played with the migration yet, but are you saying that there's no way to do a clean setup with sql 2008? so, it has to be a migration from 2005-2008? i hate having old remnants.
21st March 2010, 02:21 PM #6
The idea of using the default is from the support aspect. You may know that sql1 is for sims, but what happens if you aren't in, or god for bid, you get ran over by a bus. Anyway the database should be called sims, the sql instance should have purpose and version. I can't see any reason why you shouldn't use sims2008 as the named instance.
You can indeed setup a new server, you just have to copy the files like you normally would. Don't try and use the sql migration tool to transfer the data.
22nd March 2010, 09:20 AM #7
just to thow a spanner in the works, i've had this error when tring to export by database to a flat file using the advanced options box.
A why oh why wont SIMS support a tool that they provided!
22nd March 2010, 09:29 AM #8
If your trying to do a clean install. Ask for the latest installable media, install it onto the new server. Then deattach the database(s) from the old server, copy them to the local drive of the new server, run the SQL migration tool on the new server, select the advanced option, select the deattached mdf(s).
22nd March 2010, 12:57 PM #9
I agree with fawkers here as the instant name should only really be needed to separate the services, registry etc but anyway I have changed this to SIMS2008 in the hope that helps.
So I then tried the way you suggested by detaching the original database, moving to the new server and then running the migration tool. All looked good until I reached this message next hurdle.
The server is SQL01\SIMS2008 (Win 2008 x64) tried R2 and non R2 just to confirm. Configured XP_CMDShell and enabled name pipes. 100% running as Admin (UAC disabled).
22nd March 2010, 01:05 PM #10
When you run the sql2008 migration tool, r-click and select "Run as Administrator" see if that makes any difference.
RegCreateKeyEx - Vista Forums
Looks like a Microsoft security thing....
Also been asked, is the service running a local service or a network service? It should be a local service.
Last edited by matt40k; 22nd March 2010 at 01:11 PM.
Thanks to matt40k from:
benIT (17th January 2011)
23rd March 2010, 11:46 AM #11
That problem was caused by my services running under a domain account, switched to local service solved that problem thanks!!
I think I'm at the last hurdle now however it’s now not accepting the backup location. If I leave it default or even set it to something simple like D:\backup (folder exists) nothing. Commanded or via the GUI. I'm really not worried about setting that location now I can do it later but it just will not accept it!
23rd March 2010, 11:48 AM #12
To be fair they are a company that needs to make 'more' money but yes I do feel your frustration.
Originally Posted by fawkers
23rd March 2010, 12:14 PM #13
I know they need to make money but how many £1000's does each school spend each year with them?
As an update on what were doing about this problem, it's now Capitas problem, the NM decided that we shouldn't take the risk of playing around with SIMS\FMS when it could all go so horibly wrong. (i'm 99.9% sure we wouldn't screw up but oh well, not my call).
Just so you fokes know they are charging £350 +VAT to move your system + up to 8 workstations if you book before the end of the month (March 2010).
23rd March 2010, 12:29 PM #14
£350 isn't bad and thatís including FMS as well. Is that one the same server I presume?
23rd March 2010, 01:21 PM #15
Yep that is on the same server, but i dont see why they would charge extra to move it to a different one.
By mrforgetful in forum MIS Systems
Last Post: 12th August 2009, 02:38 PM
By woodham in forum MIS Systems
Last Post: 6th July 2009, 03:26 PM
By timbo343 in forum Windows
Last Post: 8th May 2008, 08:52 AM
By randle in forum MIS Systems
Last Post: 10th November 2007, 12:00 PM
By tech_guy in forum MIS Systems
Last Post: 26th October 2007, 06:21 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)