By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,361 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,361 IT Pros & Developers. It's quick & easy.

Creating XML files using a given Schmea

P: n/a
I have a Schema from the folk that shows how they want the data received. I
have my own database that has that data, but in a different way (they use 33
freaking tables to store what I do in 1). Now then, do I:
a) Create a data source that jives with their schema (say, a number of views
or store procedure to represent those 33 tables, but gets it's data from my 1
table) and then create the XML file off of that or...
b) Read their Schema, seek out those elements that are of interest to me,
fill-in the data for these elements as I go and write it all to the XML file
or...
c) Do this in some other basic way that hasn't occurred to me, if so, what?
Nov 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Are you talking about a database schema or a XML schema (xsd) ?

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 15 Feb 2005 10:45:02 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:
I have a Schema from the folk that shows how they want the data received. I
have my own database that has that data, but in a different way (they use 33
freaking tables to store what I do in 1). Now then, do I:
a) Create a data source that jives with their schema (say, a number of views
or store procedure to represent those 33 tables, but gets it's data from my 1
table) and then create the XML file off of that or...
b) Read their Schema, seek out those elements that are of interest to me,
fill-in the data for these elements as I go and write it all to the XML file
or...
c) Do this in some other basic way that hasn't occurred to me, if so, what?


Nov 19 '05 #2

P: n/a
An XML Schema (xsd).

"Scott Allen" wrote:
Are you talking about a database schema or a XML schema (xsd) ?

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 15 Feb 2005 10:45:02 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:
I have a Schema from the folk that shows how they want the data received. I
have my own database that has that data, but in a different way (they use 33
freaking tables to store what I do in 1). Now then, do I:
a) Create a data source that jives with their schema (say, a number of views
or store procedure to represent those 33 tables, but gets it's data from my 1
table) and then create the XML file off of that or...
b) Read their Schema, seek out those elements that are of interest to me,
fill-in the data for these elements as I go and write it all to the XML file
or...
c) Do this in some other basic way that hasn't occurred to me, if so, what?


Nov 19 '05 #3

P: n/a
One solution is to generate code from the XML schema file.

The XSD.EXE tool from the .NET SDK can generate typed DataSets or a
set of classes that correspond to the schema. Creating the file can be
as easy as populating a typed DataSet and calling GetXml(). This
approach is not the best fit in all scenarios, so you'll have to give
it a try and see how easy it will be to develop and maintain in your
environment.

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 16 Feb 2005 08:03:03 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:
An XML Schema (xsd).

"Scott Allen" wrote:
Are you talking about a database schema or a XML schema (xsd) ?

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 15 Feb 2005 10:45:02 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:
>I have a Schema from the folk that shows how they want the data received. I
>have my own database that has that data, but in a different way (they use 33
>freaking tables to store what I do in 1). Now then, do I:
>a) Create a data source that jives with their schema (say, a number of views
>or store procedure to represent those 33 tables, but gets it's data from my 1
>table) and then create the XML file off of that or...
>b) Read their Schema, seek out those elements that are of interest to me,
>fill-in the data for these elements as I go and write it all to the XML file
>or...
>c) Do this in some other basic way that hasn't occurred to me, if so, what?



Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.