+ Post New Thread
Page 4 of 4 FirstFirst 1234
Results 46 to 55 of 55
MIS Systems Thread, SIMS SQL 2005 in Technical; So do you use six disk?...
  1. #46
    nicholab's Avatar
    Join Date
    Nov 2006
    Location
    Birmingham
    Posts
    1,453
    Thank Post
    4
    Thanked 97 Times in 93 Posts
    Blog Entries
    1
    Rep Power
    50

    Re: SIMS SQL 2005

    So do you use six disk?

  2. #47

    Join Date
    Apr 2007
    Location
    Sutton Coldfield
    Posts
    207
    Thank Post
    29
    Thanked 34 Times in 28 Posts
    Rep Power
    20

    Re: SIMS SQL 2005

    Yes, there's 6 disks in total. 2 x 73GB (RAID1) for OS Install, 4 x 300GB (600GB usable RAID 10) for SQL Data Directory.

    Rob

  3. #48
    monkeyx's Avatar
    Join Date
    Nov 2006
    Posts
    364
    Thank Post
    8
    Thanked 52 Times in 41 Posts
    Rep Power
    25

    Re: SIMS SQL 2005

    From you previous answer I guess the answer is NO, you have not actually migrated from one MIS to another.

    Also Serco move the data for you
    How does that fit with the Ts&Cs of your Capita contract which state, IIRC, that you won't share your database outside of your school and Capita?
    I did check Ts&Cs the data in the database is the schools property! But just to make sure I copied the original! It is only the application accessing the data that is part of Ts&Cs. The migration procedures are run within Facility by the school.

    Any how I guess that is not really the point of this thread, just that I seem to becoming a grumpy old **** recently!

  4. #49
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    889
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32

    Re: SIMS SQL 2005

    Quote Originally Posted by bossman
    Only SQL express (free) but you would still have to purchase cals.
    I don't think so: http://www.microsoft.com/sql/howtobuy/default.mspx

  5. #50

    Join Date
    Mar 2007
    Location
    The North of England
    Posts
    207
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    15

    Re: SIMS SQL 2005

    Moving data from one sims server is a doddle and will take you one day only at the most. I have just done this with mine moving from one domain to another, it took me just less than a day and then obviously now I have to visit all the workstations and reconfigure them to go onto the new domain. Not using as much RAM as you guys but see no problems with connectivity or speed. I will need to revisit this later in the year as we have more users connected to the SIMS database.

  6. #51

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,282
    Thank Post
    225
    Thanked 403 Times in 300 Posts
    Rep Power
    161

    Re: SIMS SQL 2005

    nayone know the optimal options to choose when installing? Our LEA team have given us meticulus instructions on installing SQL server but been very vague on what components are best installed. IS just the database enough or ar things like teh management and connectivity tools best to install?

    Ta

  7. #52

    Join Date
    Jan 2007
    Posts
    41
    Thank Post
    2
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    I am frankly quite disgusted.

    We have been told that a roadmap to sql2005 would be published. I've heard nothing from our local dotict team apart from being told that there was a tool for estimating the server specification. The tool wouldn't run, I reported the issue but have heard nothing since. Over two months now. If I'm going to need to build a new server I need a budget and plenty of time. I'll be delighted to move to sql 2005, but the time allowance is atrocious.

    I have defended Capita and SIMS to our head in the past and had a fair amount of flack about it. I'm afraid I'm beginning to think that they have a captive customer base and they don't have to worry about disruption. Our school is in the middle of timetabling issues, I've got a number of major projects to oversee, there have been no announcements from our local dotict team about the August upgrade, let alone that this will require an SQL 2005 move.

  8. #53

    Join Date
    Aug 2007
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL 2005

    I have just completed the August MIS upgrade and the Migration to SQL 2005 with no issues what so ever, took about 1.5 hrs..

  9. #54
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,132
    Thank Post
    177
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    Re: SIMS SQL 2005

    Last week the LEA came in to run the August upgrade, install SQL 2005 and migrate the database over. They said to leave SQL 2000 running for a month in case there were any problems. Thinking about it I can’t see any advantage in keeping SQL2000 running as it was only used for Sims and now the database has been converted to 2005 there’s no going back. Funny that :?

  10. #55

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,131
    Thank Post
    1,907
    Thanked 1,342 Times in 741 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SIMS SQL 2005

    Hi,

    Am I right in interpreting then that the SQL2005 upgrade has to be carried out before the August update?

    All the literature I've been given by the support department in our LEA state that the order is August Sims upgrade, SQL2005 upgrade, then November Sims upgrade.....

SHARE:
+ Post New Thread
Page 4 of 4 FirstFirst 1234

Similar Threads

  1. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM
  2. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  3. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  4. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM

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
  •