• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Understanding the XML object

I manage a CMS system via a .NET middle tier that blends conventional (non-xml) db fields with external XMLs. Currently, these files are hand edited.

Going forward, we need to implement code-based management of these files. Since I _could do all the things the system requires via .NET code I'm not _forced to undertake the learning curve involved with SQL's xml datatype right now. I _could use .net's xml tools to read the external file, allow the user edits, and save back to the file. But since non-xml parts of our content is stored in the db, it stands to reason that sooner or later we'll want to bring those external files into the db as well.

I guess I'm looking for an excuse to procrastinate the sql/xml learning curve or a kick in the butt to get in gear.

In that context....

Where's the best place to get a 'narrative' overview of how I would use the XML datatype to bring existing XML structures from files to the db?

1 Solution
Mark WillsTopic AdvisorCommented:
There are a few good links and sites around. A lot of it depends on your level of experience, and seeing as you are XML savvy from a .NET code perspective, it makes it a little harder to find sites that capitalise on that background...

Anyway, have a look at : http://www.stylusstudio.com/sqlxml_tutorial.html

Then from the MS site : http://msdn.microsoft.com/en-us/library/ms345117.aspx  and http://msdn.microsoft.com/en-us/library/ms345115(SQL.90).aspx

Then there is the XML standards refernece for MS : http://msdn.microsoft.com/en-us/library/ms256177.aspx

And as an example of some specific content (note it is part 42) : http://www.databasejournal.com/features/mssql/article.php/3657691/SQL-Server-2005-Integration-Services---Part-42---XML-Task-continued.htm

Then if you like to click and find, there is the XML develoepr centre at MS : http://msdn.microsoft.com/en-us/xml/default.aspx  P.S. download XML notepad - tis good.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now