+ 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,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174

    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
    12,181
    Thank Post
    1,651
    Thanked 1,973 Times in 1,445 Posts
    Blog Entries
    2
    Rep Power
    443
    what are you migrating from?

  3. #3

    Join Date
    Feb 2009
    Location
    Oldham, UK
    Posts
    50
    Thank Post
    21
    Thanked 4 Times in 3 Posts
    Rep Power
    12
    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,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    @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,943
    Thank Post
    1,199
    Thanked 1,071 Times in 762 Posts
    Rep Power
    330
    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 491 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,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    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
    115
    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
  •