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

Or

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0\ProductEdition

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): 3.5.0.0.3.5.1602.0.1033.RTM
Second Record (upgrade): 3.6.1.0.3.6.1404.0.1033.BizTalk 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.

Technorati:

Comments

Anonymous said…
Hi Steef-Jan, How did you go about upgrading from the Enterprise Edition to the Developer Edition? The installation process doesn't allow me to do it. Thx
6:59 AM
Post a Comment

Popular posts from this blog

DTAP Strategy: Pricing and Licensing

Image
To implement BizTalk solutions it is a good practice to have an DTAP environment in place. DTAP stands for Development, Test, Acceptance and Production. Development and test environments are equal (mirrored) and same account for acceptance and production. Deploying DTAP environments is easy, because there are many factors influencing outcome of DTAP. One factor is pricing and licensing costs. BizTalk is available in different editions and since BizTalk depends on operating system and database there are some configuration options to. Here is an overview of possible configurations for DTAP environments, hence there is a nice BizTalk Feature Dependency Matrix. Besides features, there are non-functional requirements to reckon with like fail-over, availability and scalability. On Microsoft Pricing and Licensing FAQ section of BizTalk I found this on non functional side. In a large BizTalk Server 2006 R2 deployment, two key considerations ensure redundancy in all areas of the architect
Read more

Table Operation on Oracle 11g XE with OracleDbBinding

Image
Last year I did a post on table operations on SQL Server Table with WCF-SQL Adapter from BizTalk on SQL. Now I like to do similar thing on table in Oracle 11g Express database using the Oracle Binding from BizTalk Adapter Pack 2010. Oracle 11g Express Edition is available through OTN. For downloading software you will need to have an account! It is important that when accessing Oracle you have appropriate client installed. This can sometimes be a hassle if you do not know, which client you need. When you trying to connect to Oracle you will get error messages like: Connecting to the LOB system has failed. Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.. This can be pretty annoying, but there is documentation that can help you going the right direction. In installation documentation I read that supported versions are: Oracle d
Read more

BizTalk Server 2010 Exam : How to prepare?

Image
In previous post I yesterday I wrote that new BizTalk 2010 exam is out. And you may figure how to prepare as in preparation material nothing is mentioned.Let’s look at what skills are measured. In a nutshell these topics are: Configuring messaging architecture (setup, manage ports, configure adapters, implement messaging solutions); Developing BizTalk Artefacts (building orchestrations, create schema’s, maps and pipelines); Debugging and Exception Handling (debug orchestrations, validate and test artefacts like schema’s, maps, pipelines); Integrating Web Services and Windows Communication Foundation (WCF) Services (WCF Adapters); Implementing Extended Capabilities (this is the BAM, BRE, RFID and EDI part); Deploying, Tracking, and Supporting a BizTalk Solution (Installation in different kinds of scenario’s, deployment of applications, bindings). You can find a lot of resources that can help in preparation through BizTalk Development Center like the BizTalk tutorials for EA
Read more