When upgrading BizTalk 2006 R2 with SQL Server 2005 + SP3 server to BizTalk 2009. During the upgrading/installation, you might get the following error:
Invalid object name ‘BizTalkMgmtDb.dbo.bts_orchestration’.
Reason could be if you have different names to the default BizTalk DBs names.
But, If you restart SQL Server services and stop all BizTalk services except EntSSO service and Repair the BizTalk 2009 installation, it completes with no errors.
Also, When you upgrade any accelerators (like RosettaNET, SWIFT etc) with different DB Names, you will encounter similar error. but if you repair the installation it will resolve the error and install successfully.