Creating New Database
Reading time ~8 minutes
To create new database, select the "Create new database" option and press the "Next" button:
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:
The "Messages" tab contains 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:
Choose if you want to create a new database or overwrite an existing one:
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:
|
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:
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:
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. 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).
|
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.
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:
|
Use the "Save Log" button to generate the text log file containing the procedure details about the database creation process. |
File Locations Management
|
Press the "Settings" button to open the network shared storages configuration window: |
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:
Use the 
button to add new subpath to the existing media storage path. Use the 
button to trim the media storage path section.
The "with new path" section is used to define new share location. Use the 
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 
button to create media storage substructure. The following window appears:
Define the root path, the full path for media storage and select substructure type from the list.
|
Press the "Delete" button to delete the selected substructure from the network share. |
|
Press the "Save new" button to save new substructure for network share path after editing it in the field to the right. |
|
Press the "Create" button to create new substructures for the selected network share paths. |
|
Press the "Cancel" button to discard changes and exit. |
On the "Network shared storage settings" window you can also add new network shared storage.
|
To add a new network share, press the "Add new" button; the following dialog box appears: |
Use the 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. |
|
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 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".
|
To update the network shared storages information preview, press the "Refresh" button. |
|
Press the "Settings" button to assign the file types used in Cinegy Archive to the network shared storages: |
|
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. |
|
To delete the selected link, press the "Delete" button. The following confirmation window appears: |
|
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 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 data. In this case, the following warning message will appear:
Press the "Next" button to proceed with the installation settings:
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.
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:
|
Use the "Save Log" button to generate the text log file containing the procedure details about the database creation process. |
|
Press the "Settings" button to set up the network shared storages 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 Archive Manager. Refer to the Media Groups, File Types article in the Cinegy Archive Manager Manual for details. |