You are here: Re: Converting a file into multiple tables « MsSQL Server « IT news, forums, messages
Re: Converting a file into multiple tables

Posted by Wes Groleau on 11/19/06 02:22

Dan Guzman wrote:
> It's true that you can transform EDI and GEDCOM files directly into
> relational format. I think the reason XML is commonly used as an
> intermediate format is that XML is perfect for hierarchical data and you
> can leverage a high-performance XML import utility like SQLXML without
> writing additional code. Although it will take a while, I expect XML
> will eventually replace both EDI and GEDCOM formats. You'll be a step
> ahead if you can process XML too.

OK, I do know how to read and write XML. But can an XML file
be formatted so that the utility will create multiple tables
with the appropriate foreign keys to relate them?

I got the impression when I was reading about it that one
XML file makes one table and vice versa.

--
Wes Groleau
-----------

"Thinking I'm dumb gives people something to
feel smug about. Why should I disillusion them?"
-- Charles Wallace
(in _A_Wrinkle_In_Time_)

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация