Motorola Mobility Services Platform 3.2, Software Installation Manual

Page: 64 / 68

58 Chapter 7 – Upgrading a Database Server to SQL Server 2005 Standard or Enterprise
Edition
2. Upgrade your SQL Server instance from SQL Server 2005 Express to SQL Server 2005
Standard or Enterprise
3. If data collection is desired, add Analysis Services to the upgraded SQL Server instance.
4. Upgrade your MSP install if needed, for example:
o
Upgrading from MSP 3.1.x to MSP 3.2
o
Installing the MSP Analysis Database
Upgrading the Database Server
Important:
Motorola provides batch files that can perform the following tasks. If you are
upgrading from 3.1.x, you can use
UpgradeSQLEXPRESSInstanceToSQLStd.bat. If you are upgrading from 3.2,
you can use UpgradeMSPInstanceToSQLStd.bat.
If you intend to use the Motorola-provided batch file to upgrade your
database, copy the appropriate file from the MSP Installation CD
(Prerequisite\SQLBatchFiles\
[appropriate file] ) to a folder on the local hard
drive (for example; C:\BatchFiles) before completing the following steps.
If you are installing on a VMWare image, you may need to refresh the CD
drive after ejecting the MSP Installation CD in order to see the contents of the
SQL CD when it is placed in the CD drive. One possible check is to perform a
dir command on the CD drive before running the batch file.
5. Use the MSP Admin Tool (Figure 51) to stop all of the MSP Services.
6.
Figure 51