Completely Change Database Collation
Posted on 2004-12-01
I have a situation where a SQL Server is being retired and all the databases moved over to another server. Up until the last database (!) all databases have gone across to the new server fine with no hiccups whatsoever, the last one however is causing problems becuase the collation of the database and all char/varchar etc fields in the database is different to the new server.
What I plan on doing is writing a script to cycle through all the tables in the database and change the collation of any char/varchar fields. Is this possible or is there a better way that anyone can suggest?
This is quite urgent so any suggestions are greatly appreciated!