+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Migrate SIMS database to SQL 2008 in Technical; Re SIMS and SQL 2005 I see that we are going to need to move to SQL 2008 by Oct ...
  1. #1

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124

    Migrate SIMS database to SQL 2008

    Re SIMS and SQL 2005 I see that we are going to need to move to SQL 2008 by Oct 2010. I have not been involved with SIMS work to any extent before, the school having bought in CAPITA Tech time to do the task.

    I presume that the first job is to download and deploy SQL 2008 (when to do it too being another question) and then migrate the SIMS database to it? Is this right and if so how easy / difficult is it to do - without borfing it

  2. #2

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    No doubt Capita will have/already have lengthy documentation on how to do this. Have a look on their SupportNet for more info.

  3. Thanks to timzim from:

    speckytecky (2nd October 2009)

  4. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    It is available, with the migration tool/documentation, on the Autumn Release.

  5. Thanks to Sivadam from:

    speckytecky (4th October 2009)

  6. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    I take it you have a SupportNet account, if not go get signed up.
    Resource number 14865 has some info.
    Looks like the installation / migration tool is available from October 17th.

    When we needed to migrate to SQL 2005, our local support offered a migration service (paid for of course!), however it was pretty straight forward and if you push for it, you should always be able to do the migration yourself, if you dare

    It looks relatively straight forward, and your old system will stay intact, so there's always a fall back option if things go wrong.

    As it's a year off, i'd be tempted to hold back for a while and maybe run a virtual version and see how it fares, try running an update on it etc.

  7. Thanks to vikpaw from:

    speckytecky (7th October 2009)

  8. #5
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    If you want to take advantage of the new NT4 style reporting using SQL Server 2008 then you will have to have upgraded for then. These are due in March - providing they make the deadline. The NT4 Reports have been made a priority in the new Reporting System.

  9. Thanks to Sivadam from:

    speckytecky (7th October 2009)

  10. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    ooh sounds promising

  11. #7

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124
    Thanks Vikpaw, Been on there but Resource number 14865 doesn't seem to be available, is that definately the right number?

  12. #8
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    It looks like we will be going ahead with SQL Server 2008 on to a new Server during Half Term - providing that the Autumn Upgrade appears in time.
    It would be crazy trying to move before that happens and before Capita support it.
    Also - the documentation will undoubtedly come with the release! It may well be that the Support Document has been withdrawn to be updated inline with the Autumn Release.
    Last edited by Sivadam; 7th October 2009 at 12:38 PM.

  13. Thanks to Sivadam from:

    speckytecky (7th October 2009)

  14. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367

    Post

    Quote Originally Posted by speckytecky View Post
    Thanks Vikpaw, Been on there but Resource number 14865 doesn't seem to be available, is that definately the right number?
    yeah log in to SupportNet,
    click on documentation on the right hand side,
    enter the number in the resource number box and search.
    it appears, i just downloaded it.

    i'll try to attach just in case you can't do it.
    Attached Files Attached Files

  15. 3 Thanks to vikpaw:

    dhicks (10th October 2009), Oops_my_bad (11th October 2009), Shuriken1 (22nd June 2010)



SHARE:
+ Post New Thread

Similar Threads

  1. vmware SQL database
    By badders in forum Thin Client and Virtual Machines
    Replies: 5
    Last Post: 29th September 2010, 03:26 PM
  2. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 01:08 AM
  3. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 09:17 AM
  4. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 04:24 PM
  5. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 10:36 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
  •