12
ZENworks 10 Configuration Management System Administration Reference
n
ov
do
cx (e
n)
16
Ap
ril 20
10
34.2 Changing the Ports Used by the Embedded Sybase SQL Anywhere Database . . . . . . . . . . 293
34.3 Backing Up the Embedded Sybase SQL Anywhere Database . . . . . . . . . . . . . . . . . . . . . . . 295
34.3.1
Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux
Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 295
34.3.2
Backing up the Embedded Sybase SQL Anywhere Database Running on a Windows
Server to a Network Location on a Remote Windows Machine. . . . . . . . . . . . . . . . 297
34.3.3
Backing up the Embedded Sybase SQL Anywhere Database Running on a Linux
Server to a Network Location on a Remote Linux Machine. . . . . . . . . . . . . . . . . . . 299
34.4 Restoring the Embedded Sybase SQL Anywhere Database. . . . . . . . . . . . . . . . . . . . . . . . . 301
34.4.1
Restoring the Embedded Sybase SQL Anywhere Database on a Windows Server 301
34.4.2
Restoring the Embedded Sybase SQL Anywhere Database on a Linux Server . . . 302
34.5 Moving the Data from an Embedded Sybase Database to an External Sybase Database . . 302
34.5.1
Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303
34.5.2
Moving the Data from the Internal Sybase to the External Sybase . . . . . . . . . . . . . 303
34.6 Migrating the Data from an Embedded Sybase SQL Anywhere to an External Oracle
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 304
34.6.1
Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305
34.6.2
Migrating the Data from the Sybase SQL Anywhere Database to an Oracle
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 306
34.6.3
Post-Migration Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 308
34.6.4
Troubleshooting Database Migration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309
34.6.5
Reverting to the Sybase Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311
35 External Database Maintenance
313
35.1 Backing Up the External Sybase Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313
35.1.1
Backing Up the External Sybase Database on a Windows or Linux Server . . . . . . 313
35.1.2
Backing up the External Sybase Database Running on a Windows Server to a Network
Location on a Remote Windows Machine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 316
35.1.3
Backing up the External Sybase Database Running on a Linux Server to a Network
Location on a Remote Linux Machine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 319
35.2 Restoring the External Sybase Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 322
35.3 Moving the Data from One External Sybase Database to another External Sybase
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323
35.3.1
Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323
35.3.2
Moving the Data from One External Sybase to Another External Sybase. . . . . . . . 324
35.4 Moving the Data from an External OEM Sybase Database to an Embedded Sybase
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 325
35.4.1
Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 325
35.4.2
Moving the Data from the External Sybase to the Embedded Sybase . . . . . . . . . . 325
35.5 Configuring the ZENworks Server to Point to the New MS SQL Database Containing Data Moved
from Another MS SQL Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327
35.5.1
Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327
35.5.2
Configuring the ZENworks Server to Point to the New MS SQL Database. . . . . . . 328
35.6 Configuring the ZENworks Server to Point to the New Oracle Database Containing Data Moved
from Another Oracle Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 328
35.6.1
Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 328
35.6.2
Configuring the ZENworks Server to Point to the New Oracle Database . . . . . . . . 329
36 Database Best Practices and Tips
331
36.1 Database Best Practices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
36.1.1
Rebuilding the Embedded or External Sybase Database . . . . . . . . . . . . . . . . . . . . 331
36.2 Database Tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 334
36.2.1
Changing the Backup Location and Schedule of the Embedded Sybase Database
Subsequent to the Initial Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 334