Data Migration using SQL Developer Tool (Oracle)

Posted on |

Senario

Move >10k records from MS SQL Database A to B (Different Table Design)

1
2
3
4
5
6
7
8
spool "C:\temp\data.csv"

select /*csv*/
    name as userName,
    address as userAddress
from customers;

spool off;

The records will be written into csv for furthur processing

  • Suitable for temp solution or inital load
  • Data exported with “” , which I haven’t found a way to get rid of; I am using Java to strip off the “” before the next processing steps
Reward Makes Perfect
0%