MIS Systems Thread, SQL 2012 Migration in Technical; I am planning our migration from SQL Server 2008R2 to SQL Server 2012.
This will be on the same virtual ...
14th November 2013, 09:02 AM #1
SQL 2012 Migration
I am planning our migration from SQL Server 2008R2 to SQL Server 2012.
This will be on the same virtual server.
I've downloaded the SQL2012-Migration.zip ready and have read through the Capita mini guide.
The only thing I cannot find are any notes to help with the SQL 2012 installation in case and I'm sure it will, ask for any information etc.
Does anyone have any information they can share?
I believe once SQL 2012 is on the server then I need to do the "Host Configuration Requirements" and then finally run the migration process EXE.
I am thinking of doing this upgrade over Christmas when the school is empty...
Any advice appreciated.
14th November 2013, 09:59 AM #2
Sorry that this isnt an answer directly to your query, I was going to do the same thing over xmas but found out SIMS have pushed back their migration requirement for SQL2012 to next autumn due to issues with various components one of which is intouch. They will continue to support SQL2008 until next autumn so ill be pushing migration back now until after spring release which is when they are advising people that its safe to migrate without having to use work arounds for known issues for things like intouch.
Thanks to Max_Power from:
kennysarmy (14th November 2013)
14th November 2013, 10:30 AM #3
- Rep Power
I'm about to undertake the same task, albeit to a new server. I believe the migration utility will install SQL2012 express or you can install the full version it yourself. I'm going for the latter.
I've installed SQL2012 on the new box and selected only the database engine, full text search and management tools. Only problem I came across with the installation was the need for .Net 3 to be installed beforehand. I installed a named instance, SIMS2012 with mixed mode authentication and set a password for the sa login and this instance is on a separate disk to the os and shared SQL components.
On the Windows firewall, I've opened port 1433 TCP and 1434 UDP and added the .exe for the sql browser and sql server. Management Studio connects ok from a remote pc.
Next step for us is to install SIMS on the new server once capita send me a link to the ISO for the latest installer. You won't need to do this as you're upgrading.
I seem to recall the redirection feature didn't work the last time we tried this and we had to manually edit the sims and fms connect.ini files and reconfigure the Document Storage folder.
Obviously make sure you have good backups before you start!
2 Thanks to Jonesminor:
kennysarmy (14th November 2013), SteveM555 (1st December 2013)
14th November 2013, 11:11 AM #4
GREAT information - thanks.
Originally Posted by Jonesminor
I will take a snapshot of the server before we start the upgrade so we can roll back should it all go t*ts up....
In lieu of the comment above yours I'm considering now delaying this until it's more necessary!
29th November 2013, 09:24 PM #5
- Rep Power
Hi, Downloaded capitas SIMS migration tool for sql2012, but the password provided just does not work for me. Has anyone experienced that?
30th November 2013, 03:54 PM #6
Yup I had the same issue when I downloaded yesterday, I was told they rebundled the migration tools and the password got changed (but the news article hasn't been updated).
I had to call the service desk to get the password (and don't have it too hand at the moment sorry).
Last edited by Cache; 30th November 2013 at 03:57 PM.
1st December 2013, 09:00 AM #7
maybe @PhilNeal can get the article updated - if it hasn't been already. last update was 29th..
Originally Posted by Cache
Last edited by vikpaw; 1st December 2013 at 09:01 AM.
1st December 2013, 10:58 AM #8
Thanks to PhilNeal from:
vikpaw (2nd December 2013)
1st December 2013, 01:18 PM #9
Possibly, it was the 29th when I called.
Originally Posted by vikpaw
1st December 2013, 01:19 PM #10
No :O( , i just downloaded and tried today and it failed.
Last edited by vikpaw; 1st December 2013 at 02:02 PM.
2nd December 2013, 07:09 AM #11
Thanks - the new one on the updated notice is working now.
Originally Posted by PhilNeal
By Rawns in forum MIS Systems
Last Post: 19th February 2014, 08:00 AM
By adamf in forum MIS Systems
Last Post: 17th February 2014, 06:00 PM
By Bob_the_Goon in forum MIS Systems
Last Post: 3rd February 2014, 04:43 PM
By Rawns in forum MIS Systems
Last Post: 22nd October 2013, 02:07 PM
By Mr_M_Cox in forum MIS Systems
Last Post: 16th August 2007, 03:24 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)