JMast
Reputable Poster
Good Morning All,
We are running JDE E1 on Windows SQL Server. When we were on 9.1, I could refresh PY with PD by restoring a full backup of PD. When we moved to 9.2, it became a little more complicated. The new UDO architecture has tables in the JDE920 database with pathcode specific references which need to be considered for the refresh. I am looking for the list of tables in the JDE_CRP/JDE_PRODUCTION database that has data linked to JDE920 or for a script/process for restoring PD to PY while maintaining links. Here is the process I used in 9.1 and would like to continue in 9.2.
- identify tables in JDE_CRP that need to be preserved with PY data
- copy these tables out to a 3rd "utility" database for holding
- drop the JDE_CRP database
- restore the JDE_PRODUCTION backup as JDE_CRP
- update table owners / logins
- restore the saved tables back into the "new" JDE_CRP database
So, in my investigating the UDO tables, there are tables in JDE920 for OMW purposes (I believe), that have unique info for each environment saved in the same table. One option would be to try and copy/update records in those tables. As JDE920 is the system database, I would prefer to not be doing custom updates to that database.
My plan would be that the UDOs and any other tables that fit this description would remain as they were in PY.
This process of restoring from backup is extremely efficient, once the initial scripts are created, allowing PY to be refreshed with between 2 and 3 hours of downtime which means it could even be done during the day if needed. It allows us to refresh more frequently as the business needs change.
Thank you for your time,
Jeremy
We are running JDE E1 on Windows SQL Server. When we were on 9.1, I could refresh PY with PD by restoring a full backup of PD. When we moved to 9.2, it became a little more complicated. The new UDO architecture has tables in the JDE920 database with pathcode specific references which need to be considered for the refresh. I am looking for the list of tables in the JDE_CRP/JDE_PRODUCTION database that has data linked to JDE920 or for a script/process for restoring PD to PY while maintaining links. Here is the process I used in 9.1 and would like to continue in 9.2.
- identify tables in JDE_CRP that need to be preserved with PY data
- copy these tables out to a 3rd "utility" database for holding
- drop the JDE_CRP database
- restore the JDE_PRODUCTION backup as JDE_CRP
- update table owners / logins
- restore the saved tables back into the "new" JDE_CRP database
So, in my investigating the UDO tables, there are tables in JDE920 for OMW purposes (I believe), that have unique info for each environment saved in the same table. One option would be to try and copy/update records in those tables. As JDE920 is the system database, I would prefer to not be doing custom updates to that database.
My plan would be that the UDOs and any other tables that fit this description would remain as they were in PY.
This process of restoring from backup is extremely efficient, once the initial scripts are created, allowing PY to be refreshed with between 2 and 3 hours of downtime which means it could even be done during the day if needed. It allows us to refresh more frequently as the business needs change.
Thank you for your time,
Jeremy