Skip to main content
K
kkr26061-Visitor
1-Visitor
May 16, 2017
Question

Collation conversion utility

  • May 16, 2017
  • 2 replies
  • 3639 views

I have taken a backup from SQL server 2008 R2 and restored it in SQL server 2014. Now the database collation is SQL_Latin1_General_CP1_CS_AS. I have to change the collation to Latin1_General_100_CS_AS_SC. When I run the collation conversion utility, it prompted to enter the details like destination host name, instance name, db admin user name, db user name, default db and application name. When I enter all the details and hit the enter button, the window closed. Nothing happening. Please give me a solution as soon as possible.

2 replies

S
SergeyEfimov1-Visitor
1-Visitor
May 16, 2017

Try to start AlterDatabaseCollation.cmd in Command Prompt.

K
kkr26061-VisitorAuthor
1-Visitor
May 16, 2017

Thanks for your reply. I have already tried that. The same thing happened. Please let me know if you know some other details.

B
BineshKumar11-Visitor
1-Visitor
May 16, 2017

Do you have a log file generated in scudirectory\collation_conversion\logs? If yes, please share that

K
kkr26061-VisitorAuthor
1-Visitor
May 16, 2017

No Binesh. The conversion process didn't even started. Hence, No logs generated. The folder is empty only.

S
SergeyEfimov1-Visitor
1-Visitor
May 16, 2017

You need to take screenshots by steps.

Terms & ConditionsAccessibility statement