Import xml schema into SQL Server 2005

Asked By Krueger Jim 0 points N/A Posted on - 10/18/2012

Hi,

I am using MS SQL Server 2005 for database development. I want to Import xml schema into SQL server 2005. Can anyone tell me the procedure that how can I Import xml schema into SQL server 2005.

• Status: Open
• Question Views: 1487
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Rain Bonnie

Go To Solution

Answered By June Antonia 5 points N/A #152267

Import xml schema into SQL Server 2005

My dear,

If you want import XML schemes into the SQL server 2005, you should visit these websites:

• SqlXml 3.0 Service Pack 3 (SP3)
• How to import a XSD and XML file into a SQL table

They will help you with your XML server.

Thank you.

About June Antonia

Questions
0

Answers
98

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 10/18/2012
• Question Category: MS SQL Server

Answered By Wright Susan 0 points N/A #152269

Import xml schema into SQL Server 2005

Hi,

There are a few other XSD features that SQL Server 2005 doesn’t support. To Import xml schema into SQL server 2005 you have to follow some procedure. The whole procedure is described in the website.

 

Thanks.

About Wright Susan

Questions
0

Answers
22

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/19/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Rain Bonnie 0 points N/A #152268

Import xml schema into SQL Server 2005

 

You would require to parse the XML as it is into a table like format.

 

You need to remember that XML is just like plain text therefore you need to tell the SQL server what these databases are.

Therefore, no single shot magical bullet exists.

 

INSERT MyTable FROM File = 'bob.xml'

 

About Rain Bonnie

Questions
1

Answers
59

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 10/20/2012
• Question Category: MS SQL Server