Schemas stored in BiztalkMgmt DB table
Hello,
In the Biztalk Admin Console , i can go to any schema, doubleclk and select Schema View. This shows me the actual schema.
Any idea  from which BiztalkManagement DB table, the schema view  is stored in?
My original thought was this would come from the gaced assembly?
please let me  know
regr,
BM
February 15th, 2015 7:44pm

Hi,

Full schema content is present in bt_XMLShare table of BizTalkMgmtDB with message type and schema ID.

Refer: BizTalkMgmtDB: All Table Details

Rachit

Free Windows Admin Tool Kit Click here and download it now
February 15th, 2015 10:37pm

Well, why are you asking this?  My advice: pretend that doesn't exist and don't ever think about using it.

The Schema content here vs the Assemblies is not documented.

Observation suggests the majority, perhaps all, runtime components use the Assembly content.  For any custom development, you should as well.

February 16th, 2015 9:52am

thanks boat seller..

this was just out of curiosity...

as per your answer, any schema changes to an xsd, - I might as well directly copy to the assembly GAC location, rather than going thru the deployment into Admin console?

Free Windows Admin Tool Kit Click here and download it now
February 16th, 2015 5:44pm

Well, why are you asking this?  My advice: pretend that doesn't exist and don't ever think about using it.

The Schema content here vs the Assemblies is not documented.

Observation suggests the majority, perhaps all, runtime components use the Assembly content.  For any custom development, you should as well.

  • Proposed as answer by Richard.Spice Monday, February 16, 2015 9:12 PM
February 16th, 2015 5:48pm

Ok, well, don't do that either.

The deployment methods for BizTalk, while frustrating at times, are well understood.  You should not be trying to sneak Assembly updates in through the GAC.

Work on an easy, scripted deployment for you app and use that.

Free Windows Admin Tool Kit Click here and download it now
February 17th, 2015 8:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics