How can we help you today? How can we help you today?

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?
Gary Paquette
0

Comments

2 comments

Sort by
  • Ben_P
    Hi Gary,

    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").
    Ben_P
    0
  • GaryP
    Thanks Ben - I will review.
    I also found a very quick and surgical method to change the collation that includes all of the objects - tables, indexes, SProcs, etc...
    GaryP
    0

Add comment

Please sign in to leave a comment.