+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 27 of 27
MIS Systems Thread, SIMS - SQL2005 > SQL2008 Migration Problem in Technical; ...
  1. #16

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    It's easier to move it to a new server personally.

    @fawkers
    It's called cost savings, I know a number of schools who wouldn't be happy paying an extra £350 + vat if they didn't have to.

  2. #17

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    It seems this is going to be a painful process. I better start testing asap.
    Need to dig out some docs on best practises for setting up a Win2k8 server first, followed by SQL2k8....

  3. #18
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    32
    @fawkers
    It's called cost savings, I know a number of schools who wouldn't be happy paying an extra £350 + vat if they didn't have to.
    I agree, I know that lots of schools have very streched budgets as it is and for smaller schools £350 is that new PC that so and so has been after for a while. Which i sopose brings me back to my rant about capita producing a tool which doesn't work and that they wont support (in a few cases at least).
    Now if the tool worked me and my NM would be doing the SIMS migration no problems knowing that should anything funky happen we did it the 'capita way' and there should be support (well I would hope there would be). Instead of the 'dirty' way where we could end up in a complete mess, I'm sure that most of us here are capable of doing it this way its just if your willing to take the risk, personaly I would I feel happy to do so but it wasn't my call.

  4. #19
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    316
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    I've even tried removing the table completely, removing the entry, editing the entry it still doesn't like it. So frustrating when I can move the FMS databases with no problems what so ever.

  5. #20

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Quote Originally Posted by fawkers
    capita producing a tool which doesn't work and that they wont support (in a few cases at least).
    I would argue that. It does work, I admit it's a bit problematic in places.

  6. #21
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    316
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    It does work the tool, FMS worked fine for me its just this main SIMS database. I’m beginning to wonder if something is right with our existing database. I know (before my time) capita setup the original server and had some … major issues… esp with SQL 2005 and the migration. I just need to crack this nut.

  7. #22
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    316
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    Done it, right I think detaching the database using the standard DBattach tool isn’t the correct way to do it. But because I was having difficulties with the tools GUI on the original server that was my only option. Until I gave it one last go using the CLI and the --Silent switch, and it worked!
    Connected to the original database and done a migration to a transfer path, then on the new server the opposite and it was happy as rain no complaints about Backup locations. Logged into SIMS and everything so fair looks good!

  8. #23
    eddyc's Avatar
    Join Date
    Aug 2008
    Location
    Bristol
    Posts
    443
    Thank Post
    99
    Thanked 49 Times in 45 Posts
    Rep Power
    22
    Quote Originally Posted by matt40k View Post
    What??

    If your trying to do a clean install. Ask for the latest installable media, install it onto the new server. Then deattach the database(s) from the old server, copy them to the local drive of the new server, run the SQL migration tool on the new server, select the advanced option, select the deattached mdf(s).


    Have you tried asking them for the latest installable media?!
    They will not let us have it!

  9. #24

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Quote Originally Posted by ect View Post
    Have you tried asking them for the latest installable media?!
    They will not let us have it!
    Who Capita or your LA?

  10. #25
    eddyc's Avatar
    Join Date
    Aug 2008
    Location
    Bristol
    Posts
    443
    Thank Post
    99
    Thanked 49 Times in 45 Posts
    Rep Power
    22
    Quote Originally Posted by matt40k View Post
    Who Capita or your LA?
    Capita.

  11. #26

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Eh? Sure the lovely ladies in distribution could sort it out for you if you ask them nicely, assuming you've paid your annual maintenance and you don't get support via your LA

  12. #27
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    316
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    What setup files you after on the media? I found everything I needed in the setups folder after doing a solus update.



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

Similar Threads

  1. Guide on installing Full SQL2005 and SIMS
    By mrforgetful in forum MIS Systems
    Replies: 1
    Last Post: 12th August 2009, 03:38 PM
  2. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 04:26 PM
  3. SIMS and SQL2005 on a 64bit OS
    By timbo343 in forum Windows
    Replies: 2
    Last Post: 8th May 2008, 09:52 AM
  4. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 01:00 PM
  5. Replies: 7
    Last Post: 26th October 2007, 07:21 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
  •