1.0 Introduction

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 2016 TO SQL 2019 but you cannot use an SQL 2019 database on an SQL 2016 database engine.
  
  
• 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. 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. 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.

3.0 Install Doors.NET Software on the new PC

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

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.

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

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

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).
   
   
   
   
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...
   
   
   
   
6. Set the source as Device.
7. Click the browse icon .
8. Click the ADD button.
9. Select the database file which you have copied across to the PC.
   
   
   
   
10. Click OK.
11. Click OK again.
12. The restore plan information should be similar to what is displayed below:
    
    
    
    
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.
    
    
    
    
15. The next step is to run 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'.
   
   
   
   
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.
   
   
   
   
8. The system is now fully restored on the new PC.
9. Log into the admin client to check that your controllers are online.
   
   

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

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.
   
   
   
   
2. The database select window will appear.
3. The server name will default to the local host PC name.
   
   
   
   
4. Select DHS_MAIN from the Databases list.
   
   
   
   
5. Deselect 'Backup Target Database' unless you wish to create a backup. Click on "Next", then "Finish."
   
   
   
   
6. 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.
   
   
   
   
7. 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.