Monday, August 25, 2014

BizTalk 2013 R2 database migration from SQL 2012 to 2014

On my Virtual PC which had BizTalk 2013 R2 configured with SQL 2012 as database server I thought of installing SQL 2014 and try using the new features of Column Store and see how it can help run the Integrations faster.
In this post I will show you how I migrated my existing BizTalk databases from SQL 2012 to 2014 which is installed on the machine.


  •  Take Backup of all BizTalk databases from SQL 2012 and Restore it on to SQL 2014.
  •  Create Scripts of all BizTalk SQL Jobs from SQL 2012 and execute it on to SQL 2014.
  •  Create Scripts of all BizTalk SQL Logins from SQL 2012 and execute it on to SQL 2014.
  •  Update the SampleUpdateInfo.xml file found in the following location with info of the current and the new SQL Server. For me current SQL 2012 was on KIWI server and the New SQL 2014 Server is on KIWI\SQL14.
    C:\Program Files (x86)\Microsoft BizTalk Server 2010\Bins32\Schema\Restore
  •  Run the UpdateDatabase.vbs file which is found in the same folder which updates the Server references in the tables on the new SQL Server.
  •  Run the UpdateRegistry.vbs file which is found in the same folder which updates the System Registry key references on the Server.
  •  Finally I went into BizTalk Admin Console to check if the references were updated successfully and yes it did update everything.

Finally I would give credit to the following old Microsoft document which still holds true for  the new versions of BizTalk\SQL Server ;).
How to Restore Your Databases



11 comments:

  1. Biztalk Admin Online Training, http://www.21cssindia.com/courses/biztalk-admin-online-training-220.html Biztalk Admin Online Training, Biztalk Admin Training, Biztalk Admin, Biztalk Admin Online Training| Biztalk Admin Training| Biztalk Admin| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete
  2. Good guide for sql 2012 to sql 2014. This is more helpful for me.

    Microsoft Access to SQL Server Migration

    ReplyDelete
  3. the article provided by you is very nice and it is very helpful to know about thebiztalk ..i found an article related to you..once you can check it out
    Biztalk Online Training Hyderabad,bangalore

    ReplyDelete
  4. Really Good blog post.provided a helpful information.I hope that you will post more updates like this salesforce Online course Hyderabad

    ReplyDelete
  5. It is very good and useful .Learned a lot of new things from your post!

    Good creation ,thanks for good info BizTalk Online Training Hyderabad

    ReplyDelete
  6. It's so nice article thank you for sharing a valuable content
    Sql Server dba online training

    ReplyDelete