To create new database, select the "Create new database" option and press the "Next" button:

Create_Update_dialog

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

The "File information" tab contains details on the SQL server side file on the top and the Cinegy Database Wizard file on the bottom. The SQL side file and Cinegy Database Wizard file versions should be similar. In case versions don’t match, use the "Update" button to upgrade the database version:

Upgrade Extended Procedures

The "Messages" tab contains service messages:

Service_messages
Caution
After installing all the server components, use Cinegy Archive Manager to configure the database before proceeding with the client installations and their connection.

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

Select the database version from the drop-down list and press the "Next" button:

version_create
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 selecting 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 should be unique.
Important
Refer to the Microsoft SQL Server documentation to get more details on the database naming convention rules.

Press the "Next" button to proceed. In the dialog that appears, configure the database creating settings. You can apply the default settings or select the "Advanced" mode to modify the "Database Files" and "Collation" options:

settings_default

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 to restore a database at 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 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:

DB files

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:

Collation

Having set up all the creating settings, press the "Next" button to proceed. On the window that appears, enable "Full-Text Catalog" or/and install search phrase corrector for the current database. To do this, select the corresponding option(s).

DBwizard_create new DB
Note
The dictionary for the search phrase corrector 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), the direct work with databases and tables is required.
Important
Refer to the Full-Text Service article in the Cinegy Archive Manager Manual for details.

Press the "Next" button to open the summary dialog, that allows 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.

DBwizard_new_new_summary

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 the "Settings" button to open the network shared storages configuration window:

DBwizard_network_share

Use the "Network shared storage settings" window for shared storage paths configuration. You can apply the path changes to all 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.

The "Replace common path" field contains the current path for the selected media share or all shares:

replace_window

Use the DB_wizard_dots_button button to add new subpath to the existing media storage path. Use the DB_wizard_dots_button button to trim the media storage path section.

The "with new path" section is used to define new share location. Use the DB_wizard_dots_button button to select the root path for new storage substructure or enter the path via the keyboard in the field to the right.

Use the DB_wizard_dots_button button to create media storage substructure. The following window appears:

substructure_window

Define the root path, the full path for media storage and select substructure type from the list.

DB_wizard_add_new_button

Press the "Delete" button to delete the selected substructure from the network share.

DB_wizard_add_new_button

Press the "Save new" button to save new substructure for network share path after editing it in the field to the right.

DB_wizard_add_new_button

Press the "Create" button to create new substructures for the selected network share paths.

DB_wizard_add_new_button

Press the "Cancel" button to discard changes and exit.

On the "Network shared storage settings" window you can also add new network shared storage.

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_button button 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_button button.

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 to 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 the "Settings" button 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 drop-down lists.

DB_wizard_filetype_path_add

DB_wizard_delete_button

To delete the selected link, press the "Delete" button. The following confirmation window appears:

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 Archive Manager. Refer to the File Types and Locations article in the Cinegy Archive Manager Manual for details.

Overwriting Pre-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:

DB_wizard_overwrite

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

warning

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 selecting the corresponding option and choosing the source database from the drop-down list.

Having selected an empty database, 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), the direct work with databases and tables is required. Refer to the Full-Text Service article in the Cinegy Archive Manager Manual for details.

Press the "Next" button to proceed.

create_DB_summary_existing

The summary dialog allows to review settings summary 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 the "Settings" button to set up the network shared storages as it is described above.

DB_wizard_finish_button

Press the "Finish" button to close Cinegy Archive Database Wizard.

restart_button

Press the "Restart" button to restart Cinegy Archive Database Wizard.

Important
To change the network storage locations and reassign the media archive file types, use the "File types and locations" configuration group within Cinegy Archive Manager. Refer to the Media Groups, File Types article in the Cinegy Archive Manager Manual for details.