Changing Database collation

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Changing Database collation

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

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
philstevens
 
Posts: 3
Joined: Tue Jan 31, 2012 11:54 pm

Postby Brian Donahue » Fri Feb 24, 2012 1: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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests