+ Post New Thread
Results 1 to 4 of 4
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?...
  1. #1

    Join Date
    Aug 2011
    Location
    Bristol
    Posts
    21
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    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?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    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.

  3. #3

    Join Date
    Aug 2011
    Location
    Bristol
    Posts
    21
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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 (?)

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Anyone having problems with registers 2013 Spring?
    By ConradJones in forum MIS Systems
    Replies: 3
    Last Post: 24th May 2013, 06:11 PM
  2. [SIMS] Anyone using Windows 8 and Office 2013 with Sims yet?
    By Kyle in forum MIS Systems
    Replies: 11
    Last Post: 7th February 2013, 01:51 PM
  3. Anyone use Macs on a Windows Domain in Somerset?
    By Admiral208 in forum South West Grid for Learning (SWGfL)
    Replies: 3
    Last Post: 30th January 2012, 10:24 AM
  4. Has anyone used ophcrack on a server?
    By dolmandj in forum Network and Classroom Management
    Replies: 4
    Last Post: 24th March 2009, 10:17 AM
  5. Replies: 8
    Last Post: 30th October 2007, 02:13 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
  •