I have 2 databases. Let's call them A and B
Let say I have Table X in database A and Table X in database B.
I want to directly import the data from Database A/Table X into Database B/Table X.
How can I do it?
When I try to do it, it creates a new table X 1.