I have 2 database DB1 and DB2.
In DB1 i have a table table1 and inn DB2 i have a table table2.Both the table have same columns.
I want to migrate all the data from table1 to table2.
suggest me the better way to migrate data.
Thanks
Loading
I have 2 database DB1 and DB2.
In DB1 i have a table table1 and inn DB2 i have a table table2.Both the table have same columns.
I want to migrate all the data from table1 to table2.
suggest me the better way to migrate data.
Thanks
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
rahul kumarPosted Aug 7, 2021, 7:21 AM
Hey,
I think this will help you:
INSERT INTO DB2.table2(,...),...> from DB1.table1
SELECT <