SCCM 2012 - Migrating approved software updates from WSUS to ConfigMgr 2012

If you are planning to use SCCM 2012 patching and you have WSUS you need to find a way to export all approved patch setting WSUS 3.X server.

We need to connect to the WSUS SQL database (WID or SQL), export all ArticleIDs of the approved updates from the SUSDB database, match those exported ArticleID’s with the synced Software Updates in Configuration Manager and export the UpdateID’s and add the updates with the exported UpdateID’s to a Software Update List in Configuration Manager 2007 or in this case Update Group in Configuration Manager 2012.

For this kind of procedure I suggest to view the following tutorial/article: