Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 PRADEEP CHOWDARY PYDI (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
US
PradeepPydi Member since 2017 240 posts
Anthem
Posted: Oct 12, 2018
Last activity: Oct 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.

To see attachments, please log in.
Data Integration
System Administration

Posted: 6 years ago
Posted: 16 Oct 2018 7:55 EDT
Sachin George (geors)
PEGA
Principal Service Assurance Advisor, Cloud Migrations
Pegasystems Inc.
AU

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. 

To see attachments, please log in.
Posted: 6 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.

 

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice