Modifying the database for non-english searches – Grass Valley Aurora Browse v.7.0 Installation User Manual
Page 150
150
Aurora Browse Installation and Configuration Guide
April 6, 2010
Chapter 6 Database and Recovery Planning
9. Replace all occurrences of the old server name with the new server name, and save
the file.
10.In SSMS, right-click on
Integration Services Stored Packages| MSDB|Maintenance
Plans
.
11.From the context menu, select
Import Package
.
12.Specify the same path as you did in step 6.
13.If the modified maintenance plan has the same name as the original, a warning is
displayed indicating that the Maintenance Plan will be overwritten. Click
OK
.
CAUTION: Do not import the package file (e.g.
MediaFramemaintenancePlan.dtsx) into another maintenance plan.
Modifying the database for non-English searches
To enable the MediaFrame database to allow searches in languages such as Chinese,
the database needs to be modified. Because it will take some time to re-index the data,
this procedure should be performed when the system is not in prime use. This
procedure will not affect operations aside from search functionality.
To modify the database for non-English searches, follow these steps.
1. Open the Microsoft SQL Server Management Studio tool.
2. Select
Databases | MediaFrame | Tables
.
3. Right-click on the
dbo.MetadataTbl
table.
4. Select
Full-Text Index | Properties
. The Full-Text Index Properties dialog box
displays.
5. Select the
Columns
page.
6. For every column that has a check box, change the language in the Language for