Here’s the path to the Oracle backups:
Backup documentation can be found here: Oracle Backup and Restore
Create a datapump:
c:\oracle\scripts Export.bat PSPRODDB filename.dmp
> sqlplus / as sysdba SYS@PSPRODDB AS SYSDBA> shutdown immediate SYS@PSPRODDB AS SYSDBA> startup c:\oracle\scripts DropSchema.bat PSPRODDB c:\oracle\scripts Import.bat PSPRODDB [dumpfilename] Y
Note: 'Y' in the import will clear settings, useful if copying data over to the test server.
Note: The sqlplus steps insure that all users/connections are not in use. Seems to be necessary most times, so worth doing every time.
For all active students:
SELECT * FROM students WHERE enroll_status = 0
Custom field API:
Unique id of the record, normally the ID column, except for the following:
Basic custom field information is in the fieldstable table. Key fields in this table are:
These values are linked to the customtext and customvarchars tables via the KeyNo field which links to students.dcid.
To look up field names and types from PowerSchool itself: http://powerschool.pcschools.us/admin/home.html?ac=structure