Embedded Database Maintenance
307
n
ov
do
cx (e
n)
16
Ap
ril 20
10
Migrating the Data from the Sybase SQL Anywhere Database to an Oracle Database
1
Make sure that all the tasks listed in
Section 34.6.1, “Preparing to Move the Data,” on page 305
are completed.
2
Run the database migration utility.
On Windows:
At the command prompt, go to
ZENworks_installation_path
\bin\novell-zenworks-configure.bat
file and
enter the following command:
novell-zenworks-configure.bat -c DBMigrateConfigureAction
On Linux:
At the console prompt, go to
/opt/novell/zenworks/bin
and enter the
following command:
novell-zenworks-configure -c DBMigrateConfigureAction
3
Enter the target database type as Oracle.
4
Enter the IP address or host name of the Oracle database server.
5
Enter the port used by the Oracle database server.
6
Enter the fully qualified net service name for the Oracle database.
7
You can choose to create a new user schema or use an existing user schema.
If you choose to create a new schema, continue with
Step 8
.
If you choose to use an existing user schema, skip to
Step 9
.
8
Enter the database server administrator's username and password.
9
Enter the schema name when prompted for the database username.
10
Enter the database schema password when prompted for the database user's password.
The database migration starts.
11
When the database migration is complete, you can check the
novell-zenworks-
configure.log
file to see if the migration was successful. The log file is located in
%
ZENWORKS_HOME
%\log\
on Windows and in
/var/opt/novell/log/zenworks/
on Linux.
12
After the database is successfully migrated, continue with
Section 34.6.3, “Post-Migration
Tasks,” on page 308
.
Resuming the Database Migration
If the migration of the database is stopped for any reason, the ZENworks migration utility allows
you to resume the migration if the
dbmigration.xml
file has been created. The file is located in the
ZENworks_installtion_path
\bin
directory on Windows, and in the
/opt/ novell/
zenworks/bin
directory on Linux.
1
Run the database migration utility.
On Windows:
At the command prompt, go to
ZENworks_installation_path\bin\novell-zenworks-configure.bat
file and
enter the following command:
novell-zenworks-configure.bat -c DBMigrateConfigureAction
On Linux:
At the console prompt, go to
/opt/novell/zenworks/bin
and enter the
following command:
novell-zenworks-configure -c DBMigrateConfigureAction