MAKE A BACKUP BEFORE DOING ANY UPGRADES TO YOUR SYSTEM!!!!!!! REA cannot be responsible for your data if you do not make a backup before this process,
REA 9.13.0 is a major upgrade and requires that every machine be updated and that the REA 9 database be updated. REA 9 contains a database manager program that will make updating your system and all your users easy. Please follow these instructions to update your system. You should allow at least one hour to complete this process. Some upgrades may differ depending on your system and what version of REA 9 you were running prior to doing the update.
Start by downloading the correct version of REA from http://updates.gorea.com, the file for Workstations is named REA9-9.13.0-Workstation.exe. This will install all the REA program updates but will not install the SQL Server.
Below is an explanation of the differences between the two update installation files.
Single User Systems and SQL Server Machine
A single user system has both the REA program and the SQL database installed on its C drive. All single user installations need to download REA9‐9.13.0 ‐Complete.exe. Make sure you update the SQL Server on your machine when asked during the install.
Multi-User Systems
Shared systems (two or more people using the same REA database) require one machine to be the SQL server while the other machines are workstations. The machine acting as the SQL server must update using REA9‐9.13.0‐Complete.exe and make sure to update the SQL Server.
The other machines are considered workstations and should update using the REA9‐9.13.0‐Workstation.exe. This update does not include the SQL engine. Workstations can use the Complete version of the update but should answer NO when asked if they want to install SQL Express.
Locate the REA9.13.0‐Workstation.exe file you downloaded from http://updates.gorea.com. Click to run it.
Required Applications....
This step installs required components for REA 9 to install.
Click Install.
Upgrading to SQL Express 2005
(Please not that this will only occur if you are updating from 9.8.0 or earlier)
REA 9.9 and up includes an upgrade to Microsoft SQL 2005. Make
sure you have backed up REA and enter the SQL password you
created when you installed REA. Click Finish.
Welcome....
This screen just welcomes you to the installation program.
Click Next
Destination Folder....
This is the folder REA 9 will be installed in. The REA installation will choose the location of your existing REA program automatically.
Click Next.
Setup Type....
Select Custom
Click Next.
Custom Setup...
Click the button in front of each item to select the installation option.
REA 9 Application is the program you must install this.
Outlook Link allows you to sync Microsoft Outlook with REA.
Administrative Tools gives you access to backup/restore, user setup and other options.
Click Next.
Ready to Install the Program...
Click Install to begin the installation of REA 9 or click Cancel to quit the installation.
You can also click the Back button if you would like to go back and make a change to your installation settings.
Installshield Wizard Completed....
Click Finish.
YOU ARE NOT FINISHED!!!!! You have to update
your REA database next. The program is installed but before
you can run REA please follow the next few steps to update
your database. Click Finish.
Updating your Database
This version of REA requires a database update. To update REA you must have the administrative tools
installed on your computer. Only one user needs to update the database, if you are not the REA
administrator go to the machine that has those tools installed and follow the directions below to update
the database.
Go to START | Programs | REA 9 | Administrative Tools | Database Manager
Database Manager...
Click the Connect button in the Database Manager.
Connect
Log in to the SQL Server using the SA password you created when
you first installed REA. This password may not be the same one
you use for REA. Click OK.
Select Upgrade Version
The list of databases can change depending on what
version of REA 9 you were on before you updated. You
should highlight the top version in the list so you get all
the new updates. Click Next.
Ready to Upgrade
Click Next to begin upgrading your database.
Backup Database
Answer YES to back up your database before the
upgrade is done. If you have any problems you
can restore your database.
Finished
This dialog displays at the end of your database update.
Click Close.
If this is a single user program or you are the only user
on the system you are done. If you have other users
you can continue to set up REA to automatically
update your other users or you can run the update on
each machine.
Distribute Updates
From the REA 9 Database Manager Click Distribute
Updates. Click Add Update and locate the file you use to
do this update. Click OK to set the file and then click Close
in this window
Update Type
Choose the type of file you downloaded in this case it should be
the Compressed package (single EXE file). Click OK.
Update Properties
Click OK.
Distribute Updates
Click Close. Your Update is now complete. As your users
log in to REA they will be provided with this update file.
