At the end of each school year there is a rollover date determined. This is the date set to officially move the students to the next school year. Glenda works with the Director of schools to identify the official date for this rollover.
Powerschool
A datapump must be done to export the data from the production server. This is completed on the database server and there are scripts to run to get this datapump export.
Powerschool - sandbox
The datapump export will then be imported into the Powerschool Sandbox server. There are scripts to run this import and a support document that describes the process.
Once the export and import have been completed, Glenda will confirm that all data is correct in the sandbox. She will then initiate the rollover on the production server.
OneSync has a setting for Rollover as well. On the rollover date, additional scripts will run during the daily sync to update the graduation year. **If the rollover date for powerschool is before the rollover data in Onesync, you will see username changes with the wrong graduation year calculated. **
Datapump Notes/Steps
#James Saniger
#20220624
#
#Steps for a datapump before rollover for Powerschool.
#This is completed on the production MCSPSDB server for the export
#This is completed on the sandbox PS19 server for the import
#Reference Document
#Oracle Database Backup and Restore Guide
# file:///C:/Users/james.saniger/Downloads/oracle_backup_restore_ug%20(1).pdf
#backups
#On MCSPSDB
#this one takes awhile *30-40 min*
e:\oracle\scripts\psproddb\backup\ps_weekly_backup.bat
Press Enter/Return
# * <30 min *
e:\oracle\scripts\psproddb\backup\ps_daily_backup.bat
Press Enter/Return
#check the rman output log for any errors
e:\oracle\scripts\psproddb\backup\rmanlog.log
#Datapump Export
#On MCSPSDB
# * 10:48am - min*
e:\oracle\scripts\export.bat psproddb 20220624_dataexport.dmp
#Datapump Copy
#On MCSPSDB
e:\oradata\psproddb\data_pump_dir
copy 20220624_dataexport.dmp from datapump folder
#On PS19
c:\oradata\psproddb\data_pump_dir
paste 20220624_dataexport.dmp to datapump folder
#Datapump Import
#On PS19
c:\program files\powerschool
open Powerschool Installer.html
# Stop services
Stop powerschool/powerteacher
click confirm
Stop reportworks
click confirm
# Servvices
services.msc
stop pearson powerschool message service by right clicking and selecting stop
#Backup
#On PS19
cmd prompt
c:\oracle\scripts
# minutes
DropSchema.bat psproddb
# import took hours
importtestserver.bat psproddb 20220624_dataexport.dmp Y
enter/return
#services
services.msc
start pearson powerschool message service by right clicking and selecting restart
#start services
start powerschool/powerteacher
click confirm
start reportworks
click confirm