Updating Version 1.0 Databases
Updating Version 1.0 Databases
The log file schema changed after Microsoft Speech Server version 1.0. As a result, version 1.0 databases must be updated. To update Call Viewer and Speech Application Reports databases, either use the command line tool DatabaseUpgrade.exe, or the Database Upgrade tool. Both tools produce the same results. Both approaches are described in the following sections.
To ensure against loss of data, do a full backup before upgrading a log analysis database. For more information, see How to create a database backup in the MSDN Library.
Updating Version 1.0 Reports
A new set of Default Reports is supplied which replaces the version 1.0 Default Reports. To ensure that the latest set of Default Reports is used after a database update, do one of the following:
Manually copy the new .rdl files to the report server folder containing the Speech Application Reports.
On the next database import, specify a different folder for the upload of the report files, and use the reports in the new folder.
Delete the existing reports from the report server folder. They will be replaced by the new reports on the next database import.
Using DatabaseUpgrade.exe to Update Databases
Use the DatabaseUpgrade command-line tool to update either a Call Viewer database or a Speech Application Reports database. DatabaseUpgrade.exe is installed to the folder Program Files\Microsoft Speech Application SDK 1.1\SDKTools\Log Analysis.
Syntax
DatabaseUpgrade /server:value /database:value [/username:value [/password:value]] [/commandtimeout:value]
Part |
Description |
---|---|
/server:value |
Specifies the SQL Server to connect to. Required. |
/database:value |
Specifies the database to connect to. Required. |
/username:value |
Specifies the username for SQL Server authentication. If username is entered, SQL Server authentication is used; if both password and username are blank, Windows authentication is used. Optional. |
/password:value |
Specifies the password for SQL Server authentication. If username is entered and password is blank, SQL Server authentication is used with a blank password. Optional. |
/commandtimeout:value |
Specifies the timeout in seconds for SQL commands executed during the import operation. Defaults to 600 seconds. Optional. |
Note If the entries for the server or database parameters are invalid, control immediately returns to the command line. After a delay an error message appears, stating that a database error occurred.
Example
The following example updates the viewerDB database on the myServer server, using the username loguser and the password pwd, and a commandtimeout of 700 seconds.
DatabaseUpgrade /server:myServer /database:viewerDB /username:loguser /password:pwd /commandtimeout:700
Updating Databases Using the Database Upgrade Tool
Use the Database Upgrade tool to upgrade either a Call Viewer database or a Speech Application Reports database.
To update a version 1.0 database
Click Start, click All Programs, then select Microsoft Speech Application SDK 1.1.
Select Log Analysis Tools, then select Database Upgrade.
In the Database Upgrade tool, in SQL Server specify the SQL Server to connect to.
In Database specify the database to connect to.
Select between Windows or SQL Server authentication. If SQL Server authentication is selected, in Username and Password specify the username and password for SQL Server authentication.
In Query timeout specify the timeout in seconds for SQL commands executed during the import operation. By default this value is 600 seconds.
Click Upgrade.