Question
2
Replies
233
Views
Anthem
Posted: 1 year ago
Last activity: 1 year 11 months ago
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: 1 year ago
Posted: 1 year 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.