Our company wanted to migrate their data from an SQL Server database to Fabric.
The database we wanted to migrate has a specific collation, in particular it is case sensitive.
It would be nice if we could alter the collation of SQL Databases to make migration easier.
11 Comments
keith_smith1 - As Oviwan mentioned currently Collation can be set only during the database creation. Azure SQL has the same option. You can not Alter the collation. The request in this idea was to migrate a database with a specific collation into SQL database in Fabric. Customer would create a new database with the collation that the source database have and then start the migration.
Thanks
Sukhwant
- Oviwan "It would be nice if we could alter the collation of SQL Databases to make migration easier." This Idea specifically requests the ability to ALTER database collation. This idea is not complete.
- keith_smith1 Collation can only be set during database creation and cannot be modified later. See: https://learn.microsoft.com/en-us/fabric/database/sql/limitations#features-of-azure-sql-database-and-fabric-sql-database
sukkaur I cannot find documentation on how to change collation post creation. I get the error COLLATE is not supported by ALTER DATABASE if I try to change in T-SQL. How do we change the collation of existing database?
- Status changed:PlannedtoCompleted
Jappieduck - Thank you for sharing your feedback. Announcement for this change will be coming out soon.
thanks
Sukhwant
Jappieduck When we create a new SQL Database, it still always has the collation SQL_Latin1_General_CP1_CI_AS, verified using SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation'); — and I have not found any way to change it.
- Oviwan I think it already works, but haven't seen any news on it yet. I tried to migrate one of our SQL databases to Fabric and I did not encounter the same problem I had back in November, the collation did not cause any problems anymore.
