Open topic with navigation

Step 5: Upgrade the database

Caution: When you upgrade the main PowerSchool SMS database, the process also upgrades the tables in the Historical Database, if one exists; some tables may be deleted. Thus, before you update the main database, preserve the Historical Database by backing it up.

Note: When upgrading the database to PowerSchool SMS 8.0 from an older version, the installer displays a Database Update Option dialog that asks the administrator to select a contact matching and merging method. The options are:

For more information, refer to the Converting to PowerSchool SMS 8.0technical bulletin.

To upgrade the database:

1

On the Database Server, from the Start menu, click Control Panel > Add or Remove Programs.

2

In the Add or Remove Programs dialog, select your Database Server, for example, PowerSchool SMSDatabase <version>. Click Change.

3

In the Database Identification dialog, choose Database Maintenance and click Next.

4

In the second Database Identification dialog, select a database and click Update Database.

5

Enter the following information (as it was used to create the database initially):

=

SQL Administrator Password

=

Database Name

=

Database Username: Use the user name of the database owner (dbo), not the SQL administrator.

=

Database Password: Use the password of the database owner (dbo), not the SQL administrator.

6

Click Next.

7

Select Install PowerSchool SMS Task Manager.

8

Click Next.

9

To complete the process, follow the on-screen instructions.

10

When the database installation is complete, click Exit.

Pearson
Always Learning
www.pearsonschoolsystems.com 
Tel: 866-434-6276
Email: psstechsupp@pearson.com