+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, 2008 SQL migration in Technical; We are about to start the migration to SQL Express on non secondary schools. Any pitfalls to be aware of?...
  1. #1

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168

    2008 SQL migration

    We are about to start the migration to SQL Express on non secondary schools.

    Any pitfalls to be aware of?

  2. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,101
    Thank Post
    1,430
    Thanked 1,693 Times in 1,266 Posts
    Blog Entries
    2
    Rep Power
    364
    what are you migrating from?

  3. #3

    Join Date
    Feb 2009
    Location
    Oldham, UK
    Posts
    48
    Thank Post
    18
    Thanked 4 Times in 3 Posts
    Rep Power
    11
    I have tested yesterday on test system, from SQL 2005 to SQL 2008 64bit work fine. Except one problem, we have active directory integrated (Auto logon) one of user name was changed and that was not updated in SIMS, corrected that and its work fine.

  4. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    @Nephilim
    SIMS 2005 - 2008 SQL

    @RCS_USER
    I have done 2 test systems and no problems, but a live school and old servers?

  5. #5

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,853
    Thank Post
    1,160
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323
    New SQL instance has to be a named instance and watch out for the installation drive install path as some schools install to a different drive that's all, did it yesterday from 2005 - 2008 ent and no apparent problems.

  6. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0
    We are about to start ours too. We are hopefully automating the process as much as possible using CentraStage. It worked a treat on the test system. But on a live site, you never can tell.

    The annoying thing will be the pre-requisites of getting .Net 3.5 SP1 and Windows Installer 4.5 on the servers. 4.5 reboots after install and if you need to install .Net 3.5, you have to reboot again before installing SQL. Luckly, we can schedule it as an overnight process.

  7. #7

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Luckily we put 3.5 on ages ago. Running SIMSSQLInfrastructure.exe before had and it seems happy with the setup.

  8. #8

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    114
    The annoying thing will be the pre-requisites of getting .Net 3.5 SP1 and Windows Installer 4.5 on the servers. 4.5 reboots after install and if you need to install .Net 3.5, you have to reboot again before installing SQL.
    ?
    Different automation but I did SQL pre-reqs as "Phase 1" a while back and didn't need a reboot for powershell1 (required for Management Studio) or dotNet 3.5SP1, just MSI4.5.
    [Phase 2 is SQL 2008 Express w. Tools and SP1. Phase 3 is running the Capita migration util etc.]

SHARE:
+ Post New Thread

Similar Threads

  1. Who's doing their SQL 2008 Migration for SIMS today?
    By chazzy2501 in forum General Chat
    Replies: 4
    Last Post: 30th April 2010, 11:31 AM
  2. 2008 SQL migration
    By creese in forum MIS Systems
    Replies: 0
    Last Post: 22nd April 2010, 10:14 AM
  3. SIMS SQL 2008 migration utility
    By Oops_my_bad in forum MIS Systems
    Replies: 28
    Last Post: 11th February 2010, 02:29 PM
  4. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM
  5. Problem after SQL Migration
    By Jawloms in forum MIS Systems
    Replies: 5
    Last Post: 24th October 2007, 03:06 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
  •