Embedded Database Maintenance
34
293
n
ov
do
cx (e
n)
16
Ap
ril 20
10
34
Embedded Database Maintenance
Section 34.1, “Retrieving and Storing the Credentials of the Embedded Sybase SQL Anywhere
Database,” on page 293
Section 34.2, “Changing the Ports Used by the Embedded Sybase SQL Anywhere Database,”
on page 293
Section 34.3, “Backing Up the Embedded Sybase SQL Anywhere Database,” on page 295
Section 34.4, “Restoring the Embedded Sybase SQL Anywhere Database,” on page 301
Section 34.5, “Moving the Data from an Embedded Sybase Database to an External Sybase
Database,” on page 302
Section 34.6, “Migrating the Data from an Embedded Sybase SQL Anywhere to an External
Oracle Database,” on page 304
34.1 Retrieving and Storing the Credentials of
the Embedded Sybase SQL Anywhere Database
If you have installed ZENworks
®
10 Configuration Management with the embedded Sybase SQL
Anywhere database that is bundled with ZENworks, we recommend that you store the credentials of
the database for future use.
1
Retrieve the credentials of the embedded Sybase SQL Anywhere database by entering one of
the following commands at the server prompt:
zman database-get-credentials
or
zman dgc
The credentials are displayed on the console.
For more information about zman, view the zman man page (
man zman
) on the server or see
“
zman(1)
” in the
ZENworks 10 Configuration Management Command Line Utilities Reference
.
2
Copy the credentials and save them in a file.
To retrieve and store the credentials of Remote Sybase SQL Anywhere, Oracle, or Microsoft SQL
Server databases, refer to their documentation.
34.2 Changing the Ports Used by the Embedded
Sybase SQL Anywhere Database
Sybase SQL Anywhere uses port 2638 by default. You can change the port on which the database
runs.
1
In the
zenworks_database.conf
file, specify the new port number on which the server
listens to.
The
zenworks_database.conf
file is located in
%
ZENWORKS_HOME%
\conf
on Windows and
in
/etc/opt/novell/zenworks
on Linux.
