Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (6MVP, Microsoft Partne)
  • When: 15 Jan 2012 10:15 AM
  • Last revision by (eMicrosoft Partne)
  • When: 25 Aug 2013 11:42 AM
  • Revisions: 34
  • Comments: 28
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  BizTalk Server - Determine Version and Edition

BizTalk Server - Determine Version and Edition

BizTalk Server - Determine Version and Edition

 

Table of Contents


Introduction

In a BizTalk Server environment where you are unaware of the exact version and/or edition you have a couple of options to find out what the exact version and edition is. The options are opening the registry and look in a certain key hive, querying the BizTalk Management database Version table or through using a PowerShell script.

Registry

In the following registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0 you can find version and edition.

Figure 1. Registry editor screenshot (click to enlarge).


Table 1: Product Names and Version Numbers
Product Name
Product Version Key
 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
 BizTalk Server 2006 R2 SP1
  3.6.1404.0
 BizTalk Server 2009  3.8.368.0
 BizTalk Server 2010
  3.9.469.0
 BizTalk Server 2013 (RTM)  3.10.229.0

There are four editions: Enterprise, Standard, Developer, and Branch.

Database Query

BizTalk version can be determined through executing the query displayed below:

USE [BizTalkMgmtDb]           
             
SELECT DatabaseMajor,DatabaseMinor,ProductBuildNumber, ProductRevision
FROM dbo.BizTalkDBVersion;

Result of this query will be one of the version numbers given in table 1.
In this query the BizTalkMgmtDb database is used, but every BizTalk database has the table BizTalkDbVersion.

PowerShell

The following PowerShell script from BizTalk MVP Randal van Splunteren can help you determine the BizTalk Version:

# Initialization of helper variables
# BizTalk version numbers
$versionBTS2004 = "3.0.4902.0"
$versionBTS2004SP1 = "3.0.6070.0"
$versionBTS2004SP2 = "3.0.7405.0"
$versionBTS2006 = "3.5.1602.0"
$versionBTS2006R2 = "3.6.1404.0"
$versionBTS2009 = "3.8.368.0"
$versionBTS2010 = "3.9.469.0"
# BizTalk version description
$descriptionBTS2004 = "BizTalk Server 2004"
$descriptionBTS2004SP1 = "BizTalk Server 2004 with service pack 1"
$descriptionBTS2004SP2 = "BizTalk Server 2004 with service pack 2"
$descriptionBTS2006 = "BizTalk Server 2006"
$descriptionBTS2006R2 = "BizTalk Server 2006 R2"
$descriptionBTS2006R2SP1 = "BizTalk Server 2006 R2 with service pack 1"
$descriptionBTS2009 = "BizTalk Server 2009"
$descriptionBTS2010 = "BizTalk Server 2010"
# Registry paths
$bizTalkRegistryPath = "HKLM:\SOFTWARE\Microsoft\BizTalk Server"
$biztalk2006SP1UninstallRegistryPath = 'HKLM:\SOFTWARE\Microsoft\Windows' `
    + '\CurrentVersion\Uninstall' `
    + '\Microsoft Biztalk Server 2006 R2 Service Pack 1 `[KB 974563`]'
$installedVersion = $null
# Check if BizTalk is installed:
if ((Test-Path $bizTalkRegistryPath) -eq $true)
{
    # Set location to BizTalk registry key
    Set-Location $bizTalkRegistryPath
    $key = Get-ChildItem
    # Get version number
    $productVersion = $key.GetValue("ProductVersion")
    switch ($productVersion)
    {
        $versionBTS2004 { $installedVersion = $descriptionBTS2004 }
        $versionBTS2004SP1 { $installedVersion = $descriptionBTS2004SP1 }
        $versionBTS2004SP2 { $installedVersion = $descriptionBTS2004SP2 }
        $versionBTS2006 { $installedVersion = $versionBTS2006 }
        $versionBTS2006R2
        {
            if ((Test-Path $biztalk2006SP1UninstallRegistryPath) -eq $false)
            {
                $installedVersion = $descriptionBTS2006R2
            }
            else { $installedVersion = $descriptionBTS2006R2SP1 }
        }
        $versionBTS2009 { $installedVersion = $descriptionBTS2009 }
        $versionBTS2010 { $installedVersion = $descriptionBTS2010 }
    }
}
if ($installedVersion -eq $null)
{
        Write-Host "BizTalk Server is not installed on this machine."
        Exit
}
Write-Host "BizTalk Server installation found on this machine."
Write-Host "Product version number: $productVersion"
Write-Host "Installed version: $installedVersion"

