Changing SQL Server database collation
Hi,
I know that manually changing a databases collation is a very difficult task (not sure why - but it is)
I have done the old export the schema, tables and data and imported back into a different collation but this can take days on a large DB and a lot of attention.
Does Redgate have a method or tool to perform the difficult task in a simpler way?
I know that manually changing a databases collation is a very difficult task (not sure why - but it is)
I have done the old export the schema, tables and data and imported back into a different collation but this can take days on a large DB and a lot of attention.
Does Redgate have a method or tool to perform the difficult task in a simpler way?
Tagged:
Answers
You may be able to use the Comparison tools (SQL Data Compare and SQL Compare (Schema Compare)) to do this.
Create a new database with new collations and compare using SQL Compare and then Data Compare with old database with old collations and make sure you use option **Ignore collation** in SQL Compare. More about it here: https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options (look for "Ignore collation").
I also found a very quick and surgical method to change the collation that includes all of the objects - tables, indexes, SProcs, etc...