Doors.NET - Migrating a System

Doors.NET - Migrating a System

Migrating a Doors.NET System

DNET to DNET Conversion

 

There are several steps that need to be taken to successfully transfer a Doors.NET installation onto a different host PC.

It is important that these steps are performed in the exact order that they are listed:

 
Note:

  • The version of SQL Server on the new machine must be the same or a later version (as Microsoft does not provide a downgrade path for SQL Server and their associated databases). For example; you can go from SQL 2005 TO SQL 2012 but you cannot use an SQL 2012 database and use it in an SQL 2005 Server.

  • The new host PC will be required to have SQL Studio Manager installed. This can be installed very easily via the License Manager, once the Doors.NET software has been installed.

  • When migrating your Doors.NET system to a new PC and you are using encrypted administrator passwords (Doors.NET v4.0.3 onwards), be aware that you will need to re-use your existing license key as the database is linked to it. 

    Contact Keri Systems inside sales with your existing Doors.NET license key and it will be modified so that it can be re-activated on the new PC.

 

1.0Backup the Current Database
  1. Create a backup of the current installation by going to Tools >> Backup in Doors.NET.
  2. Once you have created the backup, you will be prompted to go to the backup file location.
  3. Copy the .bak file onto a memory stick or other storage device/network location.

 

2.0Install Doors.NET Software on the new PC

Note: You will need to be logged into the Kerisys.com website to download software.

Note: If you are using and also migrating the Photo ID badging client you should refer to the section at the end of the article. You will need to perform a custom install and ensure you select to install the Photo ID Client.
  1. Download the latest version of the Doors.NET software - or request a installation DVD or USB thumb drive from Keri Systems. The most up-to-date version of the Doors.NET software can be downloaded from here: http://www.kerisys.com/pages/download/software/#DoorsNET.
  2. Ensure the new PC meets all the specification requirements for running Doors.NET.
  3. Ensure the new host PC is up-to-date with all the latest Windows updates.
  4. If you have any anti-virus software running, Keri recommends temporarily switching it off while you are running the installation and then adding Door.NET as an exception once the software has successfully installed and the PC has rebooted.
  5. For installation, ensure you have full administrative rights on the new PC.
  6. Install the Doors.NET software on the new PC.
  7. Once the software installation has completed, you will be prompted to open the License Manager/run the License Wizard.

 

3.0License Doors.NET on the New PC

Once installation has completed you will need to activate the existing Doors.NET license on the new PC.

  1. Once installation has completed you will be prompted to run the License Manager.
  2. You will need to re-use the old Doors.NET license key on the new PC. Contact Keri Systems inside sales with your existing Doors.NET license key and it will be modified so that it can be re-activated on the new PC.
  3. You can find the current Doors.NET license key by opening The License Manager (Start Menu >> Doors.NET >> License Manager.
  4. When the license manager opens, click on the License tab.
  5. Your license key will appear beneath the system settings and capacities list.
  6. Make a note of your license key.

    License Key

  7. Once you have contacted Keri systems and have spoken with inside sales, you will then be able to activate the license on the second PC.
  8. In the licence activation wizard on the new PC, enter the license key (taken from the old PC).
  9. Once you have your license key you can then copy and paste the key into the fields shown below. Put the cursor into the first text field, then paste.
  10. Next is the registration page. Enter information about the site and installer contact details.
  11. You will then see a summary page. Click next to complete the task.
  12. Within a few seconds you should see a registration successful notification. Click OK to this.
  13. The next notification is to restart/start the Application Server Windows Service. Click Yes to this.
  14. Once the Application Service service has restarted you will be prompted to install the hardware communication gateway services plus any other Doors.NET feature that requires a Windows service. Click the Yes button to install the services.

    License Manager - Image  8

  15. When the Doors.NET Windows services have successfully been installed the License Manager will automatically open.
  16. The software is now fully activated and ready for the next step.

 

4.0Delete the Default Database on the New PC

If you have done a new install of Doors.NET on a brand-new PC, chances are that you have also selected to install SQL Express and the default SQL database. You will therefore now be required to remove the default database from the new PC so that you will be able to attach the backup file(s) from the previous PC.

  1. On the new PC, open SQL Studio Manager (right-click and 'Run as Administrator').
  2. You will have to wait a short while if it is the first time you have run the program.
  3. Log into Studio Express using the ECLIPSE instance.

    Studio Manager Connect

  4. Navigate to the DHS_MAIN database. This database (and the ECLIPSE instance are installed automatically when you select to install the database along with the Doors.NET software).
  5. Right-click the DHS_MAIN database and select to Delete. The database will be removed from Studio Manager and the database files will also be removed from the PC.
  6. You are now ready to attach the database which was backed up in step 1.0.

 

5.0Restore the Backup Database

You can now attach the backup database file but for now, minimise SQL Studio Express.

NOTE: It is important to know that due to limitations imposed by Microsoft, you will not be able to use a newer database on an older version of SQL/SQL Express (as there is no downgrade path for SQL databases). For example; you CAN use an SQL 2008 database on SQL 2014, but you CANNOT use an SQL 2014 database on SQL 2008.

  1. Insert the USB drive into the new PC (or other storage device which has the Doors.NET backup).
  2. Locate the Doors.NET backup file on the storage device (.bak file).

    Backup File

  3. On the new PC, copy the backup file into the following location:

    C:\Program Files\Microsoft SQL Server\MSSQL13.ECLIPSE\MSSQL\Backup - (on a 32-bit OS)
    C:\Program Files (x86)\Microsoft SQL Server\MSSQL13.ECLIPSE\MSSQL\Backup - (on a 64-bit OS)

  4. Restore the SQL Studio Manager window.
  5. Right-click Databases and select Restore Database...

    Restore DB

  6. Set the source as Device.
  7. Click the browse icon Brwose Icon.
  8. Click the ADD button.
  9. Select the database file which you have copied across to the PC.

    Add the Backup File

  10. Click OK.
  11. Click OK again.
  12. The restore plan information should be similar to what is displayed below:

    Restore Plan Info

  13. Click OK at the bottom of the Restore Database window.
  14. You may need to be patient at this point if you are restoring a large database. Eventually you should see a message stating the database has been restored successfully.

    DB Restored Successfully

  15. The next step is to run the gateway wizard.

 

6.0Run the Gateway Wizard

You are now required to run the gateway wizard (to associate the gateway in the database with the windows service that is installed on the new PC). Until you do that your controllers will not come online.

  1. From the Windows start menu, navigate to the Doors.NET subfolder.
  2. Right-click Gateway Wizard and 'Run as Administrator'.

    Gateway Wizard

  3. The gateway wizard log in window will open.
  4. From the gateway selection drop-down list, select the gateway type to match the hardware type that is installed.

    NOTE: For NXT Mercury-Powered controllers, select the option: 'MSC - SCP Series'

  5. Enter the Doors.NET username and password (default - both areadmin), click Connect.
  6. Select the gateway from the Existing Gateways section on the left. Click Next.
  7. Click Finish and you will be prompted to start the gateway windows service.

    Gateway Service Started

  8. The system is now fully restored on the new PC.
  9. Log into the admin client to check that your controllers are online.

    Controllers Online

 

The final step is to manually update the Doors.NET database.

 

7.0Run UpdateDHSDB
  1. First, locate the UpdateDHSDB executable file which can be found in the following default location on a typically installation: C:\Keri\DoorsNET. Double-click to open the application. You may need to wait a few moments for it to initialize.

    UpdateDHSDB_1

  2. When the UpdateDHSDB window appears, "Upgrade existing database" will be pre-selected so just leave it on this selection.

    UpdateDHSDB_2

  3. Choose the server on which the SQL database resides, then select DHS_MAIN under "Database". In most cases the name of the host PC will be the only available option. Deselect 'Backup Target Database' unless you wish to create a backup. Click on "Next", then "Finish."

    UpdateDHSDB_3

  4. Allow the program to run. As it does, it looks for changes that need to be applied to the SQL database table and automatically makes those changes.

    UpdateDHSDB_4

  5. The database updating should take no more than a minute to complete, however, on a large system (with a lot of events, controllers and cardholders) it may take a few minutes. When it has successfully completed, click on Exit to finalize the procedure.

    UpdateDHSDB_5

If You are Using Photo ID (Badging) Client

If you use the Photo ID client on your system to create and print badges you will need to do the following:
  1. Revoke the Photo ID license from the old host PC.
  2. Ensure you install the Photo ID client when you install the Doors.NET software on the new host PC.
  3. Re-activate the Photo ID license on the new host PC.
  4. You will need to copy across the cardholder images from the old host PC (typically the cardholder photos are stored at C:\Keri\DoorsNET\Photos).
  5. You should also copy across the card templates from the old host PC (typically the templates will be stored at: C:\Keri\DoorsNET\Templates).
  6. Once you have setup everything on the new host PC, if you do not see any cardholder images in the Photo ID client you should restart all the Doors.NET windows services.

    • Related Articles

    • Doors.NET - Full Manual

       1.0 Introduction   Welcome to the Doors.NET full manual. This comprehensive document covers everything you would need to know to setup and use a standard Doors.NET access control system and the NXT-MSC controller types. The document consists of ...
    • Restore the Doors.NET Database

        1.0 Instructions for Restoring the Doors.NET SQL Database Notes: - performing this task will completely overwrite ALL data in the existing Doors.Net database. - this backup procedure pertains to Doors.Net databases using Microsoft SQL Server 2012 ...
    • Backup the Doors.NET Database

      This guide explains how to quickly and easily create a backup from within the Doors.NET software: In Doors.NET go to: Tools >> Backup. A notification window will inform you that a full system backup will be made. Select YES. You will then be prompted ...
    • Doors.NET - End Users Guide

       Doors.NET End Users Guide (attached)
    • Doors.NET - Software Architecture

      This video provides you with an overview of the system architecture of Doors.NET.