I think the Two databases are there in same Server Instances.
You can do this by "Three part naming convension"
If you have enabled IDENTITY on that tables then. Yo have to consider the following
1. You want to transfer the all column info 'as is' including Identity column.
2. You want to transfer the all column info Except Identity column.
Set Identity_Insert Tbl2 on
Select column1,column2,... from Db1.dbo.Tbl1
Set Identity_Insert Tbl2 off
Select column2,column3,... from Db1.dbo.Tbl1
Column1 is the Identity column enabled.
CheersAnu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator