Open topic with navigation
Connecting to the Historical Database
After Year-End Processing [>>], the PowerSchool SMS system works with the Active Database. It has stored the old Active Database as the Historical Database in the location specified by the District Administrator in an earlier step [see Create a shell to hold the Historical Database >>]. To enable administrators to adjust historical information and run reports [>>] on the Historical Database, the District Administrator must set up PowerSchool SMS to connect to the Historical Database.
|
1
|
On a server other than the server on which the current Active Database is installed, install the PowerSchool SMS Database Server [>>]. |
|
2
|
Add a new active database [>>]. |
|
3
|
Replace the new Active Database with the Historical Database created during Year-End Processing
.
|
|
4
|
On any server, install the PowerSchool SMS Web Server [>>].
|
|
5
|
Point the web server to the Database Server where you installed the historical database.
|
It is possible to have the Historical and Active databases running on the same server. However, we do not recommend this setup because any work with the Historical Database (such as reporting, data mapping, or access by large numbers of users) can diminish the performance of the Active Database. Indeed, we recommend that when the Historical Database is not being used the District Administrator stop Replication and Task Manager services.
|
1
|
Add a new active database [>>].
|
|
2
|
Replace the new Active Database with the Historical Database created during Year-End Processing
.
|
|
3
|
Install the PowerSchool SMS Web Server [>>].
|
|
=
|
Ensure that the web server covers all server roles.
|
|
4
|
Set up the Task Manager on one of the other Web or Application Servers to run Database Server tasks
.
|
|
=
|
Change the affinity to 8.
|
Pearson
Always Learning
www.pearsonschoolsystems.com
Tel: 866-434-6276
Email: psstechsupp@pearson.com
[You can do this if your role is District Administrator.DA]: