No upgrade path from MCSA:SQL Server 2008 to MCSE:Data Platform [2012]? RRS feed

  • Question

  • I'm wanting to grab myself a bunch of SQL Server 2008 certifications, then afterwards SQL Server 2012 certifications. (I have a SQL Server 2000 exam looking lonely on my transcript).

    I've therefore been reading about the upgrade exams that can be used to upgrade the 2008 certifications to 2012 certifications.

    I note from the Microsoft website that the three MCITP:Database Administrator 2008, MCITP:Database Developer 2008 and MCITP:Business Intelligence 2008 certifications will cease to be offered after July 31 2013 (PRO 70-450, PRO 70-451,PRO 70-452 exams retiring, plus MCTS 70-433 exam retiring too).

    I also note that these 3 certifications are the only SQL Server 2008 certifications that can be counted in the upgrade path to MCSE:Data Platform [2012] or MCSE:Business Intelligence [2012] certifications.

    So what happens after 31 July 2013?

    The only remaining SQL Server 2008 exams will be 70-432 and 70-448. Passing both exams earn the MCSA:SQL server 2008 certification. But this can't be used as credit towards the MCSE:Data Platform [2012].

    The MCSA: SQL Server 2008 certification can be upgraded to MCSA:SQL Server 2012 certification with the 70-457 and 70-458 transition exams. Which is great. But these transition exams only count in the MCSE upgrade pathway if combined with one of the three, soon to be retired, SQL MCITP certifications. Which is not so great.

    So there isn't an upgrade pathway from MCSA: SQL Server 2008 to MCSE:Data Platform [2012] after July 31 2013.

    I'm therefore presuming:

    A) Study for the MCSA:SQL Server 2008 (exams 70-432 & 70-448).

    B) Forget about the 2 transition exams from 2008 to 2012 (70-457 & 7-457). Even though there's only 2 exams they can't be used towards MCSE.

    c) Study the 3 MCSA: SQL Server 2012 exams instead (70-461, 70-462 & 70-463). Although that's 3 exams instead of 2 - they will count towards the MCSE certification.

    In short - if I studied for the MCSA:SQL Server 2008 and then upgraded that certification to MCSA:SQL Server 2012, I'd of studied 4 SQL exams and none of them could be used towards the MCSE.

    As best I can tell I'd still have to study a further 5 exams to gain the MCSE - the first 3 of which would be 70-461, 70-462 & 70-463 - which would get me the MCSA:SQL Server 2012 again.

    Please tell me I've misread something somewhere and am incorrect. It almost seems Microsoft is discouraging us from taking SQL Server 2008 exams in favour of SQL 2012 exams. Surely not eh? :P

    - DataCruncher

    Friday, February 8, 2013 10:03 AM


  • The MCSE: Data Platform certification comprises of exams 461, 462, 463, 464 and 465.  The first three exams (461, 462, 463) are the same exams required for the MCSA: SQL Server 2012 certification.  The other two (464 and 465) take the MCSA to MCSE i.e. if you already have the MCSA: SQL Server 2012 certification, all you need to pass are exams 464 and 465 to gain the MCSE: Data Platform certification.  Given this, if you hold ANY SQL Server 2008 MCTS certification, you can upgrade to MCSE: Data Platform by doing the following exams (as per http://www.microsoft.com/learning/en/us/mcsa-sql-certification.aspx):

    457: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1

    458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

    which will give you MCSA: SQL Server 2012 (Exams 457 and 458 are the equivalent of 461, 462 and 463.) and then do the following exams to take you to MCSE: Data Platform:

    464: Developing Microsoft SQL Server 2012 Databases

    465: Designing Database Solutions for SQL Server 2012

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    • Edited by Mr. Wharty Friday, February 8, 2013 10:41 AM
    • Marked as answer by DataCruncher Sunday, February 10, 2013 11:16 AM
    Friday, February 8, 2013 10:39 AM

All replies