+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, SIMS on SQL2012 & Discover on SQL2008 in Technical; Has anyone got this setup working? I've been doing some internal testing here and so far have been unable to ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0

    SIMS on SQL2012 & Discover on SQL2008

    Has anyone got this setup working? I've been doing some internal testing here and so far have been unable to get the transfer between SIMS and Discover to work. I've tried all manor of things and even done a complete clean re-install of all aspects and no luck.

    It's not even like I can run the sync users, grant transfer rights, grant sync rights or create catalog commands as you can only specify a single SQL instance within the commands! Not a lot of use when SIMS is on a separate instance to Discover!

    Sometimes, Capita's idea of "supported" makes me laugh...

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    discover is not support on 2012 yet right?
    doesn't the migration of sims from 2008 to 2012 require some hard coded, irreversible changes to the db / structure?
    if so, then discover must be expecting things in the old school format.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,096
    Thank Post
    511
    Thanked 2,310 Times in 1,786 Posts
    Blog Entries
    24
    Rep Power
    803
    Hmm... This doesn't sound good. As this is what I was planning to do during Easter! If it doesn't work, it might force me to end up being on 2008 R2 for barely 6 months then.

  4. #4
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    I wouldn't mix and match those versions personally.

    Keep with SQL 2008, there is really no advantage to using the new one that I know of.

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,096
    Thank Post
    511
    Thanked 2,310 Times in 1,786 Posts
    Blog Entries
    24
    Rep Power
    803
    Quote Originally Posted by zag View Post
    I wouldn't mix and match those versions personally.

    Keep with SQL 2008, there is really no advantage to using the new one that I know of.
    Less hassle is the advantage. SQL Server 2008 R2 support ends after Summer 2014 release.

  6. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    discover is not support on 2012 yet right?
    doesn't the migration of sims from 2008 to 2012 require some hard coded, irreversible changes to the db / structure?
    if so, then discover must be expecting things in the old school format.
    No, but Capita have said that SIMS on 2012 and Discover on 2008 "should" work, however I am finding this is not really the case!

  7. #7
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    From the Spring Release note:

    SIMS 2013 Spring Release


    This release sees the commencement of support for Windows 8 and Windows Server 2012. SQL2012 is supported for SIMS and FMS releases only. Discover, SLG and SOLUS3 will be supported on SQL2012 from the Sims 2013 Summer release. A Migration utility will be provided alongside the SIMS 2013 Summer release to assist with the migrations.

  8. #8
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0
    That's referring to when Discover will be supported. At the S/W SOLUS3 Technical Seminar, Jon Wood stated that you can still sync SIMS .net and Discover even if SIMS is on SQL2012 and Discover is on SIMS2008 (which are both supported).

  9. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Quote Originally Posted by Rawns View Post
    That's referring to when Discover will be supported.
    I know, but a few of the posts since your OP had started to move the goalposts.

  10. #10

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,096
    Thank Post
    511
    Thanked 2,310 Times in 1,786 Posts
    Blog Entries
    24
    Rep Power
    803
    Quote Originally Posted by superfletch View Post
    I know, but a few of the posts since your OP had started to move the goalposts.
    No-one has said anything different to the OP that I can see?

  11. #11
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Quote Originally Posted by Rawns View Post
    Capita's idea of "supported" makes me laugh...
    Quote Originally Posted by vikpaw View Post
    discover is not support on 2012 yet right?
    That's how I read it.

  12. #12
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by superfletch View Post
    That's how I read it.
    Either @vikpaw did not read the title of my post correctly, or he was just generally asking if Discover was supported on SQL2012?

    I read it as a request of conformation that Discover is not supported on SQL2012...

  13. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Just typing out loud as it were. Confirmation is what I intended.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 26
    Last Post: 6th March 2013, 09:54 AM
  2. SIMS Document Server: slow response on client
    By msi in forum MIS Systems
    Replies: 2
    Last Post: 16th April 2012, 11:30 AM
  3. [SIMS] SIMS .net Examination Module hangs on submission
    By nLinked in forum MIS Systems
    Replies: 4
    Last Post: 10th February 2012, 11:09 PM
  4. [Pics] Another "Face" Discovered On Mars
    By DaveP in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 25th April 2011, 01:45 PM
  5. SIMS (Aug 2007) System Manager on Vista
    By enjay in forum MIS Systems
    Replies: 2
    Last Post: 3rd October 2007, 11:16 AM

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
  •