Upgrading if networked Firebird AyaNova

Top Previous Next

It is always recommend to read through all instructions first before proceeding.

NOTE: Refer to the AyaNova Pricing web page and AyaNova FAQ Answers web page for details on upgrade pricing

NOTE: As per the steps below, you apply your AyaNova 5 Activation key after you have performed the upgrade steps. Make sure that you perform the upgrade steps before the Install By date of your AyaNova 5 Activation key.

NOTE: Before proceeding, make sure that you know your AyaNova Administrator username and password

•

One of the many new features of AyaNova 5 is that ONLY users of type Administrator have access to grids/features of Administration pane regardless of rights given to prevent viewing by non-Administrator users and accidental changes. So if your AyaNova Administrator is the only user that is of type Administrator and you do not know the AyaNova Administrator username and password, you won't ever be able to edit users, security groups, etc.

•	If you do not know your AyaNova Administrator username and password, before upgrading to AyaNova 5 log in as another user that does have rights to the Users grid, and edit the AyaNova Administrator username and password, and keep that username and password in a safe place (i.e. in a safe).

Upgrading for network Firebird configuration is a 10 step process:

1. Create and backup the snapshot of your AyaNova 4 database and related files

2. Remove all AyaNova 4 programs

3. Remove Firebird 2.0

4. Install stand-alone AyaNova 5 on server

5. Install and configure Firebird 2.1

6. Configure the server's AyaNova 5 for network Firebird 2.1 database

7. Apply the AyaNova 5 keycode to your AyaNova 4 database.

8. Prep and install AyaNova 5 on networked computers

9. Install and configure any additional AyaNova 5 optional programs on the server (Event Generator, WBI, MBI and/or DP)

10. Confirm your network Firebird snapshot backup and restore procedures

1. Create and backup the snapshot of your AyaNova 4 database and related files

a. Refer to the AyaNova 4 Help file for backing up your networked networked Firebird AyaNova 4 database to a snapshot file

b. Make a backup of your aliases.conf file from the Firebird 2.0 directory - C:\Program Files\Firebird\Firebird_2_0

•	Alternatively, make a note to yourself the database name and path entered in that aliases.conf file

•	For example, it may say AYANOVA = C:\Data\AyaNova\AYANOVA.FDB

c. Make a backup of your AyaNova 4 networkFirebirdsnapshot.bat file to refer to when editing your new AyaNova 5 networkFirebirdsnapshot.bat

d. Make a backup of your config.txt file so that you can refer to it if needed in steps further down

2. Remove all AyaNova 4 programs

•	Make sure all users are out of all AyaNova 4 related programs connecting to the database (AyaNova , QBI, PTI, WBI, MBI, AyaNova Data Portal)

•	If was running the network Event Generator 4 service, shut down that service

•	Uninstall any previous AyaNova 4 programs via Control Panel -> Add/Remove Programs

•	Uninstall QBI, PTI and any AyaNova 4 import utilities if applicable

•	Uninstall Event Generator, AyaNova Data Portal, WBI

•	Uninstall AyaNova 4

3. Un-install Firebird Server 2.0

NOTE: AyaNova 5 requires Firebird 2.1.1

NOTE: you can not have both versions of Firebird service running on a computer at the same time, so you must uninstall the older version 2.0 before installing Firebird 2.1.1

4. Install stand-alone AyaNova 5 on server

a. Refer to stand-alone AyaNova 5 installation steps

b. Run AyaNova 5 and confirm it loads successfully

•	The first time you run AyaNova 5, 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.

c. Make sure you have exited out of AyaNova 5

**The following steps will now install and configure Firebird 2.1.1, move and update your AyaNova 4 database to AyaNova 5**

5. Install and configure Firebird 2.1.1 as per step #5 of the network Firebird Server configuration

a. perform step #5 of the network Firebird Server configuration

6. Configure the server's AyaNova 5 for network Firebird 2.1.1 database as per step #6 of the network Firebird Server configuration

a. perform step #6 of the network Firebird Server configuration which identifies about editing the config.txt so that you connect to your server. Do note that if you instead replace the stand-alone configuration config.txt file that was just installed which your backup config.txt file, to make sure that you have performed the Firebird Server configuration steps of setting up the same password for the SYSDBA, editing the aliases.conf, setting the firewall, etc as per 5.a above.

b. Run AyaNova 5 which connects now to your AyaNova 4 database and updates it

•	The first time AyaNova 5 runs, it will update your AyaNova 4 database. It may take a while to first load as it makes internal changes - let it run as it could take 15 seconds up to 15 minutes or more, and the AyaNova 5 log in screen will show up when it is ready

c. Log into AyaNova 5 as the AyaNova Administrator and confirm loads correctly

•	A message will display that the licenses have expired - this is OK and expected because your AyaNova 5 database needs to now be licensed for AyaNova 5.

•	If you encounter an issue connecting to your AyaNova networked database via the server, do go back and double-check each of your steps from the beginning.

d. NOTE: AyaNova 5 has database "fingerprinting" where it compares your database against what is expected. If additional tables or columns have been added or the database schema modified, AyaNova 5 will not start to prevent additional problems arising as a result from those that have modified their database.

If you get a message loading AyaNova 5 that the AyaNova database appears to have been modified and then it lists all the tables in the AyaNova database, send us the ayalog.txt file from your server where this occurred so that we can see it and help you identify what table/field as been added to the AyaNova database which should not have been done.

7. Apply the AyaNova 5 keycode to your AyaNova 4 database.

a. refer to your AyaNova 5 keycode for steps to apply.

8. Prep and install AyaNova 5 on networked computers as per step #7 of the network Firebird Server configuration

a. perform step #7 of the network Firebird Server configuration

9. Install and configure any additional AyaNova 5 optional programs on the server (Event Generator, WBI, MBI, and/or DP) as needed