To create a new database, set the "Create new database" radio button:

Create_Update_dialog

Press "Next".

You need to install/update all necessary SQL Server extended procedures/modules for proper functioning of the Cinegy Archive database.

Upgrade Extended Procedures

In the "Messages" tab, service messages are shown.

Caution
After installing all the server components, you should use Cinegy Enterprise Manager to configure the database before you go on to the client installations and their connection.

Press the "Next" button to proceed with the creation options.

Then select the database version from the drop-down list and press the "Next" button.

version_create

Next choose if you want to create a new database or overwrite an existing one:

existing_DB

You can change a metadata descriptors set for the database you are creating by choosing the desired one from the drop-down list. The "Cinegy" metadata descriptors set is defined by default. Alternatively you can copy the metadata configuration from the existing database by ticking off the corresponding option and choosing the source database from the drop-down list.

New Database

To create a new database, choose the "Create New Entry" option, enter the database name and press the "Next" button to proceed:

new database
Note
The name of a new database must be unique.

Press "Next" to proceed.

settings_default

This dialog provides you with the database creating settings. You can apply default settings or select the "Advanced" mode to modify the "Database Files" and "Collation" options.

Recovery Model

Recovery models are designed to control the transaction log maintenance. You can set one of the following recovery models:

  • Simple – no transaction log backups are supported; only the most recent full backup can be restored.

  • Full – transaction log backups and full, differential, incremental and partial backups of the database are supported, allowing you to restore a database to any point of time.

  • Bulk-logged – similar to the full recovery model, but the bulk operations are minimally logged.

Important
Refer to the Microsoft SQL Server 2008 Operations Guide to read more about recovery models.

Database Files

The data and log information are stored in separate files. With advanced mode selected, you can browse for the folders where the operating-system files will be stored.

Collation

Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width. To change the default collation, in the advanced mode tick off the "Collate" option and select the desired service from the drop-down list that appears.

Having set up all the creating settings, press the "Next" button to proceed.

DBwizard_create new DB

Here you can enable "Full-Text Catalog" or/and install search phrase corrector for the current database. To do this, check the corresponding option(s).

Note
Dictionary for the search phrase corrector feature is saved in the Cinegy Archive database. This functionality works only for English and uses only English dictionary. To change the dictionary (e.g. add custom words), direct work with databases and tables is required.
Important
Refer to the Full-Text Service article in the Cinegy Enterprise Manager Manual for details.

Press the "Next" button to proceed:

DBwizard_new_new_summary

The summary dialog allows you to review the decisions that you made for the database being created. To make changes, use the "Back" button to return to previous steps of the wizard. Press "Finish" to begin the creation of the database.

After the creation process is completed, press Show details on the "End of processing" step of the wizard to view the detailed summary of the database creation:

DBwizard_end_processing

save_log_button

Use the "Save Log" button to generate the text log file containing the procedure details about the database creation process.

File Locations Management

DB_wizard_settings_button

Press "Settings>>" to set up the network shared storages configuration:

DBwizard_network_share

DB_wizard_add_new_button

To add a new network share, press the "Add new" button; the following dialog box appears:

28_DBM_filelocation_shares_browse

Use the DB_wizard_dots_buttonbutton to select the path to a new network shared storage or enter the path via the keyboard in the "Share name" field.

Caution
Never use the same file locations for different databases. This may cause deletion of files in another Cinegy Archive database!
Caution
The base path for different media file type shares nested inside each other cannot be used as file locations; this will lead to the incorrect results when performing the consistency checking operations and to the accidental deletion of media files.

DB_wizard_delete_button

To remove the selected network share, press the "Delete" button.

To relocate the network share, enter a new path in the "with new path" field or browse for it via the DB_wizard_dots_buttonbutton. You can apply the path changes to all of the shares at once or separately to the selected one, by switching between "set path for all shares" and "set path for every share individually" options correspondingly.

DB_wizard_apply_button

Use the "Apply" button to apply the network share location changes.

Details about network shared storages are represented in the bottom part of the "Cinegy Archive Database Wizard" dialog box in the table view. Every share is automatically assigned its own "Share ID" that is used by the system and cannot be changed. The storage status and its consumption are shown in the right columns of the table. When the free space of the storage is less than 20% of total space, the status is displayed as "!critical".

DB_wizard_network_share_table

DB_wizard_refresh_button

To update the network shared storages information preview, press the "Refresh" button.

DB_wizard_settings_button

Press "Settings>>" to assign the file types used in Cinegy Archive to the network shared storages:

DBwizard_network_share_2nd

DB_wizard_add_new_button

Press the "Add new" button to assign a file type to a file share by choosing the required type and share from the pull-down lists.

DB_wizard_filetype_path_add

DB_wizard_delete_button

To delete the selected link, press the "Delete" button. You will be asked to confirm your decision.

DB_wizard_delete_link

DB_wizard_finish_button

Press the "Finish" button in Cinegy Archive Database Wizard to complete the database configuration.

Important
To change the network storage locations and reassign the media archive file types, use the "File types and locations" configuration group within Cinegy Enterprise Manager. Refer to the File Types and Locations article in the Cinegy Enterprise Manager Manualfor details.

Overwriting the Existing Database

To create a new database using the existing empty one, click the "Overwrite pre-existing Database" option, then select the preferred database from the list of active SQL Server databases and press the "Next" button to proceed.

It is not allowed to create a database from the one that already contains metadata. In this case, the following warning message will appear:

warning

Press the "Next" button to proceed with the installation settings:

Create_full-text_tagged

Here you can install search phrase corrector for the current database. To do this, check the corresponding option(s).

Note
Having installed the fuzzy search phrase corrector, restart the SQL Server.
Important
Dictionary for the search phrase corrector feature is saved in the Cinegy Archive database. This functionality works only for English and uses only English dictionary. To change the dictionary (e.g. add custom words), direct work with databases and tables is required. Refer to the Full-Text Service article in the Cinegy Enterprise Manager Manual for details.

Press the "Next" button to proceed.

create_DB_summary_existing

The summary dialog allows you to review the decisions that you made for the database you are creating. To make changes, you can use the "Back" button to return to previous steps of the wizard. Press "Finish" to begin the creation of the database.

After the creation process is completed, press Show details on the "End of processing" step of the wizard to view the detailed summary of the database creation:

DBwizard_end_processing2

save_log_button

Use the "Save Log" button to generate the text log file containing the procedure details about the database creation process.

DB_wizard_settings_button

Press \"Settings>>" to set up the network shared storages configuration as it is described above.

Important
To change the network storage locations and reassign the media archive file types, use the "File types and locations" configuration group within Cinegy Enterprise Manager. Refer to the File Types and Locations article in the Cinegy Enterprise Manager Manualfor details.