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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial