Upgrading one database from V3.6 to V4?

I am currently running three separate AyaNova v3.6, firebird super server databases on one server. Is it possible for me to upgrade only one database to v4 and leave the other two at v3.6?

-Tory

No. AyaNova 4 uses Firebird Server 2, whereas AyaNova 3 uses Firebird Server 1.5

You can not have two different Firebird Server’s running on the same computer.

I would recommend that you move the one database to a different computer, and than setup AyaNova 4 on it with Firebird Server 2

  • Joyce

Then is it possible to run my current setup with v4? I have three seperate databases. One with WBI, another using generator, and third just a database. All needing data portal.

-Tory

Please send all the specifics about your present setup such as (zip all files together in a WinZip file):

aliases.conf file from the Firebird Server which identifies where each database is located
location of each AyaNova program folder and a copy of its AyaNova.exe.config (you may need to rename each file so I know which is which along with the info you provide)
what is the actual folder of WBI 3, and copy of its web.config and how is WBI installed (is it under Default Web Server, or is it its own web server etc)
what is the actual folder(s) of Data Portal 3.6, and copy of its web.config and how is data portal is installed (is it under Default Web Server, or is it its own web server etc)
how do you have 3 Dataportals in use on this computer right now - please outlined
where is the folder of Generator 3.6, and a copy of its Generator.exe.config file
any other information you can provide that will provide detailed information on your present setup so that I can refer to it when providing a reply
Please do note that there are known issues with the Data Portal 4 as outlined in the Known Issues & Updates section of this forum, we will be shortly releasing 4.1 which will address this as well as the new optional add-on MBI

  • Joyce

I have sent the .zip of the requested files to support@ayanova.com.

Thanks for the help.

Hi again. I have listed the steps below, please make sure to review all before proceeding. If you have any questions, do let me know.

First remove AyaNova 3 programs and Firebird 1.5 and install and configure Firebird 2
1. Uninstall (or remove after uninstlaling any of those that you had initially copied)AyaNova Generator 3.6, WBI 3.6,all DP 3.6and AyaNova 3.6 on this station
2. Uninstall Firebird Server 1.5
3. Install Firebird Server 2
4. perform the steps to edit the Firebird Server’s password if you want.

Now initial setup of the three AyaNova 4.x folders pointing to the three different AyaNova databases

  1. Install AyaNova 4 using the latest AyaNovaSetup.exe and select to install data portal too - this installs AyaNova program files along with Dataportal files into the default location C:\Program Files\Ground Zero Tech-Works Inc\AyaNova

  2. Open IIS and shut down the Default Web Server (otherwise you are going to get errors while you do the rest of the steps)

  3. create folder C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_baptist and C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate
    4. Copy all files and folders from C:\Program Files\Ground Zero Tech-Works Inc\AyaNova into \Program Files\Ground Zero Tech-Works Inc[b]AyaNova_baptist[/b]

  4. Copy all files and folders from C:\Program Files\Ground Zero Tech-Works Inc\AyaNova into \Program Files\Ground Zero Tech-Works Inc[b]AyaNova_customclimate[/b]

  5. Edit the aliases.conf file in the Firebird Server 2 folder to have: dir=ltr " ">

AYANOVACC = C:\Data\AyaNova\CustomClimate\AYANOVA.FDB
AYANOVASN = C:\Data\AyaNova\smithnephew\AYANOVA.FDB
AYANOVABGCO = C:\Data\AyaNova\baptist\AYANOVA.FDB

  1. Edit the config.txt in C:\Program Files\Ground Zero Tech-Works Inc\AyaNova so that it points to the SmithNephew database using network Firebird Server connection dir=ltr " ">

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_FIREBIRD_SERVERconfig.txt file
d. Move back to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
e. Paste in the EXAMPLE_FIREBIRD_SERVERconfig.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 with your computers IP address, database name AYANOVASN, and password

  1. Edit the config.txt in C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate so that it points to the Custom Climate database using network Firebird Server connection dir=ltr " ">

a. Delete the existing config.txt using NotePad in the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate folder
b. Move to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate/examples folder
c. Copy the EXAMPLE_FIREBIRD_SERVERconfig.txt file
d. Move back to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate folder
e. Paste in the EXAMPLE_FIREBIRD_SERVERconfig.txt file into the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate folder
f. Rename this file to config.txt
g. Edit this new config.txt using NotePad with your computers IP address, database name AYANOVACC, and password

  1. Edit the config.txt in C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_baptist so that it points to the Baptist database using network Firebird Server connection dir=ltr " ">

a. Delete the existing config.txt using NotePad in the C:\Program Files\Ground Zero T

I didn’t mention it in the steps above, but am assuming of course that you will purchase each databases AyaNova 4 upgrade licenses (and the one WBI 4 upgrade license) as needed, and apply to your AyaNova 3 databases before proceeding with the steps above.

  • Joyce

Thanks for the setup info. That is the route I have taken on my test server. I will be requesting new licenses when we are ready to upgrade next week.

-Tory