SQL Server Performance Forum – Threads Archive
SQL Server CollationI have restored a database from one of our customer sites onto a local server. However the database I have received has a different collation order than my server. This is causing me problems when running an application against the database. Does anyone know what the quickest way to convert the collation of the new database to match the server is? I have tight timescales for getting this done and the database is approx 10GB. I have looked at the ALTER DATABASE COLLATE clause but this only appears to change for the future. I am now considering a full DTS/BCP out and bak into a new database, is this my only option?
Only option is to use BCP to export/import data, Refer to books online for Collations –> Copying Between different collations topic for more information. HTH Satya SKJ