BizTalk Server General - Change XSD-schema

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > September 2004 > Change XSD-schema





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Change XSD-schema
newbie

2004-09-02, 6:19 pm

How do I change the XSD-schema that should be used to generate the
XML-document in BizTalk2004?
Jeff Lynch

2004-09-02, 6:19 pm

I'm not sure I understand your question. If you want to revise a deployed
schema you must undeploy the existing schema and deploy the revised schema
(in your compiled assembly).

If this doesn't answer your question please explain exactly what you are
trying to accomplish and I'll give it another try.

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"newbie" <newbie@discussions.microsoft.com> wrote in message
news:3FB83557-93BB-4F40-B595-C9DA929F62A9@microsoft.com...
> How do I change the XSD-schema that should be used to generate the
> XML-document in BizTalk2004?



newbie

2004-09-02, 6:19 pm

Ok here is what I am trying to do. I have a XSD Schema already created. I
need to use this schema to generate an XML document from data in SQL Server
2000. How do I link an XSD Schema to a stored procedure, or something else to
plug in my data to generate an XML file through BizTalk 2004?

At the moment I'm using Add->Add Generated Items->...Add Adapter Wizard
select SQL->...Enter Target namespace:xxx and Input root element
name:xxx...->etc. But the XML-file created does not have the format I want it
to have, which I can understand.

I've created a XSD-schema out of a XML-document that has the format I want
and that I want BizTalk to produce, but I don't know how to use that
XSD-schema instead?

Does it make sense?

Jeff Lynch

2004-09-02, 6:19 pm

The SQL Adapter is setup to generate the schema it requires. You can use the
SQL Adapter Wizard to create a schema to extract the required data from your
database and then map the resultant schema to your desired schema.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"newbie" <newbie@discussions.microsoft.com> wrote in message
news:7E0F4149-D442-4C5A-A396-F3735961F083@microsoft.com...
> Ok here is what I am trying to do. I have a XSD Schema already created. I
> need to use this schema to generate an XML document from data in SQL
> Server
> 2000. How do I link an XSD Schema to a stored procedure, or something else
> to
> plug in my data to generate an XML file through BizTalk 2004?
>
> At the moment I'm using Add->Add Generated Items->...Add Adapter Wizard
> select SQL->...Enter Target namespace:xxx and Input root element
> name:xxx...->etc. But the XML-file created does not have the format I want
> it
> to have, which I can understand.
>
> I've created a XSD-schema out of a XML-document that has the format I want
> and that I want BizTalk to produce, but I don't know how to use that
> XSD-schema instead?
>
> Does it make sense?
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com