question

cstephen avatar image
cstephen asked

how to change existing collation of the sqlserver back file .bak

I am having database in production server like "scmdb.BAK".this database used in sql server default collation while installing the server ,we choosed default collation.now we want to change the collation of the existing .bak file to chinese (simplified). Is it possible to change all tables,procedures,views,UDDs structures has been able to change in chinese collation..
collation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
I am not sure you can change it "after the fact". I would say to restore to a test server then change to the correct collation. Did you change the collation at the server level? It can be set at Server, Database, Column, and Expression levels.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

no sqlaj,We are planning to do it.we didnt know,because it is having all valuable data.but we need to convert it in chinese .
0 Likes 0 ·
If you haven't done the work yet then I would suggest looking at these pages if you have not already. http://msdn.microsoft.com/en-us/library/ms179254.aspx http://msdn.microsoft.com/en-us/library/ms175835.aspx
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.