Question

2
Replies
276
Views
 Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 221 posts
Anthem
Posted: October 12, 2018
Last activity: October 16, 2018
Posted: 12 Oct 2018 13:44 EDT
Last activity: 16 Oct 2018 10:32 EDT
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.

Data Integration System Administration
Moderation Team has archived post, 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
Posted: 16 Oct 2018 7:55 EDT
Sachin George (geors)
PEGA
Lead Service Assurance Advisor Specialist
Pegasystems Inc.
IN

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. 
Posted: 2 years ago
Posted: 16 Oct 2018 10:32 EDT
Laurence Brannigan (LaurenceB_GCS)
PEGA
Senior Software Solutions Engineer
PEG
GB

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.