l****u
发帖数: 84 | 1 【 以下文字转载自 Database 讨论区 】
发信人: lalahu (lalahu), 信区: Database
标 题: Import 50GB data from multiple .txt file into MS SQL database
发信站: BBS 未名空间站 (Wed Jul 15 10:05:29 2009, 美东)
I am going to import very large stock market data from multiple .txt files (
over 3000 files) into sql database. I was wondering which is the most
efficient way to do that?
I used bulk insert and it takes me forever time (estimated 7 days) | D*******a
发帖数: 3688 | 2 have you tried bcp?
(
【在 l****u 的大作中提到】
: 【 以下文字转载自 Database 讨论区 】
: 发信人: lalahu (lalahu), 信区: Database
: 标 题: Import 50GB data from multiple .txt file into MS SQL database
: 发信站: BBS 未名空间站 (Wed Jul 15 10:05:29 2009, 美东)
: I am going to import very large stock market data from multiple .txt files (
: over 3000 files) into sql database. I was wondering which is the most
: efficient way to do that?
: I used bulk insert and it takes me forever time (estimated 7 days)
|
|
