Question
2
Replies
268
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.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
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.