Changing the user database collation

Dear all, I have the following situation: There is a difference between collations of SQL Server and user database. SQL Server is installed with the following collation: Cyrillic_General_CI_AS, what is the correct collation. However the user database on the server is with SQL_Latin1_General_CP1251_CI_AS. I must change the collation of the user database like the SQL Server. Reading the following: http://msdn.microsoft.com/en-US/library/ms175835(v=SQL.90).aspx I understood that in this way it will be changed the default collation of the database and will be applied only for the new objects. The existing objects can be changed with alter table.. etc. Is there another way to change the collation of the user database? I mean to create the new database with the required collation and restore backup from the old userdatabase? Thanks in advance.

more ▼

asked Aug 31, 2011 at 06:29 AM in Default

avatar image

Pem Emineva
23 3 3 5

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You could use a schema comparison tool to synchronise the objects from a copy of the database to the new one. Most of these tools allow you to ignore collation as an option, so act as a collation-agnostic copy.

You would then do the same with a data comparison tool to repopulate the database.

more ▼

answered Aug 31, 2011 at 06:49 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 31, 2011 at 06:29 AM

Seen: 1180 times

Last Updated: Aug 31, 2011 at 06:29 AM

Copyright 2018 Redgate Software. Privacy Policy