Insert Data from One Table to Other Table in Different Database

Suppose I have two database.

1. dbTest1 &
2. dbTest2

I have a Table Employee in dbTest1 & dbTest2.

Now Select Record from dbTest2 Employee table.

Now query to transfer records from dbTest1 to dbTest2.

This query will work when table exist in Data Base:

Now Select Record from dbTest2 Employee table.

If Table Not Exist in your dbTest2 then use below query.