MIS Systems Thread, anyone using Discover on SQL2012 with Spring 2013? in Technical; I know it's not officially supported until Summer 2013 release, but is anyone already running Discover on SQL2012? any issues?...
28th May 2013, 02:53 PM #1
- Rep Power
anyone using Discover on SQL2012 with Spring 2013?
I know it's not officially supported until Summer 2013 release, but is anyone already running Discover on SQL2012? any issues?
28th May 2013, 03:30 PM #2
If you've got SQL 2008 R2 installed and Discover created, you should be able to restore it onto SQL 2012, point Discover at the database on SQL 2012, however, I'd not recommend it.
At the moment the Discover MSI - like SOLUS3 doesn't support SQL 2012, the tool they use to deploy\upgrade the database doesn't support SQL2012 - the replacement that does support SQL2012 doesn't work on Windows XP or Windows Server 2003. So you'll be hoping that they do upgrade the tool otherwise when you next get an upgrade, you'll have to migrate the database to SQL 2008, upgrade it, then migrate it back. The problem is migrating database from a higher version of SQL (say SQL 2012) to a lower version (say SQL 2008) is, well, not very easy.
31st May 2013, 10:59 AM #3
- Rep Power
ah OK thanks.
I haven't yet tried it, but I take 'the Discover MSI - like SOLUS3 doesn't support SQL 2012' to mean that a fresh install, with already attached and functioning SQL2012 SIMS, will complain about an unsupported SQL and not allow the setup to continue.
and of course there's no detaching the Discover database from 2008 and re-attaching, a'la SIMS/FMS (?)
31st May 2013, 11:12 AM #4
Fresh installs will complain that it's not supported - I think - I know if you extract the actual MSI from the .exe, it'll connect and try, but it'll fail - I've tried that.
You can deattach\reattach or restore from sql2008, which would work, but if the next upgrade doesn't support SQL2012 you're stuffed. Discover needs to be the same version as SIMS - so they both have to be the summer 2013 or both autumn 2013 or both the spring 2014 or whatever. Thing is, it's not easy to restore onto a lower version of SQL - as in it's very, very, very hard. So you can't just unattach from SQL 2012, slap it on SQL2008 then upgrade, then move it back. It really is worth keep a SQL2008 instance just for Discover and SOLUS3 or just waiting a bit for them to support SQL2012 for discover.
So yes, you could do it, it's just going to be a ticking time bomb set to go off around the next upgrade which is summer holidays??
New versions of Office your ok to jump the gun, the rollback is ok, just wasted time, Windows, pretty much the same, server need a bit of thought and SQL you just don't risk as it can be a total nightmare as rollback normall involves dataloss.
By ConradJones in forum MIS Systems
Last Post: 24th May 2013, 06:11 PM
By Kyle in forum MIS Systems
Last Post: 7th February 2013, 01:51 PM
By Admiral208 in forum South West Grid for Learning (SWGfL)
Last Post: 30th January 2012, 10:24 AM
By dolmandj in forum Network and Classroom Management
Last Post: 24th March 2009, 10:17 AM
By mattx in forum Windows
Last Post: 30th October 2007, 02:13 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)