RobFuller Posted March 19, 2010 Posted March 19, 2010 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 -----------------STEPS--------------------------- 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 -----------------STEPS--------------------------- 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!
matt40k Posted March 19, 2010 Posted March 19, 2010 Your not trying to copy it the database across the network to another server?!?
RobFuller Posted March 19, 2010 Author Posted March 19, 2010 This is the next plan, setup another server move 'SIMS' to that then run the migraton to SQL2008 on that server.
matt40k Posted March 19, 2010 Posted March 19, 2010 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).
vikpaw Posted March 21, 2010 Posted March 21, 2010 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.
matt40k Posted March 21, 2010 Posted March 21, 2010 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.
fawkers Posted March 22, 2010 Posted March 22, 2010 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!
matt40k Posted March 22, 2010 Posted March 22, 2010 What?? 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).
RobFuller Posted March 22, 2010 Author Posted March 22, 2010 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).
matt40k Posted March 22, 2010 Posted March 22, 2010 (edited) When you run the sql2008 migration tool, r-click and select "Run as Administrator" see if that makes any difference. UPDATE: Found this: 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. Edited March 22, 2010 by matt40k 2
RobFuller Posted March 23, 2010 Author Posted March 23, 2010 Hi Matt, 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!
RobFuller Posted March 23, 2010 Author Posted March 23, 2010 To be fair they are a company that needs to make 'more' money but yes I do feel your frustration. 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!
fawkers Posted March 23, 2010 Posted March 23, 2010 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).
RobFuller Posted March 23, 2010 Author Posted March 23, 2010 £350 isn't bad and that’s including FMS as well. Is that one the same server I presume?
fawkers Posted March 23, 2010 Posted March 23, 2010 Yep that is on the same server, but i dont see why they would charge extra to move it to a different one.
matt40k Posted March 23, 2010 Posted March 23, 2010 It's easier to move it to a new server personally. @fawkers It's called cost savings, I know a number of schools who wouldn't be happy paying an extra £350 + vat if they didn't have to.
vikpaw Posted March 24, 2010 Posted March 24, 2010 It seems this is going to be a painful process. I better start testing asap. Need to dig out some docs on best practises for setting up a Win2k8 server first, followed by SQL2k8....
fawkers Posted March 24, 2010 Posted March 24, 2010 @fawkers It's called cost savings, I know a number of schools who wouldn't be happy paying an extra £350 + vat if they didn't have to. I agree, I know that lots of schools have very streched budgets as it is and for smaller schools £350 is that new PC that so and so has been after for a while. Which i sopose brings me back to my rant about capita producing a tool which doesn't work and that they wont support (in a few cases at least). Now if the tool worked me and my NM would be doing the SIMS migration no problems knowing that should anything funky happen we did it the 'capita way' and there should be support (well I would hope there would be). Instead of the 'dirty' way where we could end up in a complete mess, I'm sure that most of us here are capable of doing it this way its just if your willing to take the risk, personaly I would I feel happy to do so but it wasn't my call.
RobFuller Posted March 24, 2010 Author Posted March 24, 2010 I've even tried removing the table completely, removing the entry, editing the entry it still doesn't like it. So frustrating when I can move the FMS databases with no problems what so ever.
matt40k Posted March 24, 2010 Posted March 24, 2010 capita producing a tool which doesn't work and that they wont support (in a few cases at least). I would argue that. It does work, I admit it's a bit problematic in places.
RobFuller Posted March 24, 2010 Author Posted March 24, 2010 It does work the tool, FMS worked fine for me its just this main SIMS database. I’m beginning to wonder if something is right with our existing database. I know (before my time) capita setup the original server and had some … major issues… esp with SQL 2005 and the migration. I just need to crack this nut.
RobFuller Posted March 24, 2010 Author Posted March 24, 2010 Done it, right I think detaching the database using the standard DBattach tool isn’t the correct way to do it. But because I was having difficulties with the tools GUI on the original server that was my only option. Until I gave it one last go using the CLI and the --Silent switch, and it worked! Connected to the original database and done a migration to a transfer path, then on the new server the opposite and it was happy as rain no complaints about Backup locations. Logged into SIMS and everything so fair looks good!
eddyc Posted March 24, 2010 Posted March 24, 2010 What?? 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). Have you tried asking them for the latest installable media?! They will not let us have it!
matt40k Posted March 24, 2010 Posted March 24, 2010 Have you tried asking them for the latest installable media?! They will not let us have it! Who Capita or your LA?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now