Using the SQL Server Migration Tool

The SQL Server Migration Tool migrates the existing CodeBase database to a SQL database using SQL Server 2008 R2 SP2 Express.

Tip:

After migrating the OfficeScan database, you can move the newly migrated SQL database to a different SQL Server. Rerun the SQL Server Migration Tool and select Switch to an existing OfficeScan SQL database to use the other SQL Server.

  1. On the OfficeScan server computer, browse to <Server installation folder>\PCCSRV\Admin\Utility\SQL.
  2. Double-click SQLTxfr.exe to run the tool.

    The SQL Server Migration Tool console opens.

  3. Choose the migration type:
    Option Description

    Install a new SQL Server 2008 R2 SP2 Express and migrate the OfficeScan database

    Automatically installs SQL Server 2008 R2 SP2 Express and migrates the existing OfficeScan database to a new SQL database

    Note:

    OfficeScan automatically assigns port 1433 to the SQL Server.

    Migrate the OfficeScan database to an existing SQL Server

    Migrates the existing OfficeScan database to a new SQL database on an existing SQL Server

    Switch to an existing OfficeScan SQL database

    Changes the OfficeScan configuration settings to point to an existing OfficeScan SQL database on an existing SQL Server

  4. Specify the Server name as follows:
    • For new SQL installations: <host name or IP address of the SQL Server>\<instance name>

    • For SQL Server migrations: <host name or IP address of the SQL Server>,<port_number>\<instance name>

    • When switching to an existing OfficeScan SQL database: <host name or IP address of the SQL Server>,<port_number>\<instance name>

    Important:

    OfficeScan automatically creates an instance for the OfficeScan database when SQL Server installs. When migrating to an existing SQL Server or database, type the preexisting instance name for the OfficeScan instance on the SQL Server.

  5. Provide the authentication credentials for the SQL Server database.
    • When using the Windows Account to log on to the server, the User name must use the following format:

      domain_name\user_name or user_name

      Important:

      The user account must belong to the local administrator group or Active Directory (AD) built-in administrator and you must configure the following User Rights Assignment policies using the Windows Local Security Policy or Group Policy Management console:

      • Log on as a service

      • Log on as a batch job

      • Log on locally

      The user account must also have the following database roles:

      • dbcreator

      • bulkadmin

      • db_owner

  6. For new SQL Server installations, type a new password and confirm.
    Note:

    Passwords must meet the following minimum strength requirements:

    1. Minimum length: 8 characters

    2. Must contain at least 3 of the following:

      • Uppercase letters: A - Z

      • Lowercase letters: a - z

      • Numbers: 0 - 9

      • Special characters: !@#$^*?_~-();.+:

  7. Specify the OfficeScan Database name on the SQL Server.

    When migrating the OfficeScan CodeBase database to a new SQL database, OfficeScan automatically creates the new database with the name provided.

  8. Optionally, perform the following tasks:
    • Click Test Connection to verify the authentication credentials for the existing SQL Server or database.

    • Click SQL Database Unavailable Alert… to configure the SQL database notification settings.

      For details, see Configuring the SQL Database Unavailable Alert.

  9. Click Start to apply the configuration changes.