Open topic with navigation
Step 5: Upgrade the database
Caution: When you upgrade the main Chancery 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.
|
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, Chancery SMSDatabase <version>. Click Change.
|
|
3
|
In the Database Identification dialog, choose Database Maintenance and click Next.
|
|
4
|
In the second Database Identification dialog [Figure 172], 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 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.
|
|
7
|
Select Install Chancery SMS Task Manager.
|
|
9
|
To complete the process, follow the on-screen instructions.
|
|
10
|
When the database installation is complete, click Exit [Figure 172].
|
Pearson
Always Learning
www.pearsonschoolsystems.com
Tel: 866-434-6276
Email: psstechsupp@pearson.com
