I am researching some options for loading hierarchically related data
from xml into an sql server database. I do not have the primary keys in the
source xml files. The primary keys are identity fields in the tables, and
are auto generated integers. I have about 40 tables that are related, and
the data is contained in a single xml file that will be hierarchical and
related.
I am using the following technology/tools:
SQL Server 2000 sp3a
SQLXML 3
..Net c#
..Net framework on the servers, latest updates
The product requirements include using C#, .Net framework on the
servers, xml, and an existing SQL server database design. I am free to
design xsd's, and the xml layout. I can use stored procedures and
dynamically generated sql from an application.
Any thoughts on where to look or suggestions on how to proceed?
Thanks,
Jeff
p.s. Please no comments on designing a product around a technology, I
realize how this looks, but that is what the boss has ordered.