Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

we are planning to move biztalk database from one place to another as well as upgrade the sql server.

the initial database is in sql server 2008 R2 and target is sql server 2012. but the thing is that we have to set up database on another system, i tried to search it on msdn but they are providing reference to upgrade from 2005 to 2008 , or moving database from one server to another. do you think that will work in my case !!

i found this article. relating to upgrading as well as moving.. but this is quite older one.

how can i upgrade as well as move biztalk database from sql server 2008 R2 to sql server 2012 on a different system (side by side upgrade).

do i have to follow same steps as upgrading a normal database from sql server 2008R2 to sql server 2012 or some other one ??

share|improve this question
...and which version of Biztalk do you have? As far as I know, only Biztalk 2013+ supports SQL 2012, which is probably why there's no information about upgrading older versions of Biztalk to run on SQL 2012. – HopelessN00b Jul 31 '14 at 13:05
I am upgrading to biztalk 2013 as well. previously i was having biztalk 2006. – sameer Aug 1 '14 at 4:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.