将大型XML文件导入SQL数据库 [英] Import a Large XML File in to SQL database

问题描述

您好，我需要将大型XML文件的内容导入SQL 2005数据库。文件大小从250-700 MB不等。我能够导入大约100 MB的文件。
如果拆分大文件并创建数据库，如何处理数据集生成的主键。

TIA，
Gokul

解决方案

有专门用于SQL服务器的论坛，请参阅 http：// social。 msdn.microsoft.com/Forums/en-US/category/sqlserver 。
至于批量加载，请参阅http://msdn.microsoft.com/en-us/library/ms171993(SQL.90).aspx

Hi There,
I need to import the contents of a large XML file in to a SQL 2005 database. THe file-size varies from 250-700 MB. I was able to import the file which was around 100 MB.
In case of splitting large file and creating the database how to handle the primary key generated by the dataset.

TIA,
Gokul

解决方案

There are forums dedicated to SQL server, see http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver .
As for bulk load, see http://msdn.microsoft.com/en-us/library/ms171993(SQL.90).aspx

这篇关于将大型XML文件导入SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！