SERVER MIGRATION/UPGRADE

SERVER MIGRATION/UPGRADE

A. General

  1. This document describes the best practices for moving Scrap Dragon Classic, Scrap Dragon Xtreme, JPEGger and EZCash to a new server.
  2. The goal is to move all of the software programs, configurations and data from the old server to the new server with ZERO downtime.
  3. We pre-install and configure as much of the software as possible onto the new server.  This can be done during the day and doesn't interfere with the normal operations which are on the old server.  Once the software is installed on the new server, we schedule a cutover date & time to move the data.  This is typically done after hours to eliminate downtime.  Programs that must be pre-installed are Microsoft SQL, SDX, JPEGger,  EZCash and Transact Universal Driver (TUD).  Scrap Dragon Classic does not get preinstalled.
  4. To avoid having to make any configuration modifications to the workstations at cutover time, we prefer to assign the name and ip address of the old server to the new server.  If this is not possible or desirable, then each workstation will require some configuration modification, and other devices that reference the server by either name or ip address will also have to be modified.  This may include port forwarding in the router, comm settings in the ATM and path references in document scanners.  An IT Technician or other knowledgeable person must be on site during cutover to make any workstation/device modifications.

B. New Server Preparation

  1. full version of Microsoft SQL is required for SDX, JPEGger and EZCash.  In order to install the SQL product that was on the old server it must be compatible with the Operating System of the new server.  SQL Full text search is required for SDX.  While Microsoft SQL server is typically installed on the same server with SDX, JPEGger and EZCash it doesn't have to be.  It is perfectly acceptable to have Microsoft SQL server running on a different server.  In that case the databases will be moved to that server instead and the SDX, JPEGger and EZCash configuration files will have to be modified to connect to that SQL server.
  2. Install SDX, JPEGger, EZCash and TUD as required. No pre-installation is required for Scrap Dragon Classic.
  3. For SDX Business Intelligence (BI) Reports, IIS must be installed and the Standalone Report Server configured.  
  4. Ports must be opened in the firewall for SDX, JPEGger, EZCash and TUD.
  5. A new empty JPEGger database is created and the JPEGger camera configuration is copied from the old server.
  6. Care should be taken to install the SDX client in the same path as on the old server as that path is being referenced by the workstation shortcuts.  This folder needs to be shared.
  7. Verify that the Old and the New servers can see each other in file explorer.  It must be possible to access the shared folders across the network in file explorer to do the necessary file copying at cutover.
  8. If the ip address is not going to be swapped with the old server, then the new server must be assigned a static IP address.
  9. Duplicate the functionality that exists on the old server to export data to other applications
    1. It may be necessary to install the SDX Transfer program if it is used to interface Scrap Dragon with General Ledger Applications
    2. If Positive Pay uploads are done through FTP it may be necessary to install WinScp or other FTP program and SDX Transfer.     

C. Cutover process

  1. Optionally, reassign the server IP addresses, old then new.
  2. Optionally, rename & reboot the servers, old then new.
  3. Scrap Dragon Classic only:
    1. The Dragon folder will be moved in its entirety to the new server at cutover.  This includes the program, data files, forms, reports, documentation & drivers. To avoid corruption of data, all users must be out of Scrap Dragon when copying data files.
    2. The Dragon folder must be shared, with appropriate permissions, on the new server.
    3. If the new server has a different name than the old server had, then the system.dbf file must be updated with the new data path and new company path. This is done by running the syscomp.exe utility either from the server or from any workstation.
    4. If the server has a different name than the old server had, then the new name must be configured in the path to the thumbnail images, the license images and the  logo file. This is done in Scrap Dragon, Back Office, Maintenance, Setup, Program Options. It can be done from the server or any workstation.
  4. For SDX, JPEGger & EZCash, the services are stopped and disabled on the Old Server and the databases are detached from SQL.  There may be archived as well as the current JPEGger database to be detached. 
  5. The current JPEGger database is renamed as an archive using the format jpegger_MMDDYYY.
  6. All of the SQL mdf and ldf files for SDX, JPEGger and EZCash are copied from the old server to the new SQL server.  If any of the ldf files are excessively large (runaway log file), they do not have to be copied as the log file can be recreated on the new server. 
  7. On the new server:
    1. The databases for SDX, JPEGger & EZCash are attached in SQL, rebuilding log files if necessary.
    2. In jpegger config, our license server is updated with the MAC address of the new server.  Configure the archives, if any. 
    3. Make any necessary changes to the SDX config files and yard setup.
    4. Make any necessary changes to the EZCash config files.
  8. Test everything   

E. Workstation/Device Modifications (only if new server has different name than the old server had):

  1. The shortcut to launch Scrap Dragon must be changed to point to the new server.
  2. In Scrap Dragon Classic;
    1. In Back Office, Maintenance, Setup, Local Computer Options, change any paths that include the server name.
    2. The pointers to the specific forms that Scrap Dragon prints will only need to be changed if they include the old server name in the path. For example, the pointer to the cashier receipt ‘\forms\receipt7.frx’ would not have to be changed, but the pointer to the cashier receipt ‘\\server1\dragon\forms\receipt7.frx’ would have to be changed.
    3. The form pointers are changed in on the tabs for Buy Printing, Sell Printing, and Other Printing.
    4. The path to the camera directories for the fingerprint and signature pads on the server is changed on the Imaging Tab.

D. Workstation/Device Modifications (only if new server has a different ip address than the old server had):

  1. Scrap Dragon Classic only -
    1. Change the IP address in the file settings for jpeggerclient
    2. change the IP address in the file settings for the multiviewer
  2. EZCash only - change the ip address in the ATM machine

    • Related Articles

    • SQL SERVER 2008 INSTALLATION

      Attached you will find print screens of a typical SQL Server 2008 Installation with all the features to run EZCash and/or JPEGger.
    • Minimum Server and Workstation Requirements

      Dedicated Server Suggestions Microsoft SQL 2019 or newer SQL Server 32/64 bit (minimum 5 Cal) 32GB Ram 1 TB Drive Suggested offsite data backup Workstation Computer Suggestions ​ Windows10 Professional 64-bit Corei7 6700 / 3.2 GHz RAM 8GB - HDD 500 ...
    • INSTALLING MICROSOFT SQL SERVER 2008

      Attached you will find SQL2008Install.bat and SQL2008Install.ini which contain the minimum options necessary for JPEGger and/or EZCash to run correctly. More options may be added at your discretion. Before installation, customization for the system’s ...
    • SQL SERVER MAINTENANCE PLAN INSTRUCTIONS

      Attached you will find print screens illustrating how to create maintenance plans in SQL Server 2005 AND SQL Server 2008.
    • SQL SERVER 2008 SERVICE PACK INSTALLATION INSTRUCTIONS

      Attached you will find print screens detailing how to install the latest Service Pack for SQL Server.