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
Garry

Answer this question

Changing Database collation

myhome
Hi
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
Justin Wolf
Hi Garry,

Change your primary DB collations first using sql statment change dbcollations 'collation name'
Changing Database collation

Answer this question