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 you specified in an earlier step [see Create a shell to hold the Historical Database >>]. To enable you to adjust historical information and run reports [>>] on the Historical Database, you must set up PowerSchool SMS to connect to the Historical Database.

To set up access to a Historical Database [You can do this if your role is District Administrator.DA]:

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.

To set up access to a Historical Database on the same server as the Active Database: [You can do this if your role is District Administrator.DA]

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.

www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com

Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.