This content has been marked as final. Show 1 reply
Let me start with your question #2.
In my SQl Server database I created a table 8x8 and I've started the migration. The table is renamed in Oracle to A8x8.
When I now create the offline data migration scripts in SQL Developer it is aware of the object name change and creates the offline files accordingly.
Here the script which is used to export the SQl Server data:
bcp "gateway.dbo.8x8" out "data\dbo_gateway.A8x8.dat" -q -c -CRAW -t "<EOFD>" -r "<EORD>" -U%2 -P%3 -S%1
You see it creates an export of the 8x8 table and puts the content into the A8x8.dat file.
The Oracle SQL*Loader control file then uses this dat file and puts the content into the A8x8 table:
into table dbo_gateway.A8x8
So in general when you rename the objects using SQL Developer at the Convert stage where you can change the data type mapping or rename objects, then SQl Dev takes care of it and creates the offline files accordingly.
Regarding #1 there's no generic tool and as usual it depends on a lot of factors. Some customers just check out the log and then just switch the application to now use the Oracle database, others perform more tests like checking the amount of data in the source and target, check of mandatory constraints etc. So here it really depends on your effort you're going to spend.