Server-level collations in Managed Instance are globally available
Published date: 17 April, 2019
If you are using on-premises SQL Server instances with the custom server-level collation, you can now migrate them to Azure SQL Managed Instance without database and application changes. Configuring custom collations for managed instance is now generally available and enables you to create fully managed PaaS instances in the cloud that exactly match the server level collation of your on-premises SQL Server instances. To migrate your workloads from on-premises SQL Server, verify your current collation using
SELECT SERVERPROPERTY (N'Collation') and use this value to create a new managed instance.
Introduction of the server-level collation feature enables you to easily migrate your on-premises databases to managed instance with a strong reassurance that all queries using the objects that depend on server-level collation will work after migration without refactoring.
Custom server level collation can be configured at the time of creation of managed instance using the Azure portal, Azure PowerShell or Azure CLI and cannot be changed once the instance is created.
For more details configuring server-level collation while creating the instance, see How to create Managed Instance.