Collation conversion utility

kkr2606 · ‎May 16, 2017

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.

SergeyEfimov · ‎May 16, 2017

Try to start AlterDatabaseCollation.cmd in Command Prompt.

kkr2606 · ‎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.

BineshKumar1 · ‎May 16, 2017

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

kkr2606 · ‎May 16, 2017

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

SergeyEfimov · ‎May 16, 2017

You need to take screenshots by steps.

BineshKumar1 · ‎May 16, 2017

First step in the script is creating log directories and scripts, are could you run the command prompt as an administrator? You can run through the commands in AlterDatabaseCollation section by section or add echo statements to see where it breaks

SergeyEfimov · ‎May 17, 2017

First question is SQL Server Host Name )

kkr2606 · ‎May 22, 2017

Hello Sergey,

While installing the windchill 11, It has prompted to create a database user; I have created user A. Then, while restoring my old backup to sql 2014, users over-wrote. So the user A deleted from sql server database, (which is associated with windchill). I have only old users (as I had in sql 2008). But in db.properties file, the dbuser is marked as the user 'A'.

While running the collation conversion utility, which user I have to enter and what I have to change here ?

SergeyEfimov · ‎May 22, 2017

You will specify the user in the upgrade process.

May be you need to restore SQL User.

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS191091