Make sure that all the tasks listed in Section 7.1, Preparing to Move the Data are completed.
Run the database migration utility.
On the Windows Primary Server: At the command prompt, go to ZENworks_installation_path\bin\, then enter the following command:
novell-zenworks-configure.bat -c DBMigrateConfigureAction
On the Linux Primary Server: At the console prompt, go to /opt/novell/zenworks/bin, then enter the following command:
novell-zenworks-configure -c DBMigrateConfigureAction
Select the target database type as sql-server.
Enter the IP address or host name of the MS SQL database server.
Enter the port used by the MS SQL database server.
(Optional) Enter the named instance for the MS SQL Server engine.
Choose to create a new database or use an existing database on the MS SQL server.
If you choose to create a new database, continue with Step 8.
If you choose to use an existing database, skip to Step 9.
(Conditional) If you choose to create a new database in Step 7, perform the following tasks:
Select the authentication type (Windows or SQL Server) to be used for the database administrator user.
Enter the database server administrator username.
Enter the database server administrator password.
(Conditional) If you choose Windows authentication in Step 8.a, enter the database administrator’s domain name.
Select the authentication type (Windows or SQL Server) to be used for the database access user.
Enter the database access username.
Enter the database access user password.
(Conditional) If you choose Windows authentication in Step 9, enter the database access user’s domain name.
Enter the name of the database on the MS SQL server to which you want to migrate the data. If you choose to create a new database in Step 7, the database is created on the MS SQL server with the name that you specify in this step.
(Conditional) If you choose to create a new database in Step 7, enter the complete path where you want the database to be created. You must select the existed folder.
The database migration starts.
When the database migration is complete, you can verify the novell-zenworks-configure.log file to see if the migration was successful. The log file is located in %ZENWORKS_HOME%\log\ on the Windows Primary Server and in /var/opt/novell/log/zenworks/ on the Linux Primary Server.
Remove the Novell ZENworks Embedded Datastore service from the device that has the internal Sybase database installed:
On the Windows device: Perform the following tasks:
At the server prompt, execute the following command:
sc delete SQLANYs_ZENDatastore
Edit the%ZENWORKS_HOME%\conf\monitor.conf to remove dbsrv10 from the line highpriority=zenserver,casaserver,dbsrv10.
On the Linux device: Perform the following tasks:
Stop the Novell ZENworks Embedded Datastore service by executing the following command at the console prompt:
/etc/init.d/sybase-asa stop
Rename sybase-asa to sybase-asa1 by executing the following command:
mv sybase-asa sybase-asa1
Edit the /etc/opt/novell/zenworks/monitor.conf to remove sybase-asa from the line services=novell-zenserver novell-zenload sybase-asa.
After the database is successfully migrated, continue with Section 7.3, Post-Migration Tasks.
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_HOME%\bin directory on the Windows Primary Server, and in the /opt/ novell/zenworks/bin directory on the Linux Primary Server.
Run the database migration utility.
On the Windows Primary Server: At the command prompt, go to ZENworks_installation_path\bin\, then enter the following command:
novell-zenworks-configure.bat -c DBMigrateConfigureAction
On the Linux Primary Server: At the console prompt, go to /opt/novell/zenworks/bin and enter the following command:
novell-zenworks-configure -c DBMigrateConfigureAction
Enter the target database type as sql database server.
Enter the IP address or host name of the MS SQL database server.
You must specify the IP address or host name of the MS SQL database server used while migrating the database. For example, if you had specified the IP address of the database server while migrating the database, then you must specify the same IP address while resuming the database migration. You cannot specify the host name of the database server.
(Optional) Enter the named instance of the MS SQL Server engine.
Choose to use an existing database.
Enter the credentials of the database user depending on the authentication mode selected.
Enter the database name.
Choose to resume the database migration.
The database migration starts.
After the database is successfully migrated, continue with Section 7.3, Post-Migration Tasks.