Examining the BAM database infrastructure

As impressive as all of this is so far (and recall that we're only scratching the surface), the real amazing part of it is the infrastructure which is automatically created and deployed for us.

BAM tables

If we open SQL Server Management Studio and look in the BAMPrimaryImport database, we can see that the following tables were created for our tracking solution:

  • bam_Purchase Orders_Active
  • bam_Purchase Orders_ActiveRelationships
  • bam_Purchase Orders_Completed
  • bam_Purchase Orders_CompletedRelationships
  • bam_Purchase Orders_Continuations

These tables hold the raw BAM data that is moved here by the BizTalk engine as it cleans out the message box and DTA databases. This also means that if a BizTalk environment is overloaded, ...

Get Microsoft BizTalk Server 2010 Patterns now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.