Motorola MSP3-CNTRL-SW-100 Software Setup Guide - Page 64

Upgrading the Database Server

Get Motorola MSP3-CNTRL-SW-100 - Mobility Services Platform Control Edition PDF manuals and user guides View all Motorola MSP3-CNTRL-SW-100 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 64 highlights

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

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 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