
12 ZENworks 10 Configuration Management System Administration Reference
novdocx (en) 16 April 2010
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 MigratingtheDatafromanEmbedded SybaseSQLAnywheretoanExternalOracle
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 304
34.6.1 Preparing to Move the Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305
3 4 . 6 . 2 M i g r a t i n g t h e D a t a f r o m t h e S y b a s e S Q L A n y w h e r e D a t a b a s e t o a n O r a c l e
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
3 5 . 3 M o v i n g t h e D a t a f r o m O n e E x t e r n a l S y b a s e D a t a b a s e t o a n o t h e r E x t e r n a l S y b a s e
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
3 5 . 4 M o v i n g t h e D a t a f r o m a n E x t e r n a l O E M S y b a s e D a t a b a s e t o a n E m b e d d e d S y b a s e
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