SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
SS Migration Assistant (SSMA) for Oracle: BLOBS larger than 2GB and SSMA Support for FILESTREAM columns
![](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(163.2, 65%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Terry C
1
Reputation point
Hi. I'm trying to determine if the SSMA utility for Oracle to SQL Server supports the migration of BLOB data larger than 2GB in size.
I tried running a test SSMA run, and during the Convert step, it looks like the target SQL Server table creation only by default specifies a column with the varbinary(max) datatype but no way of specifying the FILESTREAM directive and also no way of adding a column with the ROWGUIDCOL property.
If SSMA does not support the migration of BLOBS larger than 2GB, what are people doing to support the migration of tables with huge BLOBS from any source database to SQL Server?
BTW, we are working with MS SQL Server 2019.
Thanks in advance,
Terry
{count} votes
-
![](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(230.39999999999998, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov 491 Reputation points2021-09-17T22:26:48.467+00:00 Hey,
It is true, SSMA currently does not support FILESTREAM/ROWGUIDCOL columns. What you can do is modify the table(s) definition manually after automated conversion and use something like SSIS (Integration Services) to migrate the data.
We will an item to the backlog to look into this within SSMA.
Regards,
Alex. -
![](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(208, 14.000000000000002%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Vathan G 116 Reputation points2024-04-09T20:06:07.3266667+00:00 is this feature enabled now?
Sign in to comment