Database changes in MDT 2012 and MDT 2012 Update 1

A few people have asked about the changes made in MDT 2012 and MDT 2012 Update 1 in regards to the MDT database.  There aren’t that many changes, but here they are:

  • MDT 2012 RTW
    • Removed obsolete properties for Lite Touch: SkipAppsOnUpgrade.
    • Added new properties for ConfigMgr 2012: SMSTSPreferredAdvertID, SMSTSUDAUsers, SMSTSAssignUsersMode.
    • Added one new property for all scenarios, OSDStateStorePath.
  • MDT 2012 Update 1
    • Removed obsolete properties for Lite Touch: BuildID, SkipDeploymentType, SkipBuild, SkipBitLockerDetails, SkipDestinationDisk.

If you have an existing database, no properties will be removed; the properties marked as “removed” above just don’t get created in new databases.

If you have an existing database, the properties marked as “added” above will automatically be added to your existing database.

Any customizations that you might have made to your database should be preserved.

Comments (6)
  1. Brian says:

    After upgrading from mdt 2012 to mdt 2012 update 1, the database tables in the mdt mmc console are empty, but when i browse the tables through sql express manager they are all still there. How do i bring them back into mdt 2012 update 1? Thanks.

  2. Matt says:

    Hi Michael,

    Have you got any best practice documentation for upgrading our MDT infrastructure from MDT 2010 Update 1 to MDT 2012 Update 1 to make the process as seamless as possible? We currently have 7 deployment servers running Server 2008 R2, WDS, WAIK and MDT 2010 Update 1. We are usink LDS's and we have a central MDT DB.

    Cheers, Matt

  3. Thorsten5 says:

    Hi, I'm currently in the process of upgrading from MDT 2010 Update 1 to MDT 2013. I would expect to see at least the property OSDStateStorePath in my upgraded database. I did check all of the tables (Settings, Descriptions), but I cannot find it. Which
    table is that being added to ? And what can I do if it is not there ? MDT 2013 is working ok , but I'm concerned that we might run into problems going forward. Yes, I did run the "Upgrade DeploymentShare" task. Thanks Thorsten

  4. showbox says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    Latest version of Showbox App download for all android smart phones and tablets. - It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    Showbox for PC articles:
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn't charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android.
    The above all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on 'Obscure sources'.

  5. aw says:

    hai, I just want to tell you that I am just very new to blogs and seriously loved this website. More than likely I’m planning to bookmark your blog post .
    You amazingly come with really good posts. Thanks a lot for sharing your blog Microsoft.

Comments are closed.

Skip to main content