x

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

Pem Emineva gravatar image

Pem Emineva
23 3 3 3

(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.

[6]: http://www.atlantis-interactive.co.uk/products/datasurf/default.aspx
more ▼

answered Aug 31, 2011 at 06:49 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x22

asked: Aug 31, 2011 at 06:29 AM

Seen: 916 times

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