Insert Data from One Table to Other Table in Different Database

In this blog we will learn how to 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.