Upgrading Existing Database

Reading time ~2 minutes

Caution
 It is strongly recommended to back up the database before you start its upgrading.

To upgrade an existing database, set the "Upgrade existing database" radio button and press the "Next" button.

upgrate_existing_DB

Install/update all the necessary SQL Server extended procedures/modules for proper functioning of the Cinegy Archive database.

Upgrade Extended Procedures

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

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

Use the drop-down list to select the database you want to upgrade and specify the upgrade version, if available:

choose_DB_to_upgrate

If the selected database has active connections, the following information will be shown in the wizard:

active_connections

show processes_button

Press the "Show Processes" button to view active connections for the current database. The following dialog box appears:
active processes

To proceed with the update operations, select the "continue" checkbox and press the "Next" button. If selected, all the connected users will be forced to disconnect.

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

full_text_and_rebuild_indexes

Here you can enable the "Create Full-Text Catalog", the "Rebuild database indexes" actions or/and "Enable search term/phrase correction option" 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 Archive Manager Manual for details.

Press the "Next" button to proceed.

upgrate_DB_summary

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

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

DBwizard_end_processing_upgrade

save_log_button

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

DB_wizard_finish_button

Press the "Finish" button 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 Media Groups, File Types article in the Cinegy Archive Manager Manual for details.