Help to install a specific collation/sort order originating from SQL Server 7 onto a newer version of SQL Server

Question

I need to install SQL Server 2008R2 onto a new server but with a collation / sort order that originates from a SQL Server 7 system.

I find that all the relevant collation options available for selection in the install wizard are not a match for the database compatibility needed.

Is it possible to install SQL Server in some other way and specify a very specific backward compatible collation ?

What I need to install is expressed as collation:   "Compatibility_50_409_0"

It's a BINARY sort order - which in SQL Server 7 was Sort order 50, BIN_ISO_1    Binary from ISO 8859-1    (Unicode locale 1033, Case Sensitive)

Any assistance would be greatly appreciated.

Answer 1

Hello,

I think you should use SQL_Latin1_General_Cp850_BIN because CP850 is for ISO 8859-1. The sort order name is cp850bin.850.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Albert, I tried that one and all the other Binary options available in the install wizard. They result in a collation that's not quite the same as those application databases that I restore from SQL 7. And the application software itself does not allow itself to be upgraded unless the those applications databases and all the master and system databases match in terms of collation. Hence my question if there was another way to install SQL and specify a collation - rather than have to use the normal wizard......

Answer 3

I'd check if application supports SQL2008R2 or not.

---

Thanks, Sohail ~Please mark answered if your question is completely answered; vote it as helpful to help others find a solution quicker. This posting is provided AS IS with no warranties.

Answer 4

Hello,

Please see the answer provided by Joe Yong (MSFT) on the following thread:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/ab266beb-5618-4f3a-bd4b-b9fdc7f02344/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com