The code can also be downloaded from script center:

See Also

Read suggested related topics:

Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.

Other languages

This article is also available in the following language

, , , , , , , , , , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 5 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 25 Aug 2013 6:29 AM

    Maheshkumar S Tiwari edited Revision 31. Comment: minor edit

  • 25 Aug 2013 6:28 AM

    Maheshkumar S Tiwari edited Revision 30. Comment: minor edit

  • 16 Aug 2013 5:19 AM

    Steef-Jan Wiggers edited Revision 29. Comment: Formatting, minor edits

  • 16 Aug 2013 5:15 AM

    Steef-Jan Wiggers edited Revision 27. Comment: Added text to image

  • 7 Aug 2013 8:31 AM

    Sandro Pereira edited Revision 26. Comment: fixing code format

  • 5 Aug 2013 1:27 AM

    Steef-Jan Wiggers edited Revision 24. Comment: Minor edits

  • 1 Aug 2013 12:01 PM

    Steef-Jan Wiggers edited Revision 23. Comment: Added resource link

  • 17 Apr 2013 7:33 PM

    Richard Mueller edited Revision 21. Comment: Add line continuations to PowerShell code to make all of it visible

  • 17 Apr 2013 7:29 PM

    Richard Mueller edited Revision 20. Comment: Add carriage returns to PowerShell script so it is visible

  • 17 Apr 2013 7:13 PM

    Richard Mueller edited Revision 19. Comment: Replace RGB values with color names in HTML to restore  colors

Page 1 of 3 (23 items) 123
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 15 Jan 2012 10:17 AM

    Steef-Jan Wiggers edited Original. Comment: Added see also topic including links

  • Posted by
    on 15 Jan 2012 10:21 AM

    Steef-Jan Wiggers edited Revision 1. Comment: Added resource link

  • Posted by
    on 15 Jan 2012 10:35 AM

    Steef-Jan Wiggers edited Revision 2. Comment: Added topic

  • Posted by
    on 15 Jan 2012 10:36 AM

    Steef-Jan Wiggers edited Revision 3. Comment: Formatting table

  • Posted by
    on 15 Jan 2012 10:47 AM

    Steef-Jan Wiggers edited Revision 4. Comment: Added topics

  • Posted by
    on 15 Jan 2012 10:55 AM

    Steef-Jan Wiggers edited Revision 5. Comment: Added PowerShell Code

  • Posted by
    on 15 Jan 2012 10:56 AM

    Steef-Jan Wiggers edited Revision 6. Comment: Formatting

  • Posted by
    on 15 Jan 2012 10:57 AM

    Steef-Jan Wiggers edited Revision 7. Comment: Formatting

  • Posted by
    on 15 Jan 2012 10:58 AM

    Steef-Jan Wiggers edited Revision 8. Comment: Formatting

  • Posted by
    on 15 Jan 2012 11:00 AM

    Steef-Jan Wiggers edited Revision 9. Comment: Formatting

  • Posted by
    on 15 Jan 2012 11:54 AM

    Steef-Jan Wiggers edited Revision 10. Comment: Added resource link to script

  • Posted by
    on 16 Jan 2012 9:12 AM

    Nice one Steef-Jan!

  • Posted by
    on 4 Mar 2012 8:34 AM

    In the SQL query the table name was fallen of the screen. Also added some text about every BizTalk database having the BizTalkDbVersion table.

  • Posted by
    on 25 Mar 2012 11:40 PM

    Tord G.Nordahl edited Revision 13. Comment: Added reference to norwegian copy of the article

  • Posted by
    on 16 De