+ 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,030
    Thank Post
    157
    Thanked 60 Times in 48 Posts
    Rep Power
    30

    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
    5,013
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    108

    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,030
    Thank Post
    157
    Thanked 60 Times in 48 Posts
    Rep Power
    30

    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
    5,013
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    108

    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,030
    Thank Post
    157
    Thanked 60 Times in 48 Posts
    Rep Power
    30

    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
    30

    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,332
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79

    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,177
    Thank Post
    217
    Thanked 1,291 Times in 801 Posts
    Blog Entries
    4
    Rep Power
    512

    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
    62
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    17

    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
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32

    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
    34

    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,966
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    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
  •