+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 28 of 28
MIS Systems Thread, SQL 2012 Migration Tools Now Avaiable! in Technical; To be honest we will probably just get Capita in to sort it out. I have lots of other things ...
  1. #16

    Join Date
    Jul 2013
    Location
    Northamptonshire
    Posts
    126
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    4
    To be honest we will probably just get Capita in to sort it out. I have lots of other things to do (inc. setting up system center and building a new website) that I can't really have the time to focus on Sims properly. Thanks all for your advice though, it was appreciated and will be taken on board when instructing Capita.

  2. #17

    Join Date
    Jul 2013
    Location
    Northamptonshire
    Posts
    126
    Thank Post
    28
    Thanked 8 Times in 6 Posts
    Rep Power
    4
    Turns out Capita aren't available until the end of September. Looks like I might have to do this myself after all. Just gotta go for it I guess, what's the worst than can happen?

  3. #18

    Join Date
    Aug 2013
    Location
    Buckinghamshire
    Posts
    6
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi TheGoodGuy,

    I have moved a few schools to SQL 2012 without issue.
    What went wrong?

  4. #19

    Join Date
    Nov 2009
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    This password does not work with that download or I'm doing something silly

  5. #20

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by gresso View Post
    This password does not work with that download or I'm doing something silly
    Check SupportNet for the latest notice and the password has been updated. :O)

  6. Thanks to vikpaw from:

    gresso (17th December 2013)

  7. #21

    Join Date
    Nov 2009
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    Check SupportNet for the latest notice and the password has been updated. :O)
    Thanks for the info. I've ended up doing without Migration Tools. Is there anything I should adjust manually?

  8. #22

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    There's a guide they supplied for use prior to the release of the tools, so check that on SupportNet again, in case there is.
    possibly pointers to the db in certain ini files depending on if you're just upgraded sql, or moved to a new server / instance.

  9. #23

    Join Date
    Nov 2009
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    There's a guide they supplied for use prior to the release of the tools, so check that on SupportNet again, in case there is.
    possibly pointers to the db in certain ini files depending on if you're just upgraded sql, or moved to a new server / instance.
    Moved entire server with new name, etc. Did all the standard manual modifications ini files, DOCSTORAGE, Tasks, etc. The only difference was that I've restored it to sql 2012 instance. All went fine, but just wondered if there is anything clever those tools do. I figured out I have to manually change compatibility level on db to 110 version. Was mainly curious what is happening behind the scene during "configuring sims database" step within migration

  10. #24

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Well looking at resource 20081 on SupportNet it doesn't look like there is anything else to do.
    You should check the other guides as well though. I think the main job is probably that it handles the redirection of connect.ini for schools that won't know or be able to manage the change, though i'm sure for the sql 2008 migration it sometimes didn't work.

  11. #25

    Join Date
    Nov 2009
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    Well looking at resource 20081 on SupportNet it doesn't look like there is anything else to do.
    You should check the other guides as well though. I think the main job is probably that it handles the redirection of connect.ini for schools that won't know or be able to manage the change, though i'm sure for the sql 2008 migration it sometimes didn't work.
    One thing I had to was to reset a lot of passwords, despite running procedures to transfer logins on the old server first. Not sure if that would be any different with tools.

    Thanks for providing resource number
    Last edited by gresso; 18th December 2013 at 10:24 AM.

  12. #26

    Join Date
    May 2008
    Posts
    524
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    Is it just SIMS, FMS and Discover that are migrated or does SOLUS3 and Intouch (if its part of SQL??) need to be done too?

  13. #27

    Join Date
    Nov 2009
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by techie08 View Post
    Is it just SIMS, FMS and Discover that are migrated or does SOLUS3 and Intouch (if its part of SQL??) need to be done too?
    I would say InTouch is web service pointing to instance (so its not part of SQL), however after migration probably instance name will change so it will have to be reconfigured.
    I don't remember SOLUS3 setup as I try to say away from it as long as possible, so I did not have to do anything with it as was not present in first place for this migration.
    Last edited by gresso; 13th January 2014 at 09:16 PM.

  14. #28

    Join Date
    Sep 2013
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi,

    Does anyone know any good SQL or SAS training?

    Thanks

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

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
  •