Server-level collations in Managed Instance are globally available
Posted on Thursday, April 18, 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.
For more details configuring server-level collation while creating the instance, see How to create Managed Instance.