data migration using sql developer tool (oracle)

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

1
2
3
4
5
6
7
8

spool "C:tempdata.csv"

select 
    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