Many times companies run a number of BizTalk instances on different servers. For example development, test and production servers. Especially large companies can have a lot of instances and environments running at the same time. For various reasons you’re sometimes unable to determine what exact version you’re looking at. Or you just want to know if a certain service pack is installed.
I have read about people with similar problems in the BizTalk newsgroups. I recently encountered this problem too when I wanted to write a little helper class that determines which BizTalk version was installed. I knew that there is a BizTalk version number stored in the registry. The ‘ProductVersion’ key located in ‘HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0’ contains this information. The real problem was however how to match this number to a BizTalk version or Service Pack. After searching the net for a long time I decided to make a list myself. I was lucky that I had been to lazy to clean up my harddisk and delete old Biztalk 2004 vpc’s.
Here is the list:
|Product name||Service pack||Version number|
|BizTalk Server 2004||–||3.0.4902.0|
|BizTalk Server 2004||SP1||3.0.6070.0|
|BizTalk Server 2004||SP2||3.0.7405.0|
|BizTalk Server 2006||–||3.5.1602.0|
|BizTalk Server 2006 R2||–||3.6.1404.0|
I hope this will save some people a lot of time when they are in the same situation I was. Also there might be better ways that I don’t know (maybe ExplorerOM or WMI) to retrieve version information. Please drop a comment in that case.
There is also a version number stored in the BizTalk SQL Server databases. Most of the BizTalk databases contain a table ‘BizTalkDBVersion’ which contains besides the database version number also the product version number. The strange thing is that this number was not altered by the installation of the service packs (SP1 and SP2) on BizTalk 2004. After the upgrade the table still showed ‘3.0.4902.0’ as the product version number while the registry version number was changed.
I’ll try to keep this list updated when new versions or service packs are released.
There is an updated post on this topic. You can find it here.