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

Karthik Elumalai · Answer

Hi Saurabh I hope the below code will help you Way 1: Syntax: INSERT INTO table2 (column_name(s)) SELECT column_name(s) FROM table1; Script: INSERT INTO Customers (CustomerName Country) SELECT SupplierName Country FROM Suppliers; way 2: Syntax: SELECT column_name(s) INTO newtable [IN externaldb] FROM table1; script: SELECT CustomerName ContactName INTO CustomersBackup2013 FROM Customers; Kindly let me know your thoughts. thanks karthik

Saurabh H · Answer

I want to copy old data from source table to target table. Target table also contains some data. Both the tables are in different databases. Also I don't want to change Id of rows of source table.

Vasanth Natarajan · Answer

try this... select idprouctrate from targettable tt RIGHT JOIN sourcetable st on tt.id<> st.id