+ Post New Thread
Results 1 to 11 of 11
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 ...
  1. #1
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,347
    Thank Post
    85
    Thanked 47 Times in 33 Posts
    Rep Power
    31

    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.

  2. #2

    Join Date
    Jun 2010
    Posts
    397
    Thank Post
    37
    Thanked 58 Times in 55 Posts
    Rep Power
    32
    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.

  3. Thanks to Max_Power from:

    kennysarmy (14th November 2013)

  4. #3

    Join Date
    Oct 2006
    Posts
    23
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    18
    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!

    Good luck.

    --

  5. 2 Thanks to Jonesminor:

    kennysarmy (14th November 2013), SteveM555 (1st December 2013)

  6. #4
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,347
    Thank Post
    85
    Thanked 47 Times in 33 Posts
    Rep Power
    31
    Quote Originally Posted by Jonesminor View Post
    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!

    Good luck.

    --
    GREAT information - thanks.

    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!

  7. #5

    Join Date
    Nov 2009
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi, Downloaded capitas SIMS migration tool for sql2012, but the password provided just does not work for me. Has anyone experienced that?

  8. #6
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,284
    Thank Post
    477
    Thanked 188 Times in 182 Posts
    Blog Entries
    3
    Rep Power
    67
    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 04:57 PM.

  9. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,888
    Thank Post
    750
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Quote Originally Posted by Cache View Post
    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).
    maybe @PhilNeal can get the article updated - if it hasn't been already. last update was 29th..
    Last edited by vikpaw; 1st December 2013 at 10:01 AM.

  10. #8

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,382
    Thank Post
    36
    Thanked 369 Times in 254 Posts
    Rep Power
    82
    I will alert John Wood

  11. Thanks to PhilNeal from:

    vikpaw (2nd December 2013)

  12. #9
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,284
    Thank Post
    477
    Thanked 188 Times in 182 Posts
    Blog Entries
    3
    Rep Power
    67
    Quote Originally Posted by vikpaw View Post
    maybe @PhilNeal can get the article updated - if it hasn't been already. last update was 29th..
    Possibly, it was the 29th when I called.

  13. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,888
    Thank Post
    750
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    No :O( , i just downloaded and tried today and it failed.
    Last edited by vikpaw; 1st December 2013 at 03:02 PM.

  14. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,888
    Thank Post
    750
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Quote Originally Posted by PhilNeal View Post
    I will alert John Wood
    Thanks - the new one on the updated notice is working now.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SQL 2012 Migration Tools Now Avaiable!
    By Rawns in forum MIS Systems
    Replies: 27
    Last Post: 19th February 2014, 09:00 AM
  2. [SIMS] Migrated to SQL 2012 - Tons of password resets!
    By adamf in forum MIS Systems
    Replies: 12
    Last Post: 17th February 2014, 07:00 PM
  3. SIMS/SQL Server 2012 Migration
    By Bob_the_Goon in forum MIS Systems
    Replies: 7
    Last Post: 3rd February 2014, 05:43 PM
  4. [SIMS] SQL 2012 Migration Planning Advice - Posted on SupportNet
    By Rawns in forum MIS Systems
    Replies: 10
    Last Post: 22nd October 2013, 03:07 PM
  5. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 04:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •