How to Move Video Indexes for a NVR

Introduction

This guide outlines the steps in taking the Video Indexes from one NVR and placing them onto
another.
One reason you may want to do this is if you upgrade a NVR to a newer version of software and want
to keep the current Indexes in place upon the upgrade, using the same machine.
The process for doing this involves creating a batch file to run SQL BCP commands.

Creating the Scripts

You need to create two scripts, one to take the data out and one to put it back in.

Out Script

1. Open Notepad

2. Type the following:

bcp multimaxVideo..VideoIndexTable out VideoIndexTable.bcp –N –E –T
bcp multimaxVideo..PurgeVideoIndexTable out PurgeVideoIndexTable.bcp –N –E –T

3. Save the file as BCPVideoOut.bat (ensure you set the ‘Save as type’ box in Notepad to ‘All
    Files’.

In Script

1. Open Notepad
2. Type the following:

bcp multimaxVideo..VideoIndexTable in VideoIndexTable.bcp –N –E –T
bcp multimaxVideo..PurgeVideoIndexTable in PurgeVideoIndexTable.bcp –N –E –T

3. Save the file as BCPVideoIn.bat (ensure you set the ‘Save as type’ box in Notepad to ‘All
    Files’.

Running the Scripts

The following steps take into account that you already have a Symmetry system with Video. It
assumes you are upgrading the NVR to a newer version of software, leaving all the existing video in
the same location. It also assumes you are making no changes to the settings of the NVR which are
currently configured under its definition settings page.

1. Create the BCPVideoOut.bat file on the current NVR
2. Double click the bat file to run the commands
3. This will create the files VideoIndexTable.bcp and PurgeVideoIndexTable.bcp to the root
    location of where you ran the bat file
4. These files contain the data from the SQL tables. Save to a secure location.
5. Follow the steps in order to upgrade the software for the NVR. Ensuring that during the
    installation you set it to an existing NVR (same one as before) instead of a new defining a
    new one.
6. Create the BCPVideoIn.bat file on the NVR.
7. Copy the files VideoIndexTable.bcp and PurgeVideoIndexTable.bcp from the secure location
    to the root location of where you will run the bat file.
8. Double click the bat file to run the commands.

If you have Microsoft SQL Server Management Studio, you can connect into the MultiMaxVideo
database and look at the VideoIndexTable to check that the data has correctly been added.