Export table and import file - fastest way

Question

Post reply

Export table and import file - fastest way

rashidalen

Valued Member

Points: 55
More actions
October 19, 2013 at 5:58 am

#278195

Hello,
I have a table that contains about 50 millions of records and i would like to know which is the fastest method to export this table - bcp, DTS/SSIS, impot and exports wizard?
What is the best way to import text file to SQL Server?
www.fcbarcelona.extremazing.com - FC Barcelona - extreme and amazing team

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

learnwithvideotutorials SSC Veteran Points: 251 More actions · Answer 1

BCP would be fastest option. To import to a table you can use OPENROWSET with ot without BULK option.

www.learn-with-video-tutorials.com - video tutorials

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 2

learnwithvideotutorials (10/19/2013)
BCP would be fastest option. To import to a table you can use OPENROWSET with ot without BULK option.

Or just BULK INSERT for the import.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)