Sql Query to Copy Data from one table of Database to Another table of different database

To copy large amount of data from one table of one Database to another table of different Database.We can use the below query.

note:To copy the data one thing keep in mind that the table definition in both the databases should be the same.

INSERT INTO MicrosoftDynamicsAX..userinfo 

SELECT * FROM MicrosoftDynamicsAX_Deleted..USERINFO where USERINFO.ID = 'admin'

The above code will copy the data from "userinfo" table of database "MicrosoftDynamicsAX_Deleted" to the "userinfo" table of database named "MicrosoftDynamicsAX"

Thanks

Muhammad Zahid