BIN BIN2 collation

BIN BIN2 collation
Reference note: 600027 ,505906

If the collations do not match, proceed as follows depending on the
case that applies for your system: :

- Case 1: Database collation: SQL_Latin1_General_CP850_BIN
Target Server collation: SQL_Latin1_General_CP850_BIN2

a) In this case, attach the database.

b) Make sure that no user connects and uses this database.

c) Re-run InstColl.exe with the following command line:
InstColl -S -D
The special -D option allows you to convert only one database.
This should finish within a very short time (<3 minutes)
You can now use the SAP database in its new location.





- Case 2: Database collation: SQL_Latin1_General_CP850_BIN2
Target Server collation: SQL_Latin1_General_CP850_BIN

a) Back up all databases on the target server.

b) Make sure that you also have a backup (or copy) of the database
you are migrating.

c) Apply SP4.

d) Run InstColl.exe against the server (do not use the -D option).

e) Attach the database.