巨大的Xml文档（超过10GB）导入到Sql Server 2005 [英] Huge Xml Document(more than 10GB) import to Sql Server 2005

问题描述

我必须在Sql Server数据库中导入大小超过10GB的xml文档。我还必须在处理和维护交易之前进行XSD验证。请建议我做同样的最佳方式。我应该使用SSIS包装吗？是否能够处理如此大的文件？或者我是否必须使用c＃编码来完成此任务？

i have to import xml document having size more than 10GB in Sql Server database. i also have to do XSD Validation before Processing and maintain transaction. Please suggest me the best way to do the same. should i use SSIS packege? is it capable of Processing such large document? or Do i have to use c# coding to accomplish this task?

推荐答案

您可以尝试使用SSIS，希望它能帮助您。否则将XML文件拆分为1 GB文件。



http://msdn.microsoft.com/en-us/library/ms140277.aspx [ ^ ]



http://blogs.msdn.com/b/rdoherty/archive/2005/03/16/396956.aspx [ ^ ]

You could try using SSIS, hope it will help you. Otherwise split your XML file into 1 GB files.

http://msdn.microsoft.com/en-us/library/ms140277.aspx[^]

http://blogs.msdn.com/b/rdoherty/archive/2005/03/16/396956.aspx[^]

除了Jeffrey的回答，如果您正在考虑拆分XML文件，请查看这篇文章：



http://www.codeproject.com/KB/XML/SplitLargeXMLintoSmallFil.aspx#xx2994884xx [ ^ ]



或google this： Google的结果 [ ^ ]

In addition to Jeffrey's answer, if you are considering about splitting your XML file, then check out this article :

http://www.codeproject.com/KB/XML/SplitLargeXMLintoSmallFil.aspx#xx2994884xx[^]

or google this : Google's result[^]

MS SQL中是否有任何解决方案示例。



i只有超过2 GB的xml文件。



我无法导入我的数据库。



通过MS SQL。



i我收到了错误。







消息6365，级别16，状态1，行1

XML操作导致XML数据类型超过2GB。操作中止。

is there any solution example in MS SQL .

i have a only more than 2 gb xml file .

i am unable to import in my data base .

through the MS SQL .

i am getting the error .


"
Msg 6365, Level 16, State 1, Line 1
An XML operation resulted an XML data type exceeding 2GB in size. Operation aborted.

"

declare @xmlStr xml


SELECT @xmlStr = REPLACE(REPLACE(BulkColumn,CHAR(10),''),CHAR(13),'')
FROM OPENROWSET(BULK 'C:\xmldownload\adzunajobfeeds.xml', SINGLE_BLOB) AS X

select @xmlStr

这篇关于巨大的Xml文档（超过10GB）导入到Sql Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！