Changing Database collation

[philstevens]

Hi

I've just migrated a database in SQL Server 2005 environment and I have noticed it has a different collation to the server and because of this, TempDB is not accessible when running stored procedures etc.

I was hoping to use SQL Packager to alter the collation of my database but I'm unsure of how to do that.

Can anyone help?

Thanks

Phil

[Brian Donahue]

Hi Phil,
Packager was not really designed to solve that problem, however there are two different ways you can go about it. If the database-level is the only place you specify a collation, you can change it in SQL Server Management Studio properties. However, since SQL 2000, you can specify collations individually for every column.

I suppose you could use SQL Packager to generate an upgrade package and that should do the job, but it could well change other aspects of the database that you don't want to change.

SQL Compare may be a better tool, as you can view the differences easily and get a script output that you can edit and apply only the collation changes.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521