Monday, March 04, 2013 4:46 AM
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.
Monday, March 04, 2013 6:00 AMModerator
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:
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