There is a pretty nice method available to transfer data from one table to another
Transfer data from existing table to new table:
select * into table2 from table1
Copy all data from
table1
into
table2
(it creates new
table2
no need to write create statement)
It will create new
table2
and transfer all data from
table1
to
table2
Transfer data from existing
table1
to existing
table2
:
If you want to transfer data from one table to existing
table2
then use
Insert into vt_FE_Role1
Select [Role] from vt_FE_Role
Do not include primary key column if it is set as identity. Otherwise you can use it.
You must take care of RDBMS if exists.