SS Migration Assistant (SSMA) for Oracle: BLOBS larger than 2GB and SSMA Support for FILESTREAM columns
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,
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.
Sign in to comment