Skip to main content
1-Visitor
May 16, 2017 6:15 AM UTC
Question

Collation conversion utility

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.

9 replies

1-Visitor
May 16, 2017 10:38 AM UTC

Try to start AlterDatabaseCollation.cmd in Command Prompt.

Translate
kkr26061-VisitorAuthor
1-Visitor
May 16, 2017 10:42 AM UTC

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

Translate
2-Explorer
May 16, 2017 10:54 AM UTC

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

Translate
kkr26061-VisitorAuthor
1-Visitor
May 16, 2017 11:00 AM UTC

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

Translate
1-Visitor
May 16, 2017 3:15 PM UTC

You need to take screenshots by steps.

Translate