Copying data from one table to the other

• Using a select statement


• bulk copy in and out of a database


• backing up and reloading

Copying data using SQL select statement

insert into destination_table(field1,field2,field3,...)

select field1,field2,field3,... 

from source_table;

 create table new_table

 select field1,field2,field3

 from orriginal_table;

 

Moving data using bulk copy

bcp {[[database_name.][schema].]{table_name | view_name} | "query"}

    {in | out | queryout | format} data_file

    [-m max_errors] [-f format_file] [-x] [-e err_file]

    [-F first_row] [-L last_row] [-b batch_size]

    [-n] [-c] [-N] [-w] [-V (70 | 80 | 90 )] 

    [-q] [-C { ACP | OEM | RAW | code_page } ] [-t field_term] 

    [-r row_term] [-i input_file] [-o output_file] [-a packet_size]

    [-S server_name[\instance_name]] [-U login_id] [-P password]

    [-T] [-v] [-R] [-k] [-E] [-h"hint [,...n]"] 

Arguments