It is always recommend to read through all instructions first before proceeding.
NOTE: Upgrading to AyaNova 4 from AyaNova 3 requires an AyaNova 4 activation key for the same number (or more) licenses as your AyaNova 3 database was licensed for. Refer to the AyaNova Pricing web page and AyaNova FAQ Answers web page for details on this if needed.
Upgrading for network SQL Express configuration is a 8 step process:
1. Apply the AyaNova 4 keycode to your AyaNova 3 database
2. Create backup of your SQL Express AyaNova 3 database
3. Remove all AyaNova 3 programs
4. Install stand-alone AyaNova 4 on server
5. Configure the server's AyaNova 4 for network SQL Express database
6. Prep and install AyaNova 4 on networked computers
7. Install and configure any additional AyaNova 4 optional server programs (Event Generator, WBI, and/or DP)
8. Confirm your SQL backup and restore procedures.
1. Apply the AyaNova 4 keycode to your AyaNova 3 database.
a. this can be done later in the steps, but if done before it saves confusion
2. Create backup of SQL Express AyaNova 3 database
| • | Refer to your SQL Express documentation on backing up a SQL Express database |
3. Remove all AyaNova 3 programs
| • | Make sure all users are out of all AyaNova 3 related programs connecting to the database (AyaNova, QBI, PTI, WBI, AyaNova Data Portal) |
| • | If was running the network Event Generator 3 service, shut down that service |
| • | Uninstall any previous AyaNova 3 programs via Control Panel -> Add/Remove Programs |
| • | Uninstall QBI, PTI and any AyaNova 3 import utilities if applicable |
| • | Uninstall Event Generator, AyaNova Data Portal, WBI |
| • | Uninstall AyaNova 3 |
4. Install stand-alone AyaNova 4 on server
a. Refer to stand-alone AyaNova 4 installation steps
b. Run AyaNova 4 and confirm it loads successfully
| • | The first time you run AyaNova 4, it will display with the AyaNova Administrator username and password pre-entered as the trial AyaNova 4 database was installed - this is OK and expected. |
The following steps will now install and configure Firebird 2, move and update your licensed AyaNova 3 database to AyaNova 4
c. Make sure you have exited out of AyaNova 4
5. Configure the server's AyaNova 4 for network SQL Express database
a. Delete the existing config.txt using NotePad in the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
b. Move to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova/examples folder
c. Copy the EXAMPLE_SQLEXPRESSconfig.txt file
d. Move back to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
e. Paste in the EXAMPLE_SQLEXPRESSconfig.txt file into the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
f. Rename this file to config.txt
g. Edit this new config.txt using NotePad
| • | Do not use any other program but NotePad to edit this file |
| • | Edit Server= to your SQL Express server's name |
| • | Edit your sa password |
h. Save the file.
i. Now run the AyaNova 4 program and log in as the AyaNova Administrator
| • | There may be a delay as the database is updated - let it do this. The delay could be 15 seconds up to 15 minutes or more. Let it update. |
j. If you had not pre-applied the AyaNova 4 keycode to your AyaNova 3 database, a message will display that the licenses have expired - this is OK and expected because your AyaNova 3 database had AyaNova 3 licenses, and needs to now be licensed for AyaNova 4.
k. Apply your AyaNova 4 activation keycode as per its instructions.
If you encounter an issue connecting to the AyaNova networked database via the server, do go back and double-check each of your steps from the beginning.
6. Prep and install AyaNova 4 on networked computers
a. Copy your network SQL Express configured config.txt file from the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder to a shared location that your networked users can access.
b. Copy/Move to this same shared folder the AyaNova installation file AyaNovaSetup.exe that you used to install on the server
c. Have each local networked computer run the AyaNovaSetup.exe file from that shared location that also has the edited config.txt in that same shared location.
| • | Make sure the networked computer selects Network administrator setup |
If the local networked computer will also run QBI, or PTI, select when installing on that computer those optional AyaNova programs. Refer to the QBI Manual or PTI Manual available from the AyaNova download web page if using QBI or PTI.
The AyaNovaSetup.exe will "see" that config.txt file and automatically copy it to that computer's AyaNova program directory so no additional configuration is needed on that user's station.
The install will only install the AyaNova program files it has been told to install, will copy that config.txt file to the networked workstations AyaNova program folder and will not install a trial database.
The AyaNova installation will place a desktop icon for AyaNova on the desktop as well as in the start menu.
You can confirm that AyaNova is configured correctly on the networked computer by logging in on that networked computer, selecting Help -> About AyaNova so that you know that you are correctly connecting to the networked SQL Express configuration
7. Install and configure any additional AyaNova 4 optional programs (Event Generator, QBI, PTI, WBI, DP, etc) as needed
See also:
AyaNova 4 Network Generator installation steps
AyaNova 4 Data Portal installation and configuration steps
QBI 4 Help file for requirements, installation and use from the AyaNova web site
PTI 4 Help file for requirements, installation and use from the AyaNova web site
WBI 4 Help file for requirements, installation, configuration and use from the AyaNova web site
8. Confirm your SQL backup and restore procedures.
Refer to the AyaNova Support Forum for additional sample report templates
See also: