Client/Server Upgrade Instructions from v12 and Older to Atrex 23

Taking the time to make sure that every Atrex system is mapped correctly BEFORE installing Atrex 23 will help make sure that the upgrade process goes as smoothly as possible.  While incorrect mapping worked in some scenarios in earlier versions of Atrex, those scenarios will NOT work properly in Atrex 23.

To check your mapping, open Options – System Information on each Atrex system and make sure that the Data Path and Central Path on EVERY Atrex system is EXACTLY the same.  If they are not, correct as needed under Options – Locations – Reports/Central Location or Options – Locations – Data Location.  Examples:

Scenario 1:  (Correct Client/Server)

  Server:

      Data Path:        Client/Server

      Central Path:        Client/Server

  Workstation-1:

      Data Path:        Client/Server

      Central Path:        Client/Server

  Workstation-2:

      Data Path:        Client/Server

      Central Path:        Client/Server

 

Scenario 1 is the perfect client/server setup.  All of the stations are mapped using client/server for both the Data and Central paths.

 

Scenario 2:  (Incorrect Client/Server)

  Server:

      Data Path:        C:\Atrex\Data

      Central Path:        C:\trex\Central

  Workstation-1:

      Data Path:        Client/Server

      Central Path:        Client/Server

  Workstation-2:

      Data Path:        Client/Server

      Central Path:        Client/Server

 

Scenario 2 will not operate correctly in Atrex 23.  The server is pointing directly to the local drive instead of using client/server which will cause locking errors when attempting to access the data.

 

Scenario 3:  (Incorrect Client/Server)

  Server:

      Data Path:        Client/Server

      Central Path:        C:\Atrex\Central

  Workstation-1:

      Data Path:        Client/Server

      Central Path:        C:\Atrex\Central

  Workstation-2:

      Data Path:        Client/Server

      Central Path:        C:\Atrex\Central

 

Scenario 3 will not operate correctly in Atrex .  While the Data paths are all correct, each system is pointing to the local drive for the Central path instead of using client/server which will cause locking errors when attempting to access the data.
 

 

Upgrading from Atrex 11 and 12 - Client/Server

                                       

While more difficult, it is possible to migrate to a new server and upgrade a client/server configuration to Atrex 23 at the same time using the following steps.  If you have more than one database or need help with the upgrade, please contact Millennium Software for assistance.

  1. From Atrex 11 or 12, make 2 separate backups of your data, one to the hard drive and one to some type of removable media.
  2. Confirm your Data and Central paths (per instructions above) and correct as necessary.
  3. Close Atrex on all workstations.
  4. Uninstall the Atrex 11 or 12 database server engine.
  5. Download and run the Atrex 12 and older database conversion utility from  https://1000years.com/downloads/CvtDbfDbisam.exe .
  6. Select the Atrex data path that you verified in step 2 and then click the "Run Conversion" button.
  7. Select the Atrex central path that you verified in step 2 and then click the "Run Conversion" button.
  8. Close the database conversion utility.
  9. Install the Atrex 23 Database Server engine on the server computer.
  10. Start the Atrex Database Server Administrator.  The default username and password is:
    User Name: administrator
      Password: EDBDefault
  11. Select Quick Setup - New Server Installation.  
  12. Configure the server to point to the central and data locations that you verified in step 2 above.   Use the same user ID and password that you used in the previous client/server setup.  
  13. On the first system, install Atrex 23 directly over top of your previous Atrex installation.
  14. Start Atrex and when prompted, start the data conversion.   Allow the data conversion to complete before continuing further.
  15. Enter the Atrex 23 registration key under Options – Enter Registration Information.
  16. Install Atrex 23 on the remaining systems.
 In previous versions of Atrex email setup was entered on each workstation.  This is no longer the case in Atrex 23.  There’s a global email configuration as well as individual user configurations.  If you were previously using MAPI to send email from inside Atrex, or if you weren’t sending email from inside Atrex, no changes are necessary.  If you were using SMTP to send email from inside Atrex your email configuration must be re-entered.  Enter the global configuration under Options – Company Setup / Customization – Company Information and Settings – Email tab.  Optionally, enter individual user configurations under User – Edit User/Group.