+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, Summer Release and SQL 2008 Upgrade in Technical; I'll be installing both of these later in the summer - does it matter which way round I do them? ...
  1. #1
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76

    Summer Release and SQL 2008 Upgrade

    I'll be installing both of these later in the summer - does it matter which way round I do them? We're currently on 7.124 so SQL 2008 can go on already, but I wanted to check in case there were any Funnies which meant it was better to do a particular one first.

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Doesn't matter at all. We have done about 90 migration on 7.128. we will be doing some more in September which will be on Summer release. Thats Express but we are doing several Full SQL too.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    @Creese; - have you done migrations from one server to another? I heard that it's best to do it in situ then move the db to a clean server after.

  4. #4
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,219
    Thank Post
    159
    Thanked 147 Times in 132 Posts
    Rep Power
    103
    This is causing major hassle for us...

    • Ideally, we need to migrate to a new server.
    • Do I then run the upgrade or do it prior to migrate?
    • I have to find time to do this between data entry, exam inputting and exporting & roll over.
    • SIMS 'manager' not available
    • Weekends not an option


    Bullet points 1 & 2 are pretty much easy to do, the problem is getting SLT to see the importance in this! Instead of this, that, the other needs to be done first... I don't know what effect the SIMS upgrade will have on any of bullet point 3... my role defines I don't need to, that the SIMS manager should know. From experience of trying to 'help', i get told to get back to where I belong, in the server room - that's pretty much the attitude with the SIMS manager who is 100% not technical.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    i think @dwhyte85; that it doesn't matter which order you do it.

    When you say migrate i take it you mean migrate to a physical new server that is windows 2008 and sql 2008 from an old win2k3 or some such...?

    i've just applied the summer update, and mostly things are fine, now i'm trying to sort out the migration to sql 2008, and then will look at moving it to another physical server on windows 2008.

    i went for the update first on the grounds it as a task is most urgent, so we are up to date on the system side. i missed out spring and went straight to summer from autumn update.

    next i need to get to sql 2008, but again, the ultimate deadline will be october, so worst case scenario i will do it after summer hols but before start of next term.

    physically moving server to a win2k8 would be nice but it's not urgent at this stage.

  6. #6

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by vikpaw View Post
    @Creese; - have you done migrations from one server to another? I heard that it's best to do it in situ then move the db to a clean server after.
    All of ours have been on old servers, glorified PCs really.

    EDIT: Just read another reply from you. By 'migrate' I understand and meant migrate SQL from 2005 to 2008.

  7. #7

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    I was told (by Sims Support) to do the Summer upgrade first then do the migration but I don't think it matters too much

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by creese View Post
    All of ours have been on old servers, glorified PCs really.

    EDIT: Just read another reply from you. By 'migrate' I understand and meant migrate SQL from 2005 to 2008.
    yes it's confusing because many people when they talk of the migrate from SQL 2005 to 2008, also want the new SQL 2008 to be on a Windows Server 2008 box, which it doesn't have to be.

    I was referring to in the documentation it mentions doing an advanced migration such that you move the DB from one physical server to another, regardless of the OS. I was thinking about doing this. However, due to time contraints am going to do it in situ now, and then move to a different server with Win 2k8 later on.

  9. #9
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,219
    Thank Post
    159
    Thanked 147 Times in 132 Posts
    Rep Power
    103
    Quote Originally Posted by vikpaw View Post
    i think @dwhyte85; that it doesn't matter which order you do it.

    When you say migrate i take it you mean migrate to a physical new server that is windows 2008 and sql 2008 from an old win2k3 or some such...?

    i've just applied the summer update, and mostly things are fine, now i'm trying to sort out the migration to sql 2008, and then will look at moving it to another physical server on windows 2008.

    i went for the update first on the grounds it as a task is most urgent, so we are up to date on the system side. i missed out spring and went straight to summer from autumn update.

    next i need to get to sql 2008, but again, the ultimate deadline will be october, so worst case scenario i will do it after summer hols but before start of next term.

    physically moving server to a win2k8 would be nice but it's not urgent at this stage.
    Thanks, I will apply the update this weekend. I will then do the SQL 2005->2008 upgrade THEN migrate to a new server, it could probably stay on our 2003 box with a bit more RAM but... I have a newer server for it, may as well make use of it.

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by dwhyte85 View Post
    Thanks, I will apply the update this weekend. I will then do the SQL 2005->2008 upgrade THEN migrate to a new server, it could probably stay on our 2003 box with a bit more RAM but... I have a newer server for it, may as well make use of it.

    I would do the update. The do the SQL2008 migration and the server move in one go.

    Basically, ask for the latest SIMS installable disc, install it on the new server, don't attach the database. Deattach it from the old server, copy the SIMS.mdf and SIMS.ldf to the new server run the SQL2008migration tool and click the advanced option and select the SIMS.mdf and continue as normal though the tool. You'll need to update the connect.ini by hand.

    Should save you a bit of work.

  11. #11
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,219
    Thank Post
    159
    Thanked 147 Times in 132 Posts
    Rep Power
    103
    Will it affect exam entry or rollover... I can't do it until the end of August because of stupid planning by SLT.

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by matt40k View Post
    I would do the update. The do the SQL2008 migration and the server move in one go.

    Basically, ask for the latest SIMS installable disc, install it on the new server, don't attach the database. Deattach it from the old server, copy the SIMS.mdf and SIMS.ldf to the new server run the SQL2008migration tool and click the advanced option and select the SIMS.mdf and continue as normal though the tool. You'll need to update the connect.ini by hand.

    Should save you a bit of work.
    Quote Originally Posted by dwhyte85 View Post
    Will it affect exam entry or rollover... I can't do it until the end of August because of stupid planning by SLT.
    It shouldn't affect anything, but as with most things, you just need to allow time for things not going to plan. That's why i'd prefer the doing it in stages method.
    I was about to do my migration and then ended up on the phone to Capita fixing a different issue that came about from the summer upgrade, and now they need my data, so i've delayed the migration.
    Prerequisites that will save time will be to ensure you have Windows Installer 4.5 downloaded on the server for the sql 2k8 install. Also make sure the .net framework is up to date, you can put 4 on now ready for solus3 and discover.

  13. #13
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by vikpaw View Post
    It shouldn't affect anything, but as with most things, you just need to allow time for things not going to plan. That's why i'd prefer the doing it in stages method.
    I was about to do my migration and then ended up on the phone to Capita fixing a different issue that came about from the summer upgrade, and now they need my data, so i've delayed the migration.
    Prerequisites that will save time will be to ensure you have Windows Installer 4.5 downloaded on the server for the sql 2k8 install. Also make sure the .net framework is up to date, you can put 4 on now ready for solus3 and discover.
    SOLUS 3b actually comes package with the appropriate infrastructure and so it will install .net4 for you (both on Deployment Server and on Clinets). Obviously it then will take longer to run though!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release
    By matt40k in forum MIS Systems
    Replies: 49
    Last Post: 11th February 2011, 01:12 PM
  2. CC4 Upgrade - Summer 2010
    By maestromasada in forum Network and Classroom Management
    Replies: 43
    Last Post: 9th September 2010, 10:37 PM
  3. [SIMS] 2010 Summer release
    By matt40k in forum MIS Systems
    Replies: 13
    Last Post: 24th July 2010, 12:18 PM
  4. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 09:31 AM
  5. FMS SQL 2008 Upgrade
    By rh91uk in forum MIS Systems
    Replies: 2
    Last Post: 17th April 2010, 08:40 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
  •