Post reply

Fastest Way To import???

  • July 26, 2009 at 12:13 pm

    #212586

    Dear Friends..

    Is there any Fastest Way to import 15000000 records from Text File to SQL Server...

    Currently i importing data using Enterprise Manager,thats takes

    3-4 hours for importing to SQL Table

    Is there any Fastest Way..

    Please help me

    Thanks in Advance

  • July 26, 2009 at 12:32 pm

    #1030301

    From my experience the fastes way would be using BCP with indexes of the target table disabled (unless the source file is already in the right order or there are already data in the table and you need to check for identity). Having the database in simple recovery mode (if that's possible in your scenario) would also speed the import up since it would reduce logging.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • July 26, 2009 at 2:09 pm

    #1030314

    See http://www.sqlmag.com/Article/ArticleID/98568/sql_server_98568.html

    Adventures with Big Data: How to Import 16 Billion Rows into a Single Table

    Tips on how to use T-SQL's BULK INSERT statement and the BCP utility

    N 56°04'39.16"
    E 12°55'05.25"

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

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