473,223 Members | 1,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,223 software developers and data experts.

XML data feed

Hello,
I have an XML data feed that I would like to use to create tables in
SQL Server. The xml data feed consists of a large amount of
information that changes on a regualar basis. Is there a way to
automatically create SQL Server tables using the data feed?

Thanks
Billy

Dec 29 '05 #1
7 2609
billy wrote:
Hello,
I have an XML data feed that I would like to use to create tables in
SQL Server. The xml data feed consists of a large amount of
information that changes on a regualar basis. Is there a way to
automatically create SQL Server tables using the data feed?

Thanks
Billy


In SQL Server 2005 you can use the XML datatype to store XML documents
in a column but I don't think that is what you are asking for.

Deriving a useful relational schema from an arbitrary XML document with
no other information to go on is potentially a very difficult task.
What is the information that changes on a regular basis and how does it
or should it map to tables in your database? Do you know the metadata
in advance or only at runtime? How will users or processes consume the
data if its structure isn't known at design time?

--
David Portas
SQL Server MVP
--

Dec 29 '05 #2
Hi

You may want to check out
http://msdn.microsoft.com/XML/Buildi...e/default.aspx
http://msdn.microsoft.com/library/de...egram_375f.asp

John

"billy" <bi**********@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Hello,
I have an XML data feed that I would like to use to create tables in
SQL Server. The xml data feed consists of a large amount of
information that changes on a regualar basis. Is there a way to
automatically create SQL Server tables using the data feed?

Thanks
Billy

Dec 29 '05 #3
Rob
David Portas wrote:
billy wrote:

Hello,
I have an XML data feed that I would like to use to create tables in
SQL Server. The xml data feed consists of a large amount of
information that changes on a regualar basis. Is there a way to
automatically create SQL Server tables using the data feed?

Thanks
Billy

In SQL Server 2005 you can use the XML datatype to store XML documents
in a column but I don't think that is what you are asking for.

Deriving a useful relational schema from an arbitrary XML document with
no other information to go on is potentially a very difficult task.
What is the information that changes on a regular basis and how does it
or should it map to tables in your database? Do you know the metadata
in advance or only at runtime? How will users or processes consume the
data if its structure isn't known at design time?


I believe using SQL Server Integration Services can solve this IF the
XML document has inline XSD tags or an XSD file is available with each
feed. An XML Source can be added to a data flow task and its output
directed to a table which I also "believe" can be created on the fly
based on the source schema.

Be warned that I have never tried this task. My statement is based on
something I read late at night and hopefully remember clearly. If
someone in the group can confirm or deny my statement, I'll be able to
sleep tonight. :)

In any case, I'm curious to know the application for this type of
functionality as I agree that deriving schema and building tables on the
fly is a challenging approach.
Dec 29 '05 #4
I will know that meta data in advance. I think that the tables will
change about once a month or so.

Dec 30 '05 #5
Thanks. I think I have checked these out in the past though.. but i am
not sure will take a look.

Dec 30 '05 #6
Thanks Rob. I have not yet had a chance to check out SQL Server 2005.
I will most likely do that next week.

Dec 30 '05 #7
Hi Billy

Unfortunately your question is too vague to give a definite answer. More
information on how you are getting the XML and the contents of the file
would help. Are inserting the data into the same table or a different table?
What is going to change in the XML?

John

"billy" <bi**********@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Thanks. I think I have checked these out in the past though.. but i am
not sure will take a look.

Dec 30 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: lawrence | last post by:
I had some code that worked fine for several weeks, and then yesterday it stopped working. I'm not sure what I did. Nor can I make out why it isn't working. I'm running a query that should return 3...
7
by: Chris | last post by:
Here's the situation: I work at a scientific institution and I have a portable electronic device which is used to take measurements. The device produces a very small amount of numerical data,...
1
by: jcsnippets.atspace.com | last post by:
Hi everyone, I'm trying to read an xml config file in C#. To do this, I have used the xsd.exe tool to create an xsd file from my xml, and to generate code to read this xml file. Here is a...
2
by: rob | last post by:
I'm looking for the best way to do minimal (probably 1 MB or so) updates to existing data, by having the client app monitor a live feed. That data feed will periodically broadcast the update...
1
by: caine | last post by:
I want to extract web data from a news feed page http://everling.nierchi.net/mmubulletins.php. Just want to extract necessary info between open n closing tags of <title>, <categoryand <link>....
5
by: jerry | last post by:
Ok, I have a feed that I need to get the data from. The file is an html file that contains items. I need to step through the file, getting the first item, doing whatever, then the second item, and...
7
Merlin1857
by: Merlin1857 | last post by:
Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can...
3
by: tombrogan3 | last post by:
Hi, I'm writing a service which has to monitor a database looking for new feeds (basically a few hundred thousand rows with a common id). When it finds a new feed I can either: 1) Process it on...
4
by: Blake Garner | last post by:
I'm looking for suggestions on how to approach generating rss feed ..xml files using python. What modules to people recommend I start with? Thanks! Blake
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.