473,320 Members | 1,694 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,320 software developers and data experts.

load hierarchically related data from xml

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.
Nov 12 '05 #1
0 1031

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

Similar topics

1
by: MN | last post by:
Greetings to all - I'm having some fits with getting this to work but I'm near the end and I'm hoping this one obstacle is not a huge one to get past. Here's my scenario: I have a page...
1
by: D | last post by:
Say you have three tables apples, oranges and bananas and each table has a different amount of fields that are obviously particular to that type of fruit. Now I want to load them into a form based...
1
by: Sumanth | last post by:
We are using cli bulk loader to load data into db2. In some cases the rows get rejected and this is flagged as a warning allowing the program to continue. Is there any way to trap this warning,...
0
by: EAI | last post by:
Hi All, How can I load balance Business Layer and Data Access Layer independent of UI layer? I am looking for samples or articles related to independent deployment of and load balancing just...
2
by: A.Wussow | last post by:
Hi Everybody, i want to load dynamically content from some user controls (with forms, or some data-controls) using atlas. So i use an UpdatePanel for loading the user control into a placeholder....
9
by: netasp | last post by:
hi all, how can I populate one aspx form when page is loading based on page ID? for example: loading page A (to search for VB code) would display labels and texboxes, dropdown lists all related...
3
by: Manish | last post by:
I think this question has been asked number of times. However, I am looking for some specific information. Perhaps some of you can help close the gap. Or perhaps you can point me towards right...
39
by: Gilles Ganault | last post by:
Hello, I'm no LAMP expert, and a friend of mine is running a site which is a bit overloaded. Before upgrading, he'd like to make sure there's no easy way to improve efficiency. A couple of...
1
by: =?Utf-8?B?RnJhbmsgVXJheQ==?= | last post by:
Hi all I have problems loading XML data into SQL Server. What is the best way to go ? I am new in using XML documents. I have tried to do it with "Integration Services" and also with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.