Activity overview
Latest activity by Ben_Walker09
Troubleshoot the Azure Migrate appliance and discovery. Refer to the Microsoft document that helps you troubleshoot issues when deploying the Azure Migrate appliance, and using the appliance to discover. It'll be better to take the advantage of azure migration services to help safeguard your business. / comments
Troubleshoot the Azure Migrate appliance and discovery. Refer to the Microsoft document that helps you troubleshoot issues when deploying the Azure Migrate appliance, and using the appliance to dis...
bbrown_GG said:
We are using SQL change automation to track changes and generate migration scripts. Before moving to an Azure Managed Instance db (compatibility set to SQL 2014), we were able to run this command to kick out other users and end their transactions: ALTER DATABASE [$(DatabaseName)] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE; But after migrating to an azure managed instance that command results in an error: "This ALTER DATABASE statement is not supported. Correct the syntax and execute the statement again." How can we end open sessions transactions to allow the migrations to proceed safely?
When to migrate to the cloud is a crucial business decision. Take advantage of azure migration services to help safeguard your business from ransomware and human errors with Azure backup. It’ll be better if you take the support from an azure migration consultant. / comments
bbrown_GG said:
We are using SQL change automation to track changes and generate migration scripts.Before moving to an Azure Managed Instance db (compatibility set to SQL 2014), we were able ...