CODEWITHSUNDEEP
sqlsql-server
John
John

Reputation: 721

Fastest Way to Import?

What is the fastest way to import 15000000 records from Text File to SQL Server?

Currently, I am importing data using Enterprise Manager, that takes 3-4 hours for importing into the SQL table.

Thanks in advance!

Upvotes: 2

Views: 808

Answers (3)

Remus Rusanu
Remus Rusanu

Reputation: 294297

Using SSIS there is a published benchmark that loads 2.36TB per hour. There are tricks you can do, like split the file parsing and spread the load on separate NUMA listening ports. Also the articles quotes matching the column types properly in SSIS is a big factor.

Upvotes: 1

AdaTheDev
AdaTheDev

Reputation: 147244

+1 to Mehrdad's answer. Just wanted to add, if you have indexes on the table you're trying to load in to, those will affect the load speed as they have to be maintained. You may be better to remove/disable those indexes while you do the import.

Upvotes: 1

Mehrdad Afshari
Mehrdad Afshari

Reputation: 422006

Try bcp utility or BULK INSERT statement. BULK INSERT statement should be faster though.

Upvotes: 11

Related Questions