How to access BizTalk Application Resources via BiztalkMgmtDB

There are 2 types of assemblies in BizTalk Applications

1. .Net Assemblies will be having the type System.BizTalk:Assembly

2. BizTalk Assemblies will be having the type ‘System.BizTalk:BizTalkAssembly’

Below is the query to access the biztalk resources programmatically in sql server, so that you can compare the assemblies across groups.

You cannot find out .net assembliies of type System.BizTalk:Assembly in bts_assembly table. This is the only place you could find this information

SELECT [luid] ‘AssemblyInfo’

FROM [BizTalkMgmtDb].[dbo].[adpl_sat] sat

WHERE sat.sdmtype IN ( ‘System.BizTalk:Assembly’,

‘System.BizTalk:BizTalkAssembly’ )

Please let me know if you have any questions.

Regards,

Chaitanya

SQL BLOGGING