Question
2
Replies
257
Views
Anthem
Posted: October 12, 2018
Last activity: October 16, 2018
Closed
Data Migration tool from SQL Server to Oracle.
Hi Team,
Please suggest recommended Data Migration tool from SQL Server to Oracle.
We wanted to crosscheck pros and cons between Oracle SQL Developer software and Pega Data Mover Utility.
Posted: 2 years ago
I don't have any direct experience of SQL Server > Oracle migration to offer any insight.
However, I believe SQL Server allows for longer table name, column name lengths.
Oracle is limited to 30 chars. So this may be worth a sanity check.
Pega Data Mover is probably your best option. Please do test the application thoroughly after migration. Oracle SQL developer, did not scale for large volumes in our initial testing some years back. If your target Oracle DB is in AWS cloud, then AWS gives you other options.