Be seen. Boost your question’s priority for more expert views and faster solutions
INSERT INTO desDb..destTable (ID, Text, Comment)
SELECT ID, Text, Comment FROM sorceDb..sourceTable
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
if table not exists in DB2:
Select Column1,Column2, Column3 into db2.tablename from db1.tablename
if Table Exists in DB2:
Insert into db2.tablename Select column1, Column2,column3 from db1.tablename