Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
Oracle Blob Migration to Azure Sql Database
![](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(3.2, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rahul
251
Reputation points
Hi All,
I have migrated the blob column type from Oracle to Azure sql database.
- Question-1 -Does ADF perfectly migrate the blob data type from oracle to azure, keeping in view oracle blob are stored in the LOB segment.
- Question-2 Space related details need clarification.
Oracle-Table GROUP_MO-Column-PSTREAM-Blob datatype.
No of Rows-312796
SUM(DATALENGTH(PSTREAM))-36.8 GB
LOB SEGMENT-588 GB
Properties
SEGMENT CREATED-YES
RETENTION TYPE-YES
RETENTION-900
CHUNK-8192
LOGGING-YES
This column is used by the application for last 5 years.
Azure Sql Database
No of Rows-312796
SUM(DATALENGTH(PSTREAM))-36.8 GB
Question-2 Since the lob segment is 588 GB and sum (datalenght)-36.8 GB.
The extra space in oracle-588 GB-36.8 GB = 555.12 would have been acquire due to DML,Retention,Logging,Undo,Redo operations , please confirm?
In azure sql database only 36.8 GB data needs to be migrated as done by the Azure data factory tool.
Do I need to migrate any other data separately for this column-PSTREAM ?
Azure Data Factory
{count} votes
-
Rahul 251 Reputation points
2023-06-20T10:08:07.8566667+00:00 @ShaikMaheer-MSFT -Please guide for above query!
-
![](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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,366 Reputation points Moderator2023-06-21T19:25:28.4533333+00:00 Hello @Kashish,
Thanks for reaching out on this forum!
I will try to address on some initial questions! I hope this helps with initial query!
Regarding your questions:
Question-1 -Does ADF perfectly migrate the blob data type from oracle to azure, keeping in view oracle blob are stored in the LOB segment.
We can review the Oracle to Azure SQL Database migration guide to ensure that your specific use case is supported.
Migration guide: Oracle to Azure SQL DatabaseQuestion-2 Space related details need clarification.
The extra space in Oracle may be due to various factors such as DML, retention, logging, undo, and redo operations etc.,
Regarding the migration of the
PSTREAMcolumn, if you have already migrated the data using Azure Data Factory and confirmed that the data is present in Azure SQL Database, then you should not need to migrate any other data separately for this column. However, you should verify that the data has been migrated correctly and that there are no issues with the data in Azure SQL Database.I hope this helps! Let me know if you have any other questions or concerns and we would be happy to help you further. I will make sure ShaikMaheer is aware of this thread discussion!
-
Rahul 251 Reputation points
2023-06-23T07:11:49.5066667+00:00 Hello @SatishBoddu-MSFT, @ShaikMaheer-MSFT
Thanks .
Question-1 -Does ADF perfectly migrate the blob data type from oracle to azure, keeping in view oracle blob are stored in the LOB segment.
[Kashish]- In our case we are only using the Azure data factory for the data migration from the oracle to the Azure sql database.
SSMA tool is not used.
Please answer does Azure data factory tool migrates the blob data type perfectly from oracle to azure sql database.?
-
QuantumCache 20,366 Reputation points Moderator
2023-06-23T12:57:14.25+00:00 Hello @Kashish,
Below document provides information regarding the supported Data types.
In ADF the Oracle BLOB data type is treated as Byte[].
ADF can migrate BLOB data type from Oracle to Azure SQL Database using the Copy Activity, but it is important to thoroughly test your data migration and address any issues that arise to ensure the success of your migration process.
Sign in to comment
Sign in to answer