Help to install a specific collation/sort order originating from SQL Server 7 onto a newer version of SQL Server
Wednesday, January 09, 2013 6:01 PM
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.
Wednesday, January 09, 2013 7:36 PMModerator
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.
Wednesday, January 09, 2013 10:52 PMAlbert, 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......
Wednesday, January 09, 2013 10:59 PM
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.
Thursday, January 10, 2013 3:05 AMModerator
Please see the answer provided by Joe Yong (MSFT) on the following thread:
Hope this helps.