This isn’t a really deep how-to technical post, it’s more in the way of “note to self”.

Sample Database Diagram (relations do not actually exist in BizTalkMgmtDb, I added them for visualization).

 

Sample Cross-Reference Files.

 

Firing the BTSXRefImport tool

Actual tables in BizTalkMgmtDb and sample data selected from xref tables in general and IDXRef in particular.

Actual usage of cross reference id functoids

Links for BizTalk Cross Reference

  • MSDN
  • http://geekswithblogs.net/michaelstephenson/archive/2006/12/24/101995.aspx
  • http://geekswithblogs.net/michaelstephenson/archive/2008/09/21/125352.aspx
  • http://geekswithblogs.net/michaelstephenson/archive/2008/09/21/125353.aspx