+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Upgrade SQL 2008 Express to FULL 2008 R2 Standard in Technical; I am about to upgrade our SIMS install from SQL Express to SQL Full prior to moving the whole lot ...
  1. #1

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,091
    Thank Post
    403
    Thanked 310 Times in 262 Posts
    Rep Power
    152

    Upgrade SQL 2008 Express to FULL 2008 R2 Standard

    I am about to upgrade our SIMS install from SQL Express to SQL Full prior to moving the whole lot to a new Server. Not being a SQL person I wanted to know if this will work for SIMS just by doing a normal upgrade of SQL. Do I have to do anything special with SIMS DB before doing the upgrade?

    Any pitfalls or other things you guys can point out would be most welcome.

  2. #2
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    I did this for sharepoint recently and it was a simple case of loading the 2008 R2 installer and clicking upgrade existing install.

    Worked fine with all the permissions and stuff.

  3. #3
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    If you're moving to a new SIMS Server, the DB will be quite happy to DB[un]Attach[ed] from the SQL Express instance and DB[re]Attach[ed] to the new instance on the new server. There's no need to upgrade SQL Express to Full before migrating.

    It's often a good idea to leave the existing SIMS box as is when migrating to a new server; it becomes an absolute 'known good' in case things go apex-over-base.

    What @zag says is perfectly correct if you're staying on the same box.

  4. #4

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,091
    Thank Post
    403
    Thanked 310 Times in 262 Posts
    Rep Power
    152
    Quote Originally Posted by NorthernSands View Post
    If you're moving to a new SIMS Server, the DB will be quite happy to DB[un]Attach[ed] from the SQL Express instance and DB[re]Attach[ed] to the new instance on the new server. There's no need to upgrade SQL Express to Full before migrating.

    It's often a good idea to leave the existing SIMS box as is when migrating to a new server; it becomes an absolute 'known good' in case things go apex-over-base.

    What @zag says is perfectly correct if you're staying on the same box.
    The idea was to move to SQL Full on the current box as we are getting too big for SQL Express and users are getting frustrated with it and then migrate to the new box over the summer holidays.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I'd prefer to wait then move direct to a new box so you do have a working system as a backup.

    If you do do it in situ, take db backups before hand of course, and ideally, run dbattach to detach the db and then reattach it to same server/version/instance, so all users / logins are stored in the db, should anything go crazy.

  6. #6

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Quote Originally Posted by vikpaw View Post
    I'd prefer to wait then move direct to a new box so you do have a working system as a backup.

    If you do do it in situ, take db backups before hand of course, and ideally, run dbattach to detach the db and then reattach it to same server/version/instance, so all users / logins are stored in the db, should anything go crazy.
    Excellent suggestion. Worst case is you keep using your existing (working!) system.

    I've never liked the idea of in-situ upgrades (based on nothing more than bad experiences!!!), even though I'm sure these upgrades are tried and tested.
    Last edited by jinnantonnixx; 10th May 2011 at 12:08 PM.

  7. #7

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,114
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    We are moving from SQL 2008 Express to either SQL 2008 or SQL 2008 R2. What would people recommend? Is SIMS okay on SQL2008 R2 now?

  8. #8
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    928
    Thank Post
    35
    Thanked 160 Times in 129 Posts
    Rep Power
    93
    I would wait and move to SQL 2012

  9. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Quote Originally Posted by Mcshammer_dj View Post
    I would wait and move to SQL 2012
    Bang on - SQL2012 support is from the next upgrade for SIMS and FMS although you'll have to wait until September for Discover (unless you're using SOLUS 3 an on v 3.6)

  10. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Using SQL 2012 for some other services and it's nice. Even just the ease of closing down unused query windows is such a time saver especially when working remotely.

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. SQL 2008 Express or Standard?
    By Edu-IT in forum MIS Systems
    Replies: 5
    Last Post: 30th July 2010, 04:30 PM
  3. [For Sale] SQL 2008 Standard plus 5 User Cals
    By FN-GM in forum Classified Adverts
    Replies: 4
    Last Post: 9th May 2010, 09:37 PM
  4. Setting up windows 7 and server 2008 standard
    By Aaron in forum Windows 7
    Replies: 8
    Last Post: 2nd February 2010, 12:23 PM
  5. SIMS SQL upgrade. To Express or not to Express?
    By woody in forum MIS Systems
    Replies: 5
    Last Post: 16th October 2007, 04:34 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
  •