Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.
SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script
Brian Cidern’s extension script for consolidating collations across a database, a big help when you face the annoying cannot resolve collation error.
NULLIF Text: Collation Decides Whether Values Match
NULLIF text comparisons can remove a matching value. Select the matching rule explicitly and preserve the first expression’s return contract.
Choosing the Server Collation at Install Time
Choose the server collation before installation by checking application comparisons, tempdb behavior, and the cost of changing an instance later.
SQL SERVER – Change Collation of Database Column – T-SQL Script
How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.
SQL SERVER – Find Collation of Database and Table Column Using T-SQL
A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.
SQL Server – Good Articles on Database Collation
Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.







