
MIGRATE THE HP WEB JETADMIN DATA
If you want to point an existing installation of HP Web Jetadmin to use a remote SQL instance,
consider whether the existing HP Web Jetadmin data stored in the SQL Express database needs to be
migrated to what will now be a blank database on a remote SQL instance when the conversion is
complete. The most common technique for migrating the database involves copying and pasting the
database files from one location to another. SQL Server Management Studio contains tools for
backing up the database. HP Web Jetadmin also offers a backup.bat script that backs up the
database as well as other files. The script file resides in the following directory:
C:\Program Files\HP Inc\Web Jetadmin 10\bin\WJABackupRestore\backup.bat
It might be necessary to assign Network Service write permissions in the directory where the database
is being saved.
For Microsoft
®
Windows
®
Vista and Server 2008 R2,
scripts that require administrative access and are run from
the Command Prompt must be executed using the Run as
administrator option.
Remember, to truly migrate an entire HP Web Jetadmin
installation from one machine to another, more than just
the database must be migrated. For more information, see
the Back Up, Restore, and Clone an HP Web Jetadmin
Installation white paper. This white paper is available from
the HP Web Jetadmin support page (in English).
IMPORTANT When restoring the settings and database
information to the HP Web Jetadmin host,
encrypted data no longer functions if the
host or Windows OS instance is different
from the instance that was used to process
the original file-set. A few examples of
encrypted data include device passwords,
SMTP user/password settings, and HTTP
proxy user/password settings. Credential store passwords and saved configuration
file templates are encrypted to secure any passwords that might be stored. To unlock
the encryption, a key that is applicable only to the machine where it was created
must be used. Passwords are too important not to be protected as securely as
possible. Therefore, items pertaining to passwords in configuration file templates must
be recreated on the new HP Web Jetadmin installation because the old files cannot
be unlocked or unencrypted on the new machine if they are manually copied there.
USE A LOCAL SQL SERVER DATABASE
The following sections describe the steps required to instruct HP Web Jetadmin to use a full SQL
Server database that resides on the same machine as the HP Web Jetadmin installation.
Install SQL Server
During the installation, HP Web Jetadmin launches a SQL Express installer executable and runs
commands to create a new instance named HPWJA and a database named HPWJA. If that instance
For HP Web Jetadmin 10.4 and earlier, the folder name in the installation directory path is Hewlett Packard. For HP Web
Jetadmin 10.4 SR1 and later, the folder name in the installation directory path has been changed from Hewlett Packard to HP
Inc.
Komentarze do niniejszej Instrukcji