question

thrishank avatar image
thrishank asked

How can i change SQL server Collation After Installation in sql2016

Hi,

I need to change the sql server collation after installation in sql 2016 .

Is it possible to change the database collision on a specific database instead of changing the entire SQL server collision because only one specific project is facing collision issue on sql databse.

-Thrishank k

sql serverdbasql server 2017sql server 2016
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

Changing the collation is not an easy task once already in place.

The server collation can be done by re-running the setup and rebuilding the system databases passing in the correct collation.

Individual database collations can be done by changing the table collation then the column collation, but this can be time consuming depending on the amount of tables and string columns in each table.

What may be the better option is to create a new database with the correct collation, script out all objects ensuring the collation isn't scripted also, and replay that into the new DB. They copy any data that's needed between the two databases.

This link may come in handy also

https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.