+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Upgrading from SQL2008 to SQL2008R2 in Technical; Have had a few error messages attempting to attach a new borough wide FMS DB to a school we have ...
  1. #1

    Join Date
    Mar 2014
    Location
    London
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Upgrading from SQL2008 to SQL2008R2

    Have had a few error messages attempting to attach a new borough wide FMS DB to a school we have just taken on.

    The long and the short of it is that our DB was created in an R2 environment and the school is still in SQL 2008 Express.

    What is the easiest and quickest upgrade path to get to R2.......
    Last edited by PaulDevall; 6th March 2014 at 03:50 PM.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Be proactive and install and migrate to SQL2012

  3. #3

    Join Date
    Mar 2014
    Location
    London
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Have suggested that already. They already have SIMS 7.154 running and the Head doesn't want "any disruption" when we install FMS in the same instance.

    My idea was to install FMS in a new R2 instance and then migrate both to 2012 at a later date once they are happy that it all works.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Is this the only FMS database? Could you get away with installing FMS on SQL2012, then migrate SIMS later?

  5. #5

    Join Date
    Mar 2014
    Location
    London
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I think that may be only way around it... Thanks.

  6. #6

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,071
    Thank Post
    592
    Thanked 1,039 Times in 797 Posts
    Blog Entries
    15
    Rep Power
    469
    There will be more disruption when you are FORCED to use 2012 later this year.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 26th May 2012, 11:42 AM
  2. Upgrade from 2003 to 2008R2 with Exchange 2003
    By Jamo in forum Windows Server 2008 R2
    Replies: 2
    Last Post: 11th July 2011, 02:06 PM
  3. Replies: 0
    Last Post: 10th November 2010, 08:51 AM
  4. upgrading from 2008 to 2008 r2 dc's
    By ful56_uk in forum Windows Server 2008 R2
    Replies: 8
    Last Post: 2nd February 2010, 02:13 PM
  5. Samsung R510 laptop - upgrade from VHP to VB
    By dgsmith in forum Windows
    Replies: 2
    Last Post: 28th May 2009, 11:52 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
  •