Importing an existing XML schema into SQL Server 2005

re: Importing an existing XML schema into SQL Server 2005

Henry Boehlert — Wed, 19 Apr 2006 17:16:03 GMT

Great post, I've been looking for a concise description like this since for quite some time.

I already pursued an approach using a .NET function but due to security constraints this did not become an easily applicable solution.

One little "add": key and keyref need to be removed as well, unless this restriction was lifted in SP1 (which I doubt)

re: Importing an existing XML schema into SQL Server 2005

denisruc — Wed, 19 Apr 2006 21:10:05 GMT

Thanks for the comment Henry. You are absolutely right, xsd:key and xsd:keyref nodes would have to be removed as well. And there are no plans that I know of to add support for those in the near future.

As for SP1 it should be available shortly and I'll probably write a post about the improvements that we made to XML datatype.

Download SP1 today!

Typed XML in SQL Server 2005 — Fri, 21 Apr 2006 04:48:24 GMT

Yesterday we released our first Service Pack for SQL Server 2005. You might remember a while back I...

Check Out Denis Ruckebusch's Blog

SQL Programmability & API Development Team Blog — Tue, 25 Apr 2006 00:39:19 GMT

I'm adding a link in the sidebar to Denis Ruckebusch's blog. Denis is one of our testers for the XML...

Importing the Microsoft Office 2003 schemas into the database

Typed XML in SQL Server 2005 — Wed, 03 May 2006 00:40:41 GMT

As promised earlier I'm going to give you an example&nbsp;using a&nbsp;real-world schema. I've chosen...

Problem with sp_xml_PrepareDocument after installing SP1 of SQL2005

Waldemar — Wed, 04 Oct 2006 20:30:25 GMT

I am calling sp_xml_PrepareDocument from a VS.NEt app against SQL Server 2005 and It worked fine till I installed SP1.

I got the following XML and sent this command not from the client but from sql management studio.

DECLARE @hdoc int

DECLARE @doc varchar(1000)

SET @doc =

'<?xml version="1.0" encoding="utf-16"?>

</Keys>'

EXEC sp_xml_preparedocument @hdoc OUTPUT, @doc

If I change @Doc to nvarchar it works, I did it on the client too but this time it does not work.

Any suggestions?

re: Importing an existing XML schema into SQL Server 2005

Steve — Thu, 18 Jan 2007 22:40:35 GMT

Great article. I just discovered your site and immediately set it as a favorite.

I'm trying to find how I might be able to replace a schema already in a schema collection. I could easily just add the revised schema to the collection and give it a slightly different namespace but I don't want to get sloppy. Any suggestions?

Cheers.

Steve Campos

re: Importing an existing XML schema into SQL Server 2005

denisruc — Wed, 24 Jan 2007 09:28:39 GMT

Steve,

Unfortunately for now we don't support removing or replacing schema components, only adding them.

You can create a new collection for your new schema and then retype all the columns constrained by the old collection (with ALTER TABLE ALTER COLUMN)

re: Importing an existing XML schema into SQL Server 2005

Terry Aney — Tue, 03 Apr 2007 05:27:52 GMT

What is the performance hit of dropping a schema collection (alter table alter column) and then re-adding it?

Additionally, if I have an Xml index set up, I have to remove that first as well right? I would assume this performance hit would be bad?

Error creating XML Schema Collections | keyongtech

Error creating XML Schema Collections | keyongtech — Sun, 18 Jan 2009 19:45:51 GMT

PingBack from http://www.keyongtech.com/2168269-error-creating-xml-schema-collections

Schema collection and xs:include | keyongtech

Schema collection and xs:include | keyongtech — Thu, 22 Jan 2009 06:35:00 GMT

PingBack from http://www.keyongtech.com/2256511-schema-collection-and-xs-include

sql2005 & schemaXML multiples - Page 3 | hilpers

sql2005 & schemaXML multiples - Page 3 | hilpers — Thu, 22 Jan 2009 18:06:01 GMT

PingBack from http://www.hilpers.fr/919210-sql2005-and-schemaxml-multiples/3

Typed XML in SQL Server 2005 Importing an existing XML schema into | Paid Surveys

Tue, 02 Jun 2009 10:01:21 GMT

PingBack from http://paidsurveyshub.info/story.php?id=74810