DMA Migration assessment suggest CLR as breaking changes

pdsqsql 431 Reputation points
2021-05-24T21:30:13.86+00:00

Hello,
I have done Migration Assessment using Database Migration Assistant (DMA) and it suggest something for CLR as breaking changes:
I am planning to migrate from Sql 2012 to Sql 2017 (in place upgrade)

CLR assemblies marked either SAFE or EXTERNAL_ACCESS
Type: Assembly
Name: SAPCLR

When CLR Strict Security is enabled, attempting to create an unsigned assembly will cause an error

I was looking into Database and found following:

99187-image.png

When I run sys.assemblies it gives me following:

microsoft.sqlserver.types.dll

If I ignore it and migrate, it will hurt anything?
How to find any CLR function using into database?

Thanks for your help!

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.