To insert data into two tables, you'll need two
If you don't want to copy the identity column over, then you'll need to list the columns explicitly rather than using
SELECT * FROM
clause appears to have nothing to do with your stated requirement.
INSERT INTO DB_TO.dbo.Table1 (field1) SELECT field1 FROM DB_FROM.dbo.Table1;
INSERT INTO DB_TO.dbo.Table3 (E1) SELECT E1 FROM DB_FROM.dbo.Table3;