Upgrading BizTalk Server 2006 to R2


Today I upgraded a BizTalk Server 2006 Development Machine to BizTalk Server R2 for one of my customers. How one can do upgrade this upgrade? Well download installation and upgrade guides from Microsoft for starters. Then gather information about your system. System BizTalk Server 2006 Enterprise Edition is running on is Windows 2003 Server R2 standard edition with SP2, Intel Xeon 1.80 Ghz, 2.00 Gb RAM (Virtualized VMWare). Everything is configured from SSO to BAM Portal. In documentation provided by Microsoft one can find how to upgrade from and to which edition of BizTalk Server 2006 R2. Upgrade from Enterprise BizTalk Server 2006 Edition to BizTalk Server 2006 R2 Developer Edition is possible even though not supported!

First thing to do is stop all host instances and following services: BizTalk Base EDI Service, Rule Engine Update Service, and World Wide Web Publishing Service. Next backup all databases, here is the complete list:

SQL Server databases: master, MSDB
BizTalk Server databases: BAMArchive, BAMPrimaryImport, BAMStarSchema, BizTalkDTADb, BizTalkEDIDb, BizTalkHwsDb, BizTalkMgmtDb, BizTalkMsgBoxDb, BizTalkRuleEngineDb, TPM
SQL Server Analysis Services databases: BizTalkAnalysisDb, BAMAnalysis

After this the upgrade can start.

One can check version of BizTalk installed through this query:

SELECT * FROM BizTalkDBVersion


HKEY_LOCAL_MACHINESOFTWAREMicrosoftBizTalk Server3.0ProductEdition

I queried the BizTalk Management Database and had the following results:

DatabaseMajor, DatabaseMinor, DatabaseBuildNumber, DatabaseRevision, ProductMajor, ProductMinor, ProductBuildNumber, ProductRevision, ProductLanguage, Description

First Record (old installation):
Second Record (upgrade): Server 2006

After upgrade I ran Microsoft Update and I had to install SP1 for .NET 2.0 and 3.0 Framework. Last thing I am going to do now is verify if all my solutions still work.


Author: Steef-Jan Wiggers

Steef-Jan Wiggers is all in on Microsoft Azure, Integration, and Data Science. He has over 15 years’ experience in a wide variety of scenarios such as custom .NET solution development, overseeing large enterprise integrations, building web services, managing projects, designing web services, experimenting with data, SQL Server database administration, and consulting. Steef-Jan loves challenges in the Microsoft playing field combining it with his domain knowledge in energy, utility, banking, insurance, healthcare, agriculture, (local) government, bio-sciences, retail, travel, and logistics. He is very active in the community as a blogger, TechNet Wiki author, book author, and global public speaker. For these efforts, Microsoft has recognized him a Microsoft MVP for the past 8 years.


Back to Top