Collation issue in Sql Server 2008
-
Monday, March 04, 2013 4:46 AM
Hi Guys,
Just now i have migrated databases from sql server 2005 to sql server 2008 and getting collatin issue.
can i change default collation of all the migrated dbs to that of sql server 2008 one.
Plz advice..........
Ritz
All Replies
-
Monday, March 04, 2013 6:00 AMModerator
Hello,
Maybe is better to change the collation of the SQL Server 2008 instance to be the same of the old SQL Server 2005 instance.
Do not change the collation of user databases migrated from the old instance.
Use the following command to run SQL Server setup and change the collation on the instance:
setup.exe /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SQLCOLLATION=<the old collation>
For more information about this command:
http://msdn.microsoft.com/en-us/library/dd207003(v=sql.100).aspxRegards,
Alberto Morillo
SQLCoffee.com- Proposed As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Tuesday, March 05, 2013 10:13 AM
- Marked As Answer by Allen Li - MSFTModerator Thursday, March 14, 2013 3:03 AM
-
Monday, March 04, 2013 6:51 AM
You need to install SQL Server 2008 with the right collation otherwise I would specify COLLATE clause...
Alberto has already provided you with the correct way...
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
.png)
