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 ...
9th May 2011, 08:32 PM #1
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.
10th May 2011, 10:34 AM #2
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.
10th May 2011, 11:25 AM #3
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.
10th May 2011, 11:44 AM #4
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.
Originally Posted by NorthernSands
10th May 2011, 12:56 PM #5
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.
10th May 2011, 01:06 PM #6
Excellent suggestion. Worst case is you keep using your existing (working!) system.
Originally Posted by vikpaw
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.
27th June 2013, 04:23 PM #7
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?
27th June 2013, 04:24 PM #8
I would wait and move to SQL 2012
27th June 2013, 08:17 PM #9
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)
Originally Posted by Mcshammer_dj
29th June 2013, 08:46 PM #10
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.
By Kamran7860 in forum Virtual Learning Platforms
Last Post: 23rd November 2010, 07:03 AM
By Edu-IT in forum MIS Systems
Last Post: 30th July 2010, 05:30 PM
By FN-GM in forum Classified Adverts
Last Post: 9th May 2010, 10:37 PM
By Aaron in forum Windows 7
Last Post: 2nd February 2010, 01:23 PM
By woody in forum MIS Systems
Last Post: 16th October 2007, 05:34 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)