The SQL Server Migration Tool migrates the existing CodeBase database to a SQL database using SQL Server 2008 R2 SP2 Express.
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.
The SQL Server Migration Tool console opens.
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
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
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>
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.
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
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:
Passwords must meet the following minimum strength requirements:
Minimum length: 8 characters
Must contain at least 3 of the following:
Uppercase letters: A - Z
Lowercase letters: a - z
Numbers: 0 - 9
Special characters: !@#$^*?_~-();.+:
When migrating the OfficeScan CodeBase database to a new SQL database, OfficeScan automatically creates the new database with the name provided.
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.