Last updated on JUNE 30, 2016
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 6.1 and later
How to change the collation of a SQL Server 2000 database.
How to transfer a database from one collation in SQL Server 2000 to a different collation in SQL Server 2000.
Possible ways to change The collation settings of a database (patch 8.5.0 sp2f). SQL Server 2000
Note: Transfer methods that do not change a database's collation:
- Backup and restore: Restoring a database on a server that has a different collation than the server that is used for the backup does not convert the restored database to the new collation. The database collation remains as is.
- Detach and reattach: If you detach a database that was created with one collation and you reattach the database to another server that has a different collation, the collation of the database does not change. The collation of the database remains as is.
- Copy Database Wizard: The Copy Database Wizard essentially automates the process of detaching and reattaching. The collation of the database remains as is. Note The Copy Database Wizard is only available in SQL Server 2000.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms