Hey All,

I have a scenario where I need to migrate the existing BizTalk SQL server to New Server. What would be the easiest and simplest way to achieve this ?

We are planning to do this activity on UAT-test environment only.

Thanks

AP

There is a supported procedure for moving the BizTalk databases documented at MSDN/TechNet which you can find here:

https://msdn.microsoft.com/en-us/library/aa559835.aspx?f=255&MSPPError=-2147217396

This is the only way to move the databases.  Do not follow any other steps or guidance.

Just be sure to follow all of the steps and read all of the content first.

• Edited by Johns-305 [boatseller]MVP, Moderator 9 hours 27 minutes ago
• Marked as answer by AkhPatel 9 hours 15 minutes ago

Hello

The same discussion from the below thread.

https://social.msdn.microsoft.com/Forums/en-US/c0af5e9e-41e0-45b3-935c-b99715b74889/how-to-migrate-biztalk-database-from-one-box-to-other?forum=biztalkgeneral

Cheers

Hi,

Please look into the some related threads,

How to migrate BizTalk database from One Box to Other

Is it required to migrate parties also after database migration?

There is a supported procedure for moving the BizTalk databases documented at MSDN/TechNet which you can find here:

https://msdn.microsoft.com/en-us/library/aa559835.aspx?f=255&MSPPError=-2147217396

This is the only way to move the databases.  Do not follow any other steps or guidance.

Just be sure to follow all of the steps and read all of the content first.

• Edited by Johns-305 [boatseller]MVP, Moderator Tuesday, August 25, 2015 9:37 PM
• Marked as answer by AkhPatel Tuesday, August 25, 2015 9:48 PM

There is a supported procedure for moving the BizTalk databases documented at MSDN/TechNet which you can find here:

https://msdn.microsoft.com/en-us/library/aa559835.aspx?f=255&MSPPError=-2147217396

This is the only way to move the databases.  Do not follow any other steps or guidance.

Just be sure to follow all of the steps and read all of the content first.

• Edited by Johns-305 [boatseller]MVP, Moderator Tuesday, August 25, 2015 9:37 PM
• Marked as answer by AkhPatel Tuesday, August 25, 2015 9:48 PM

There is a supported procedure for moving the BizTalk databases documented at MSDN/TechNet which you can find here:

https://msdn.microsoft.com/en-us/library/aa559835.aspx?f=255&MSPPError=-2147217396

This is the only way to move the databases.  Do not follow any other steps or guidance.

Just be sure to follow all of the steps and read all of the content first.

• Edited by Johns-305 [boatseller]MVP, Moderator Tuesday, August 25, 2015 9:37 PM
• Marked as answer by BTSAAkhil Tuesday, August 25, 2015 9:48 PM