Synchronizing data from Oracle 11.2 to SQL Server 2019

Question

We are currently in the process of migrating from Oracle 11.2 to SQL Server 2019. We need a way to read data in our Oracle database on regular basis (nightly, daily, hourly, etc.) for synchronization purposes so that we can run reports against the SQL Server database instead of Oracle due to performance issues with Telerik Reporting.

Has anyone out there run into similar problems and can you please provide some guidance on this issue?

Thank you!

Answer 1

To read data from an Oracle database on a regular basis for synchronization purposes, you can use the Oracle connector in Azure Data Factory. The Oracle connector provides built-in data partitioning to copy data from Oracle in parallel, which can help with performance. You can find the data partitioning options in the Source tab of the copy activity. Additionally, you can use Azure facilities, such as Data Factory, to orchestrate and automate the migration process while minimizing impact on the Oracle system.

References:

• Data migration, ETL, and load for Oracle migrations
• Migrating Oracle Data into SQL Server (OracleToSQL)

Answer 2

Hi @Steve Hodgkiss

Here is a migration guide from Oracle to SQL Server: https://learn.microsoft.com/en-us/sql/sql-server/migrate/guides/oracle-to-sql-server?view=sql-server-ver16, I hope it can help you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya