![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 36%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Hello,
You will migrate data from Oracle to Azure SQL database using Azure Data Factory. As a method of data validation, it is recommended to use the copy activity in Azure Data Factory. This activity provides a validation option to check the accuracy of data between source and destination. The validation option compares the number of data and the number of rows between the source and destination. After the verification process is complete, a report is generated and gives information about the verification process result. ¹³
Blob Storage account in Azure Blob Storage Service can be used as validation method for blob data. The Blob Storage account provides a verification option to check the accuracy of the blob data. The validation option compares the number of data and the number of rows between the source and destination. After the verification process is complete, a report is generated and gives information about the verification process result. ²
I hope I could help.
Source: Talking to Bing, 23/07/2023
(1) Copy data to and from Oracle - Azure Data Factory & Azure .... https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle.
(2) Copy data to and from Oracle - Azure Data Factory & Azure Synapse. https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle.
(3) Connector and format for mapping dataflows in Azure Data Factory.... https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-connector-format.