How do I know what Version of BizTalk is on my server?

Posted by Paula DiTallo on Geeks with Blogs See other posts from Geeks with Blogs or by Paula DiTallo
Published on Tue, 02 Jul 2013 10:59:29 GMT Indexed on 2013/07/02 23:06 UTC
Read the original article Hit count: 562

Originally posted on: http://geekswithblogs.net/AskPaula/archive/2013/07/02/153324.aspx

There are 2 ways to do this, the first is to query the BizTalkDBVersion table:

use [BizTalkMgmtDb]
go

SELECT DatabaseMajor, DatabaseMinor,ProductBuildNumber, ProductRevision
FROM dbo.BizTalkDBVersion; 

Here is a list of possible BizTalk versions (CUP = cumulative update package, SP = service pack) :

BTS2004	3.0.4902.0
BTS2004SP1	3.0.6070.0
BTS2004SP2	3.0.7405.0
BTS2006	3.5.1602.0
BTS2006R2	3.6.1404.0
BTS2009	3.8.368.0
BTS2010	3.9.469.0
BTS2010CUP1	3.9.522.2
BTS2010CUP2	3.9.530.2
BTS2010CUP3	3.9.542.2
BTS2010CUP4	3.9.545.2
BTS2010CUP5	3.9.556.2
BTS2013	3.10.229.0

The second way is to follow these steps:

1. Click Start, click Run, type regedt32, and then click OK.
2. Once the window is up, navigate to  HKEY_LOCAL_MACHINE,  then SOFTWARE, then Microsoft, then BizTalk Server, and finally open 3.0.

This is what you should see:

© Geeks with Blogs or respective owner