SQL Server 2008 R2
SQL Server 2008 R2 is not supported for Windchill 11.0. If your source system is set up in a SQL Server 2008 R2 environment, you must perform the following steps before upgrading to Windchill 11.0:
1. On the source system, the version of Windchill must support SQL Server 2012 or later versions. If the current release does not support SQL Server 2012 or later versions, you must update to the latest release of the Windchill version installed on your source system. Refer to the following table for details about which release to update to:
Windchill Source Main Version
|
Releases that DO NOT support SQL Server 2012 or later versions
|
Update Windchill to this Release
|
10.0
|
F000, M010, M020, and M030
|
M050
|
10.1
|
F000 and M010
|
M050
|
2. Upgrade your SQL Server Instance to 2012 or a later version. For details, refer to the MS SQL Server documentation.
3. Execute the Collation Conversion Utility to change the existing database collation from "SQL_Latin1_General_CP1_CS_AS" to the new, supported collation "Latin1_General_100_CS_AS_SC".