How-to move BizTalk databases

Even though Microsoft has provided scripts to help moving BizTalk databases it's still a cumbersome.

For reference please see:

• Moving BizTalk Server Databases
• How to Restore Your Databases

I've created the script below to ease the pain after database restore. The script will:

1. create the config file used by UpdateDatabase.vbs and UpdateRegistry.vbs
2. stop all running host instances by stopping ESSO
3. update the BizTalk databases content
4. update the BizTalk frontend registry values
5. start ESSO
6. start all previously running host instances

Please note, the script will only work in the simple case of no BAM and all databases residing on one database server only.