Friday, February 10, 2012

Changing Database collation

I am trying to use DTS to change the collation of a database. I am using SQL 2000. The default is Case Insensitive, and I am trying to change one of the databases from Case Sensitive to Case Insensitive. I have created a new database with the proper collation, and I am trying to import all the database objects. I want end up with the exact same database with the collation the only thing that is changed. I have tried this process several times, but it stops with errors every time.

Could some please give me some pointers on what I am doing wrong?

Thank you
GarryHi
if your Goal is to change the DB collation I think you can use the DMO to do so, I faced this problem before and I used the Collation property of the Database2 object of the DMO and it worked with some errors that needs fix .
you may loop on your all varchar/char field (using the DMO also) to change their collations in order to fit the new collation of the DB.
It worked with me and I think it is better that using DTS
I suggest you Backup before Smile|||Hi Garry,
Change your primary DB collations first using sql statment change dbcollations 'collation name'

No comments:

Post a Comment