Post reply

How to export 20 milion rows to only one file ?

  • September 20, 2022 at 1:09 pm

    #4089807

    I work on sql server 2019 i have table have 20 milion rows .

    i need to export data Exist on table to only one file by using sql server 2019 .

    so what best tool and faster tool can help me to extract 20 milions rows from sql server to csv file (only one file )

  • September 20, 2022 at 2:05 pm

    #4089841

    ahmed_elbarbary.2010 wrote:

    I work on sql server 2019 i have table have 20 milion rows .

    i need to export data Exist on table to only one file by using sql server 2019 .

    so what best tool and faster tool can help me to extract 20 milions rows from sql server to csv file (only one file )

    BCP

    https://duckduckgo.com/?q=bcp+in+sql+server&t=newext

    You could also take the time to use SSIS for such a thing... I try to never have an instance of SSIS available but that's just me.

     

    --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)

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

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