Synchronizing data from Oracle 11.2 to SQL Server 2019

Steve Hodgkiss 0 Reputation points
2023-08-15T18:47:09.5966667+00:00

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,503 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2023-08-15T18:47:09.6+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    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:

    0 comments
  2. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2023-08-16T06:49:16.5466667+00:00

    Hi @Steve Hodgkiss

    Here is a migration guide from Oracle to SQL Server: https://video2.skills-academy.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

    0 comments