Copy data from source table to target table

Question

I have two tables source and destination with same table schema in two different databases. Only data is different.

Write a script to copy data from source to target. Id is a Primary Key. There should be no duplication of Id.

 

TargetTable

Id  Prouct    Rate
1   Tea        10
2   Coffee    20
3   Milk        30

 

SourceTable

Id  Prouct    Rate
1   Sugar     25
2   Salt        15