+ 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,372
    Thank Post
    477
    Thanked 339 Times in 287 Posts
    Rep Power
    158

    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
    4,002
    Thank Post
    983
    Thanked 477 Times in 398 Posts
    Blog Entries
    12
    Rep Power
    98
    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
    11
    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,372
    Thank Post
    477
    Thanked 339 Times in 287 Posts
    Rep Power
    158
    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,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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
    2,086
    Thank Post
    123
    Thanked 533 Times in 357 Posts
    Blog Entries
    2
    Rep Power
    336
    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 01:08 PM.

  7. #7

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,459
    Thank Post
    409
    Thanked 672 Times in 614 Posts
    Rep Power
    192
    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
    991
    Thank Post
    39
    Thanked 180 Times in 145 Posts
    Rep Power
    98
    I would wait and move to SQL 2012

  9. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    445
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    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,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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, 07:03 AM
  2. SQL 2008 Express or Standard?
    By Edu-IT in forum MIS Systems
    Replies: 5
    Last Post: 30th July 2010, 05: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, 10:37 PM
  4. Setting up windows 7 and server 2008 standard
    By Aaron in forum Windows 7
    Replies: 8
    Last Post: 2nd February 2010, 01: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, 05: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
  •