Upgrading database on ms sql server 2000, Upgrading database on ms sql server 2000 16 – Oracle Audio Technologies 8.1 User Manual
Page 18
Contact Center Anywhere Installation Guide Version 8.1
Configuring the Database
■
Configuring a MS SQL Server 2000 Database
16
After editing the batch file, it returns to the following:
echo off
CHCP 437
rem %1
rem %2
rem %3
rem %4
rem %5
rem %6
rem %7
rem %8
rem %9
rem %10
java -jar DatabasePopulation.jar -hostname=support-db -username=cc81 -
password=cc81 -databasePortNumber=1433 -databaseName=cc81 -saUsername=sa -
saPassword=sa -dbPath=C:\databases -remoteDatabase=false
echo on
3
Open a command prompt, and run the batch file in the Command line window.
4
After the batch file completes running, check log files created in the same folder with the batch
file to verify that no error is reported during the database creation process.
Upgrading Database on MS SQL Server 2000
Complete these steps to upgrade an older Microsoft SQL Server database for CCA:
To upgrade an older MS SQL Server database:
1
Copy the Patch directory for Ms SQL Server from the installation package to the host used to
run database scripts. For example, we put it in C:\CCA\database\Sql Server\Patch.
2
Edit the runmePatch.bat batch file to reflect the correct information that is necessary to
upgrade the database by using the following guidelines:
NOTE: For Chinese and Japanese languages, use the corresponding batch file.
■
Replace %1 with the host name of the database server.
■
Replace %2 with the sa username. By default it is sa.