Procedures and Triggers are not supported in the Azure SQL Managed Instance

Nilesh Patel 111 Reputation points
2021-11-18T11:09:06.033+00:00

The below stored procedures are not supported in the Azure SQL Managed Instance. So, what can be the alternate way resolve this error while migrating to Azure SQL Managed Instance.150614-stored-procedures.png

Stored procedures, functions, and triggers :

  • NATIVE_COMPILATION isn't supported in the General Purpose tier.

The following sp_configure options aren't supported :

  • allow polybase export
  • allow updates
  • filestream_access_level
  • remote access
  • remote data archive
  • remote proc trans
  • scan for startup procs

The following sp_configure options are ignored and have no effect:

  • Ole Automation Procedures
  • sp_execute_external_scripts isn't supported.
  • xp_cmdshell isn't supported. See xp_cmdshell.
  • Extended stored procedures aren't supported, and this includes sp_addextendedproc and sp_dropextendedproc. This functionality won't be supported because it's on a deprecation path for SQL Server. For more details, see Extended Stored Procedures.
  • sp_attach_db, sp_attach_single_file_db, and sp_detach_db aren't supported. See sp_attach_db, sp_attach_single_file_db, and sp_detach_db.

Also, find the Screenshot and leaving the link of that page :

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server#stored-procedures-functions-and-triggers

Azure SQL Database
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
863 questions
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.
547 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 45,881 Reputation points
    2021-11-18T11:43:48.077+00:00

    So, what can be the alternate way resolve this error while migrating to Azure SQL Managed Instance.

    And which of the mentioned unsupported features are you using (and why)?


  2. Tom Phillips 17,741 Reputation points
    2021-11-18T13:25:49.773+00:00

    Those are all things you do not normally use. They are generally server configuration and host system access procs. These are not supported on a hosted MI. If you REQUIRE them, then you cannot use a hosted MI as a solution.

    Are you having an actual problem converting to an MI?


  3. AmeliaGu-MSFT 13,991 Reputation points Microsoft Vendor
    2021-11-19T06:36:17.907+00:00

    Hi NileshPatel-7672,

    In addition, please refer to this doc about Assessment rules and recommendation used to assess the feasibility of migrating your SQL Server database to Azure SQL Managed Instance.

    Best Regards,
    Amelia

    0 comments No comments

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.