|
How to Change a Database from One Collation to Other |
|
Know
the current SQL Database Collation
SELECT
DATABASEPROPERTYEX('cBizOne',
'Collation')
as SQLCollation
Note: cBizOne Collation:
SQL_Latin1_General_CP1_CI_AS
Collation and there meaning:
Link:
http://msdn.microsoft.com/en-us/library/ms144250.aspx
How to change server
collation:
The most clear and easy way is to completely
reinstall the sql server instance.
How to change database
collation:
Step1: Create a new database with collation
“SQL_Latin1_General_CP1_CI_AS”
Step2: Import all the tables from current
database to new database
Step3: Execute the hosting script
Step4: Create the database user, Catalog and
maintenance plan.
|