PeopleSoft Unicode SQL Server DB - Converting NCHAR data types to NVARCHAR
We have recently converted a PeopleSoft HCM 9.1, PT8.52 SQL Server 2012 DB to Unicode and then upgraded to PT8.55.12 and HCM 9.2 PI21 and the development team started are more than halfway through retrofitting of the customized objects in the development environment.
We have followed the process documented in PeopleBooks (Converting to Unicode on Microsoft SQL Server and DB2/UDB Databases) at "Importing Database Contents using PeopleSoft DataMover" for SQL Server section.
"Run PeopleSoft Data Mover in bootstrap mode against the new database. Login in bootstrap mode using the OwnerID and password. Once signed in, run the following script:
SET NO TRACE;