Collation problem on BPC migration.

[Former Member]

We are doing a migration from V4.2 to V7.0 BPC on microsoft plataform.

The new database has the correct collation 'SQL_Latin1_General_CP1_CI_AS' but the V4.2 back up was from a database which collation is 'Finnish_Swedish_CI_AS'

Now we have problems with column collation in the restored backup. We can't change column collation because there are index using the columns.

Anybody have any idea how to proceed? We strongly appreciate it.

Best Regards.

[former_member184473]

Hello,

You can follow note 505906 to check (and change) your server and database collation.

Regards,

Eduardo Rezende

[Former Member]

Hi dude!

In fact, you can run program InstColl.exe to convert to SQL_LATIN1_GENERAL_CP850_BIN2, but unfortunately it does only run on a SQL Server 2000 SP4 database. Then:

(a) if your database is SQL Server 2000 but you did not apply SP4, you should apply it and then run the instColl.exe.

(b) if your original database was SQL Server 2000, but you upgraded e.g. to SQL Server 2005/2008, you can restore a backup on a SQL Server 2000 SP4 database instance; then you will be able to run instColl.exe and only after having run it you will be able to upgrade to SQL Server 2005/2008.

(c) if your database is other than SQL Server 2000, e.g. SQL Server 2005, the only option is to export the entire database and then import it with the correct collation (just like in a system copy) by means of R3trans, as unfortunately you cannot detach a SQL Server 2005 database and then attach it to a SQL Server 2000.

Find the details in SAP notes 505906 and 600027.

Cheers!!

-Jesú