August 27, 2021 at 10:44 am
Just restored a database from another site and running into all sorts of problems to do with Collation
Is there any 'easy' way to just completely change Everything in a database to a specific collation
e.g. Tables, Columns, Indexes, Constraints,. in other words everything
Something like: Change Database MyDatabase to Collation Latin1_General_CI_AS
(I cannot find a simple way to do this)
August 27, 2021 at 11:38 am
No easy way, if you want to change everything you need to script everything out and do a find replace and regenerate the database then reinsert the data.
The alternative is to add the “COLLATE DATABASE_DEFAULT” option to everywhere to make sql pick a default or specify a particular collation on each reference to a table, join, view etc etc in each query you run.
August 27, 2021 at 3:18 pm
Agree, there's no super-easy, "automatic" way to do that. However, you can generate a script(s) that will change each column as needed, so it's not like you have to do it all by hand.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply