Re: Migration of DB from DB2 to MS SQL Server
edited Jul 18, 2020 5:11AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 14 commentsAnswered
Problem Summary
---------------------------------------------------
PS_PT_WF_NOTFY_TBL duplicate rows in SQL Server
Problem Description
---------------------------------------------------
We are converting our peopleSoft HCM database from DB2 to SQL Server.
We are using a DMS script to export the tables from DB2, and then another DMS script to import the tables into SQL Server.
When we attempt to import the PS_PT_WF_NOTFY_TBL table, it blows up creating the unique index PS_PT_WF_NOTFY_TBL.
When we look at the data in SQL Server, we get several rows with the same CREATEOPRID, CREATEDTTM, and LANGUAGE_CD entries.
When we look in our DB2 database, we do not see these duplicate rows.
2