cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Collation conversion utility

Participant

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.

Tags (1)
9 REPLIES 9

Re: Collation conversion utility

Try to start AlterDatabaseCollation.cmd in Command Prompt.

Re: Collation conversion utility

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

Re: Collation conversion utility

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

Re: Collation conversion utility

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

Re: Collation conversion utility

You need to take screenshots by steps.

Re: Collation conversion utility

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

Re: Collation conversion utility

First question is SQL Server Host Name )

24.png

Highlighted

Re: Collation conversion utility

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 ?

Re: Collation conversion utility

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