dbTalk Databases Forums  

How to export a table into .xml and .xsd

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming


Discuss How to export a table into .xml and .xsd in the microsoft.public.sqlserver.programming forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Karen Middleton
 
Posts: n/a

Default How to export a table into .xml and .xsd - 12-22-2004 , 05:35 AM






Hello All

I want to create a export of a given table as a .xml file with a .xsd

Can somebody please point me in the right direction how I can do it.

Also, once I have created a .xml and .xsd how do I import the table
structure and contents after having dropped the table to recreate it
from the .xsd definition.

Please throw some light with some sample code.

Thanks
Karen

Reply With Quote
  #2  
Old   
John Bell
 
Posts: n/a

Default Re: How to export a table into .xml and .xsd - 12-22-2004 , 08:48 AM






Hi

Check out http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp

John

"Karen Middleton" <karenmiddleol (AT) yahoo (DOT) com> wrote

Quote:
Hello All

I want to create a export of a given table as a .xml file with a .xsd

Can somebody please point me in the right direction how I can do it.

Also, once I have created a .xml and .xsd how do I import the table
structure and contents after having dropped the table to recreate it
from the .xsd definition.

Please throw some light with some sample code.

Thanks
Karen



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.