Red Gate forums :: View topic - Changing Database collation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Changing Database collation

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
philstevens



Joined: 31 Jan 2012
Posts: 3

PostPosted: Thu Feb 23, 2012 3:32 am    Post subject: Changing Database collation Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Fri Feb 24, 2012 1:56 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group