• I don't have a clear answer to your question ("It depends" :D:D ), but you can use tools like

    - BCP (Bulk copy program)

    - SSIS package

    - T-SQL statements

    - Buy a third-party tool

    Wilfred
    The best things in life are the simple things