Changing Database collation

Forum for users of SQL Packager database archive utility

Changing Database collation

Postby philstevens » Thu Feb 23, 2012 2:32 am


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?


Posts: 3
Joined: Tue Jan 31, 2012 10:54 pm

Postby Brian Donahue » Fri Feb 24, 2012 12:56 pm

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
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests