+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, Sending SQL 2012 data to Capita in Technical; We need to send our data into Capita for further investigation and moved over to SQL 2012 with the Autumn ...
  1. #1

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21

    Sending SQL 2012 data to Capita

    We need to send our data into Capita for further investigation and moved over to SQL 2012 with the Autumn release. We sent in our data and received an e-mail back saying it couldn't be imported (later discovered that it was because we are using 2012 and the service desk are using 2008 R2), but have now been asked to take a backup that is compatible with 2008 R2 so Capita can import it.

    Is that even possible?

  2. #2
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Not now your on SQL2012! I don't believe SQL is backwards compatible.

    As SQL2012 is supported for SIMS and FMS from the SIMS Autumn release (as documented in the Capita Technical Roadmap), it's Capita's responsibility to get a SQL2012 instance set up to attach your data to. You won't be the only school who's made the move so they could have more SQL2012 backups being sent it for investigation.

    If SQL2012 was not yet supported for SIMS, I could understand Carita's response...
    Last edited by Rawns; 5th February 2013 at 02:07 PM.

  3. #3

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21
    That's what I thought...

  4. #4
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,765
    Thank Post
    898
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    87
    Only Capita could give a response like that haha

  5. #5

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21
    This response is better:

    "Thanks for your update, at the moment we do not support SQL2012, however we will be able to in the next SIMS release, in the meantime I will get the data loaded by a colleague with SQL2012, will email you when our analysts have checked the data."

    At least someone there is able to load our data!

  6. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by adamf View Post
    "Thanks for your update, at the moment we do not support SQL2012..."
    I'd respond to that update with "Your Technical road map states otherwise." and then e-mail Jon Wood directly asking what they think they are playing at!

  7. Thanks to Rawns from:

    vikpaw (10th February 2013)

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    ...something’s never change…

  9. #8

    Join Date
    Sep 2007
    Posts
    8
    Thank Post
    0
    Thanked 3 Times in 1 Post
    Rep Power
    0
    Just wondering if Capita managed to resolve this as we have just been told the same.

    **Replication steps confirm data is on 2012. You cannot downgrade SQL databases, and we support 2012**
    Dataset Backup is not correct. while restoring on SQL Server 2k8 R2 Version
    it gives error.
    Provide correct dataset backup for SQL Server 2k8 R2 Version


    Thanks

  10. #9
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by coconurtaler View Post
    Just wondering if Capita managed to resolve this as we have just been told the same.

    **Replication steps confirm data is on 2012. You cannot downgrade SQL databases, and we support 2012**
    Dataset Backup is not correct. while restoring on SQL Server 2k8 R2 Version
    it gives error.
    Provide correct dataset backup for SQL Server 2k8 R2 Version


    Thanks
    This is crazy!!! The fact that they ask you to provide a downgraded version for SQL 2008 R2 shows they lack major knowledge in the product they "support" as you cannot downgrade a database!

    As in my previous post, go back to them saying Capita OFFICIALLY support SIMS on Microsoft SQL Server 2012 now and therefore they should have a suitable test environment for when customers raise case logs and send their data in for investigation. Also point them to their own technical roadmap and then e-mail Jon Wood directly to complain!

    Might also be making @PhilNeal aware of this to see if he can offer any ideas as to why this is seems to keep happening?
    Last edited by Rawns; 28th May 2013 at 11:16 AM.

  11. #10

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    The word 'support' obviously has a different meaning to Capita...

  12. #11
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,214
    Thank Post
    454
    Thanked 176 Times in 173 Posts
    Blog Entries
    3
    Rep Power
    64
    Quote Originally Posted by Rawns View Post
    This is crazy!!! The fact that they ask you to provide a downgraded version for SQL 2008 R2 shows they lack major knowledge in the product they "support" as you cannot downgrade a database!
    The funny thing is if that message came from support, that's even stated in the message coconurtaler posted
    Last edited by Cache; 28th May 2013 at 12:00 PM.

  13. #12
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Would be interested to know what the outcome was regarding @adamf's post?

  14. #13

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I will look into this.

  15. Thanks to PhilNeal from:

    Rawns (28th May 2013)

  16. #14

    Join Date
    Sep 2007
    Posts
    8
    Thank Post
    0
    Thanked 3 Times in 1 Post
    Rep Power
    0
    Well I emailed them back, pointing out that SQL 2012 is not backward compatible with 2008 R2 so I can't provide a backup that will restore onto 2008 R2, they will need to restore onto 2012. I also pointed out that they have supported SQL 2012 since the Autumn 2012 release.

    Got this response.

    Many thanks for your reponse, I will email the developers to work on the 2012 SQL Server, rather than work on 2008, you are correct that we certaily do support SQL2012

    You would think they should know that rather than have a customer point it out to them.

  17. 3 Thanks to coconurtaler:

    Rawns (28th May 2013), skunk (29th May 2013), zag (28th May 2013)

  18. #15

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I can confirm that we've looked into this and ensured that the advice won't be repeated.
    @coconurtaler unfortunately we have to employ humans that make mistakes occasionally!

  19. Thanks to PhilNeal from:

    Rawns (28th May 2013)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 0
    Last Post: 27th July 2010, 02:12 PM
  2. Replies: 2
    Last Post: 23rd April 2010, 11:50 AM
  3. [SIMS] Sending data to Capita
    By matt40k in forum MIS Systems
    Replies: 10
    Last Post: 11th June 2009, 02:21 PM
  4. Send data to C++ app
    By Jackd in forum Coding
    Replies: 12
    Last Post: 29th August 2008, 02:26 PM
  5. Sending files to Capita via FTP (or not).
    By Heebeejeebee in forum MIS Systems
    Replies: 18
    Last Post: 22nd November 2007, 11:30 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
  •