+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, FMS SQL 2005-2008 without migration tool in Technical; Hey guys, Our Finance server became flakey the other day and I hadn't done the FMS SQL 2008 migration as ...
  1. #1
    Jamman960's Avatar
    Join Date
    Sep 2007
    Location
    London/Kent
    Posts
    959
    Thank Post
    173
    Thanked 191 Times in 153 Posts
    Rep Power
    45

    FMS SQL 2005-2008 without migration tool

    Hey guys,

    Our Finance server became flakey the other day and I hadn't done the FMS SQL 2008 migration as yet, I decided to migrate the db over to our sims server and get rid of the accounts server all togeather(its just a powerful workstation with win2k3 installed). Before I managed to carry out the migration the server became unbootable.

    Anyway... I have a full backup of the FMS db, when restoring it to our sql 2k5 instance the sysman username won't work so I've restored it directly to our SQL 2k8 instance and it appears to be working(I can logon and view various bits without error) - I noticed that the Sims migration util just detatched and reattatched the db along with doing a few file updates. Is the FMS one the same?

    Cheers,

    James

  2. #2
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,199
    Thank Post
    149
    Thanked 143 Times in 129 Posts
    Rep Power
    75
    I don't know whether this will work or not and of course if it breaks, don't blame me.

    The technician at Capita resolved my issue with the same problem but on SIMS db by using this tool. You'd need to know the SA password though (if it'll work!). It was run on the server with the db. He went to tools and the option was there.

    - Just ran it, option is on it to reset sysman for FMS and SIMS under tools.
    Last edited by dwhyte85; 3rd December 2010 at 01:45 PM.

  3. Thanks to dwhyte85 from:

    Jamman960 (3rd December 2010)

  4. #3

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,659
    Thank Post
    319
    Thanked 311 Times in 253 Posts
    Blog Entries
    8
    Rep Power
    122
    I think echo the above... if it breaks expect to pay big to Capita to fix!

  5. Thanks to GREED from:

    Jamman960 (3rd December 2010)

  6. #4
    Jamman960's Avatar
    Join Date
    Sep 2007
    Location
    London/Kent
    Posts
    959
    Thank Post
    173
    Thanked 191 Times in 153 Posts
    Rep Power
    45
    Nice one, will attempt to reset sysman password and migrate properly. Have logged a case on supportnet asking for advice also.

    If needs be I could setup a fresh sql2k5 install somewhere and attach the db to that.

    James

  7. #5
    Jamman960's Avatar
    Join Date
    Sep 2007
    Location
    London/Kent
    Posts
    959
    Thank Post
    173
    Thanked 191 Times in 153 Posts
    Rep Power
    45
    Update:

    Thank you very much! the tool to reset the sysman password worked perfectly. Have now reset the password on the 2k5 instance and migrated it using the tool... I'd presume simply attaching the 2k5 db on the 2k8 instance would have worked also but might aswell do things properly

    Edit: Capita have confirmed that restoring the backup/attaching the database from a 2k5 instance to a 2k8 instance will work, they've sent over a patch to ensure the recovery model setting is correct.

    Thankfully the server decided to break while we were closed for snow so I haven't had anyone complaining about the downtime if only all servers could wait for some downtime before breaking

    James
    Last edited by Jamman960; 3rd December 2010 at 04:39 PM. Reason: additional info

  8. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,659
    Thank Post
    319
    Thanked 311 Times in 253 Posts
    Blog Entries
    8
    Rep Power
    122
    Cheers for the update

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 02:24 PM
  2. how do I get siims fms 2003 - 2008 Migration Utility.
    By edutech4schools in forum MIS Systems
    Replies: 4
    Last Post: 21st July 2010, 12:02 PM
  3. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  4. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 06:03 PM
  5. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 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
  •