insert into db2..table1 select * from db1..table1 insert into db2..table2 select * from db1..table2use db1 go turncate table table1turncate table table1
insert into db2.table_1 select * from db1.table_1 insert into db2.table_2 select * from db1.table_2
insert into db2..table2 select * from db1..table2use db1
go
turncate table table1turncate table table1
insert into db2.table_2 select * from db1.table_2