SQL_Latin1_General_CP850_BIN2

[Former Member]

Hi,

Any ideas/suggestions ?

We are in a dev/qa/production landscape (R/3 470-200)and need to convert to SQL_Latin1_General_CP850_BIN2 before upgrading to SQL Server 2005.

Firstly, are we able to do this progressively without affecting the transport queue.

EG: will a transport that has been released in Dev on SQL_Latin1_General_CP850_BIN2 still move through successfully to QA on SQL_Latin1_General_CP850_BIN ?

(given that we don't want to convert all systems at once).

Secondly, assuming DBCC comes up clean, is this a safe procedure ?

Thirdly, I don't suppose there is a way for me to build a box on 2005 and homog-system-copy to it and then convert?

Thanks,

Tim

[clas_hortien]

Hello,

here are my two cents:

1) No, it will not affect your transports at all. The transport are

database independent and will not be affected by a collation change.

2) When the DBCC comes back clean, you can convert the database to

BIN2. You can run a DBCC after the conversion as well, but we have never

seen corruptions caused by the conversion, as it is only a Metadata change.

3) You can not convert on SQL 2005 but you can do a homogenous system

copy with R3Load to SQL 2005 and when the SQL 2005 is installed in the BIN2

collation, the database will be created and loaded in BIN2. A attach of a

SQL 2000 database in BIN and then doing the conversion is NOT possible.

See note 600027 for more details about the conversion.

Best regards

Clas

[Former Member]

Thankyou Clas,

This has been a big help.

Tim