+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 28
MIS Systems Thread, SQL 2012 Migration Tools Now Avaiable! in Technical; ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0

    SQL 2012 Migration Tools Now Avaiable!

    Who's feeling brave then?!

    SIMS SQL 2012 Migration

    I’m pleased to inform you that the SIMS SQL Migration 2012 Migration Utility is now available for download.

    This utility contains the following features and functionality:

    · Assists you in migrating SIMS, FMS and Discover Databases to SQL2012
    · If required it can install SQL2012 Express SP1
    · Allows for automatic redirection of the SIMS/FMS Clients and the DMS to the new SQL2012 Server

    Full details on the SQL 2012 migration utility are in the document contained within the download and also on SupportNet as Resource ID: 21223

    Customers looking to migrate SOLUS3 to SQL2012 should wait for the SOLUS3.6 release in August. Full details on how to migrate SOLUS3.6 to a SQL2012 system will be contained within its documentation.

    Regards,
    Jonathan Wood
    Product Manager Deployment and Technical
    Download link and P/W have been removed, however you can find them in SupportNet on the news item post.
    Last edited by Rawns; 9th July 2013 at 04:11 PM.

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,956
    Thank Post
    519
    Thanked 2,500 Times in 1,941 Posts
    Blog Entries
    24
    Rep Power
    840
    I'll be waiting until October half term I think!

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354

    SQL 2012 Migration Tools Now Avaiable!

    It didn't mention anything about needing to be on summer 13 first...? That's the small print!
    I think I might go cavalier and throw my data at summer and move to SQL 12 and why not try SOLUS 3 at it as well. On the test server at least ;p

  4. #4

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,132
    Thank Post
    598
    Thanked 1,060 Times in 817 Posts
    Blog Entries
    15
    Rep Power
    472
    Could you please link to the article? Can't find it, supportnet's search makes Bing look good.

  5. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by synaesthesia View Post
    Could you please link to the article? Can't find it, supportnet's search makes Bing look good.
    See my OP:

    Full details on the SQL 2012 migration utility are in the document contained within the download and also on SupportNet as Resource ID: 21223

  6. #6

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,132
    Thank Post
    598
    Thanked 1,060 Times in 817 Posts
    Blog Entries
    15
    Rep Power
    472
    That document contains lots of details on how to use the utility, not the location of it.

    Edit: does it actually do anything over and above dbattach?
    Specifically, detached it from our old server (2008) and attached to new (2012) and can't get it to work for love nor money.
    Last edited by synaesthesia; 25th July 2013 at 12:57 PM.

  7. #7
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by synaesthesia View Post
    That document contains lots of details on how to use the utility, not the location of it.
    Ahhh, your after the actual tools?

    It's the 10th item in the Capita News Feed list, posted 9th July2013.

    Try this link to the actual news post: http://support.capitaes.co.uk/user/d...E2%E8%D3%DA%D7

  8. 2 Thanks to Rawns:

    IWDave (3rd February 2014), synaesthesia (25th July 2013)

  9. #8

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,132
    Thank Post
    598
    Thanked 1,060 Times in 817 Posts
    Blog Entries
    15
    Rep Power
    472
    That's the one, cheers

  10. #9

    Join Date
    Jul 2013
    Location
    Northamptonshire
    Posts
    126
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    4
    If I want to migrate to 2012 on a different server.. do I have to install 2008 on it first?

  11. #10
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by TheGoodGuy View Post
    If I want to migrate to 2012 on a different server.. do I have to install 2008 on it first?
    No,you can use the tools to point it to a SQL2012 instance on a different server.

  12. Thanks to Rawns from:

    TheGoodGuy (13th August 2013)

  13. #11

    Join Date
    Jul 2013
    Location
    Northamptonshire
    Posts
    126
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    4
    Well unfortunately it is a bit more complicated than that. I believe that the old server has a rootkit on it, it seems to be somewhat contained but it keeps trying to generate files which the lovely Symantec antivirus just does an access deny on but can't clean. Cleaning the rootkit would be the obvious solution, but the tools that do that would need to reboot the server, however, the server has a corrupted drive and may not even be rebootable. I would be anxious about transferring files from the old server to the new server directly (at the moment I have it on a mini separate network) in case the rootkit spreads.

    My plan was to copy files to external storage then use an intermediary computer to scan the files before transferring to the new server. I guess the question would be whether to update to 2012 on the old server first or transfer on 2008 to the new server and then update to 2012. Any insight on how to deal with this would be welcomed. We are also transferring to a new domain as the school has changed names and we are moving from CC4 to Vanilla.

    My head is spinning a bit at the moment, I only started at the school this year and things were in a lot worse state when I arrived than they are now but my lack of experience with Sims makes me worry that I could have an oversight.

  14. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    Take a backup of sims and only transfer that file off to a safe place. Set up a 2008 sims server , VM or on a spare box and migrate from there.

  15. Thanks to vikpaw from:

    TheGoodGuy (13th August 2013)

  16. #13

    Join Date
    Jul 2013
    Location
    Northamptonshire
    Posts
    126
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    4
    Quote Originally Posted by vikpaw View Post
    Take a backup of sims and only transfer that file off to a safe place. Set up a 2008 sims server , VM or on a spare box and migrate from there.
    One more question, does it require internet access at all?

  17. #14

    Join Date
    Jul 2013
    Location
    Northamptonshire
    Posts
    126
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    4
    Also I think we need to upgrade to solus 3.. ugh this seems like a lot to do.

  18. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    No internet required to just move to a new server. All you might need is to use a safe machine to download the installers so you can create a safe server somewhere else to restore the backup to.
    You don't 'need' SOLUS 3 either.
    At this stage i'd concentrate on getting a clean clone of your current SIMS setup, then worry about upgrade / migration.

  19. Thanks to vikpaw from:

    TheGoodGuy (13th August 2013)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] Migrated to SQL 2012 - Tons of password resets!
    By adamf in forum MIS Systems
    Replies: 12
    Last Post: 17th February 2014, 06:00 PM
  2. [SIMS] SQL 2012 Migration Planning Advice - Posted on SupportNet
    By Rawns in forum MIS Systems
    Replies: 10
    Last Post: 22nd October 2013, 02:07 PM
  3. [SIMS] FMS SQL 2005-2008 without migration tool
    By Jamman960 in forum MIS Systems
    Replies: 5
    Last Post: 3rd December 2010, 05:44 PM
  4. share migration tool
    By Uraken in forum Windows
    Replies: 9
    Last Post: 18th October 2007, 06:03 PM
  5. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 03: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
  •