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 ...
5th February 2013, 01:49 PM #1
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?
5th February 2013, 02:05 PM #2
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.
5th February 2013, 02:16 PM #3
5th February 2013, 02:19 PM #4
Only Capita could give a response like that haha
5th February 2013, 03:09 PM #5
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!
5th February 2013, 03:11 PM #6
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!
Originally Posted by adamf
Thanks to Rawns from:
vikpaw (10th February 2013)
5th February 2013, 09:03 PM #7
...something’s never change…
28th May 2013, 10:08 AM #8
- Rep Power
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
28th May 2013, 10:33 AM #9
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!
Originally Posted by coconurtaler
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.
28th May 2013, 10:49 AM #10
The word 'support' obviously has a different meaning to Capita...
28th May 2013, 11:58 AM #11
The funny thing is if that message came from support, that's even stated in the message coconurtaler posted
Originally Posted by Rawns
Last edited by Cache; 28th May 2013 at 12:00 PM.
28th May 2013, 12:06 PM #12
Would be interested to know what the outcome was regarding @adamf's post?
28th May 2013, 12:18 PM #13
28th May 2013, 12:46 PM #14
- Rep Power
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.
3 Thanks to coconurtaler:
Rawns (28th May 2013), skunk (29th May 2013), zag (28th May 2013)
28th May 2013, 05:30 PM #15
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!
Last Post: 27th July 2010, 02:12 PM
By pete in forum MIS Systems
Last Post: 23rd April 2010, 11:50 AM
By matt40k in forum MIS Systems
Last Post: 11th June 2009, 02:21 PM
Last Post: 29th August 2008, 02:26 PM
By Heebeejeebee in forum MIS Systems
Last Post: 22nd November 2007, 11:30 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)