+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Question about sql 2005 in Technical; Do i have to upgrade sql 2000 to sql 2005 or can I move sims on to a fresh install ...
  1. #1
    dezt's Avatar
    Join Date
    Dec 2005
    Location
    Lancs
    Posts
    1,009
    Thank Post
    153
    Thanked 55 Times in 43 Posts
    Rep Power
    28

    Question about sql 2005

    Do i have to upgrade sql 2000 to sql 2005 or can I move sims on to a fresh install of sql 2005 express. I only ask because I will need a new server for sims anyway and don't realy like the idea of having to pay £1700 for sql 2005 and the cals.

    If I can move the sims database accross to a new server with sql 2005 express then all I have to do is find the money for a new server, then I asume I can upgrade from sql 2005 express to sql 2005 at a later date.

  2. #2
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,943
    Thank Post
    115
    Thanked 272 Times in 250 Posts
    Rep Power
    104

    Re: Question about sql 2005

    Do you not have a support contract with the Westfield centre?

  3. #3
    dezt's Avatar
    Join Date
    Dec 2005
    Location
    Lancs
    Posts
    1,009
    Thank Post
    153
    Thanked 55 Times in 43 Posts
    Rep Power
    28

    Re: Question about sql 2005

    I've phoned them up, waiting on a call back. just wondered if anyone knew the answer or not.

  4. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,943
    Thank Post
    115
    Thanked 272 Times in 250 Posts
    Rep Power
    104

    Re: Question about sql 2005

    What I was geting at is are they not going to be doing the migration?

  5. #5
    dezt's Avatar
    Join Date
    Dec 2005
    Location
    Lancs
    Posts
    1,009
    Thank Post
    153
    Thanked 55 Times in 43 Posts
    Rep Power
    28

    Re: Question about sql 2005

    I don't know, i'll have to phone them up again tomorrow as they didn't get back to me.

  6. #6
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    29

    Re: Question about sql 2005

    Unless you're willing to pay eye-watering consultancy fees or you're very well clued up on SIMS, don't expect any help from Capita.

    I am dreading this but I am getting the personnel5 conversion out the way first. Then I will worry about SQL.

  7. #7

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,249
    Thank Post
    33
    Thanked 336 Times in 225 Posts
    Rep Power
    75

    Re: Question about sql 2005

    You can use SQL Express if your database is below 4G. The school price for SQL Server shouldn't be anything like £1700.

    See our knowledgebase (which is free) for instructions on moving to a new server.

  8. #8

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,021
    Thank Post
    212
    Thanked 1,165 Times in 758 Posts
    Blog Entries
    4
    Rep Power
    481

    Re: Question about sql 2005

    The capita documentation on moving servers we found next to useless.

    Somerset's support team have made this http://www.six.somerset.gov.uk/sixv3....asp?did=12282 document, its a bit out of date (but not much) and is a good overview as to what you have to do.

  9. #9

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    59
    Thank Post
    5
    Thanked 14 Times in 11 Posts
    Rep Power
    16

    Re: Question about sql 2005

    SQL Express will only use up to 1Gb RAM so I would be concerned that moving from a full version of SQL Server to a restricted version would have a negative impact on performance

  10. #10
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    888
    Thank Post
    68
    Thanked 84 Times in 69 Posts
    Rep Power
    31

    Re: Question about sql 2005

    Quote Originally Posted by dezt
    don't realy like the idea of having to pay £1700 for sql 2005 and the cals.
    You may find that per-processor licesning for SQL is cheaper than per server/client licensing. It's worth looking at anyway.

  11. #11
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    33

    Re: Question about sql 2005

    In the experience of our schools support team, the move to SQL was not that bad. The key thing is to try it out first. Set up a test system (can be on a real standalone PC/Server or a VM). Install SIMS and test the migration path.

    Migration is done 'online', so it should not be a problem migrating directly from the old SQL 2000 system to SQL 2005 (express) on new hardware.

  12. #12
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,946
    Thank Post
    235
    Thanked 48 Times in 44 Posts
    Blog Entries
    2
    Rep Power
    45

    Re: Question about sql 2005

    Good, that's what we intend to do.

SHARE:
+ Post New Thread

Similar Threads

  1. ID Cards with SQL 2005
    By hayjo86 in forum MIS Systems
    Replies: 2
    Last Post: 20th December 2007, 10:34 AM
  2. SQL 2005
    By jcollings in forum MIS Systems
    Replies: 12
    Last Post: 22nd October 2007, 03:00 PM
  3. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  4. C#/SQL 2005 question
    By Gatt in forum Coding
    Replies: 4
    Last Post: 29th June 2007, 05:12 AM
  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
  •