SS Migration Assistant (SSMA) for Oracle: BLOBS larger than 2GB and SSMA Support for FILESTREAM columns

Terry C 1 Reputation point
2021-09-17T21:34:37.153+00:00

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

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.
505 questions
{count} votes