Copy data from one BizTalkMgmtDb to another BizTalkMgmtDb RRS feed

  • Question

  • Hi Guys,

    I have lost SSODB master secret key and I reconfigure BizTalkDB again.

    My all applications are stored in my old BizTalkMgmtDB.

    Now I want that I get those applications in my new BizTalkGroup without importing MSI.

    Can I done it through copying the data from old BizTalkMgmtDB to new BizTalkMgmt through sql query ?

    Is any problem with this approach.

    Please suggest me the best approach.


    Thursday, September 14, 2017 6:51 AM

All replies

  • Why do you want to avoid the import ? Export MSI, bindings is the supported way... ..

    Being SQL you can ofcourse copy stuff across but the information is likely secured through the SSO and till you can crack/break that (the import extracts this in an clear fashion) copying from one DB to another might not get you any benefits..


    Thursday, September 14, 2017 8:53 AM
  • The best and only approach is to reinstall the Applications using your normal deployment process.
    Thursday, September 14, 2017 1:38 PM