PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PeopleSoft Unicode SQL Server DB - Converting NCHAR data types to NVARCHAR

edited Jul 4, 2017 5:04AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

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; 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center