Open topic with navigation
Creating a Historical Database shell
As part of the automated Year-End Processing [>>] step, PowerSchool SMS copies the existing active database, which then becomes the Historical Database. Before this can happen, the you must create a shell to contain this database using the PowerSchool SMS database installer.
You do not need to create the Historical Database shell until you are ready to run Year-End Processing [>>]. After you run Year-End Processing for the current school year, do not create another Historical Database shell.
|
1
|
On the Database Server, from the Start menu, click Settings > Control Panel > Add or Remove Programs. |
|
2
|
In Add or Remove Programs dialog, select PowerSchool SMS Database <version>, and then click Change. |
|
3
|
In the Welcome dialog, choose Database Maintenance. Click Next. |
|
4
|
In the first Database Identification dialog click Add Database. |
|
5
|
In the second Database Identification dialog, choose Create Historical Database. |
|
6
|
For Active Database Name, select the active database. Enter the database Username and Password. Click Next. |
|
7
|
In the third Database Identification dialog, enter the SQL administrator password. Enter the database name, user name, and password for the Historical Database. Click Next. |
|
8
|
In the fourth Database Identification dialog, in the Database Structure section, choose one of the following: |
|
=
|
To have the installer create the database file groups, select Simple. |
|
=
|
To customize the filegroup layout, select User Defined. |
|
9
|
In the Database Structure Template section, select the appropriate size, database location, and log location. |
|
11
|
To complete the creation of the Historical Database, follow the on-screen instructions. |
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.
