SQL Server data Table replication

Copy the contents of a to a new table

Description

With data table A, you want to export his content to another table B, at which point B is not created and you want to create table B at the same time as the export.

SELECT *into B [in Externaldatabase] from A

Second, copy the contents of a to the existing table B

Description

With data table A, you want to export his content to another table B, at which point B is created and you want to create table B at the same time as the export.

Insert into B (b_column_1, b_column_2, ...) select A_column_1, a_column_2 from A;

SQL Server data Table replication