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.4.3 from a version older than 8.0, the installer displays a Database Update Option dialog that asks you to select a contact matching and merging method. The options are:

For more information, refer to Converting to PowerSchool SMS 8.0.

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 SMS Database <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.

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.