AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Upgrading one database from V3.6 to V4? Expand / Collapse
Author
Message
Posted 2/20/2008 9:33:55 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 7/15/2008 11:40:28 AM
Posts: 23, Visits: 70
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
Post #3835
Posted 2/20/2008 10:11:43 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
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

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3836
Posted 2/26/2008 8:47:59 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 7/15/2008 11:40:28 AM
Posts: 23, Visits: 70
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

Post #3842
Posted 2/26/2008 9:06:04 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
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

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3843
Posted 2/26/2008 9:38:52 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 7/15/2008 11:40:28 AM
Posts: 23, Visits: 70
I have sent the .zip of the requested files to support@ayanova.com.

Thanks for the help.

Post #3844
Posted 2/26/2008 10:31:43 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
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.6 and 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\AyaNova_baptist
5. Copy all files and folders from C:\Program Files\Ground Zero Tech-Works Inc\AyaNova into \Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate

6. Edit the aliases.conf file in the Firebird Server 2 folder to have:

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

7. 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

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


8. 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

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


9. 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

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


10. Stop Firebird Server 2 and restart Firebird Server 2
 


Now will configure Generator to run with the initial AyaNova installed folder - which is for SmithNephew

1. Perform the network Generator steps as outlined in http://www.ayanova.com/AyaNova4webHelp/network_generator_installation.htm

NOTE this is installing Generator service for only one database - for SmithNephew as that is the connection set up in the default installation folder

[EDITED March 5: if also want another database such as for Baptist to have its own Generator service, do the following after setting up the initial Generator

  • Stop the AyaNovaGenerator service (you may also need to stop IIS during this so that you can copy all files)
  • Copy all files again from the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder except for the config.txt to C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_baptist folder
  • Open a command prompt
  • Type in the following (do not copy)

sc create AyaNovaGeneratorBaptist binpath=  "C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_baptist\Generator.exe"

  • if it successfully sets up the new service it will say

[SC] CreateService Success

Now will configure three different data portals - each its own Web Site, and each pointing to a different database

Configure data portal for SmithNephew

1. In IIS Manager, delete the installed web site AyaNovaDP under Default Web Site (this should not remove the installed files)
2. In IIS Manager, create a new web site called DP_SmithNephew pointing to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder with its own port #

• Allow anonymous access to the web site
• The web site access permissions must be at minimum Read, Run scripts and Execute
• Make sure .NET 2 is selected in the ASP.NET tab for this new site
• You may or may not have to set the IP Address property of your new website to the computer's actual internal ip address instead of (All Unassigned)

3. Stop and Start this new web site that you just created
4. As the site is not under Default Web Site, note of course that the URL when initially testing would be http://localhost:xxxx/DataPortal.rem?wsdl where xxxx is the port number you gave when you manually created the site.  (or use xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address)

 
Configure data portal for Custom Climate

1. In IIS Manager, delete the installed web site AyaNovaDP under Default Web Site (this should not remove the installed files)
2. In IIS Manager, create a new web site called DP_CustomClimate pointing to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate folder with its own port #

• Allow anonymous access to the web site
• The web site access permissions must be at minimum Read, Run scripts and Execute
• Make sure .NET 2 is selected in the ASP.NET tab for this new site
• You may or may not have to set the IP Address property of your new website to the computer's actual internal ip address instead of (All Unassigned)

3. Stop and Start this new web site that you just created
4. As the site is not under Default Web Site, note of course that the URL when initially testing would be http://localhost:xxxx/DataPortal.rem?wsdl where xxxx is the port number you gave when you manually created the site.  (or use xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address)


Configure data portal for Baptist

1. In IIS Manager, delete the installed web site AyaNovaDP under Default Web Site (this should not remove the installed files)
2. In IIS Manager, create a new web site called DP_SmithNephew pointing to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_baptist folder with its own port #

• Allow anonymous access to the web site
• The web site access permissions must be at minimum Read, Run scripts and Execute
• Make sure .NET 2 is selected in the ASP.NET tab for this new site
• You may or may not have to set the IP Address property of your new website to the computer's actual internal ip address instead of (All Unassigned)

3. Stop and Start this new web site that you just created
4. As the site is not under Default Web Site, note of course that the URL when initially testing would be http://localhost:xxxx/DataPortal.rem?wsdl where xxxx is the port number you gave when you manually created the site.  (or use xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address)


Now configure WBI for access to the Custom Climate database
1. Perform the steps to install WBI 4 starting with http://www.ayanova.com/WBI4webhelp/wbi_server_installation.htm
2. When you perform step #1 of http://www.ayanova.com/WBI4webhelp/wbi_server_configuration.htm, do make sure you are copying the config.txt from the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_customclimate folder so that WBI connects to the correct database

.

Do note that when updates are provided for AyaNova 4, you will be able to run the AyaNovaSetup.exe for the default C:\Program Files\Ground Zero Tech-Works Inc\AyaNova without having to do manual updating,  but will need to manually copy all files to the other AyaNova folders so that all are updated.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3845
Posted 2/26/2008 10:35:46 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
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

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3846
Posted 2/26/2008 10:54:56 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 7/15/2008 11:40:28 AM
Posts: 23, Visits: 70
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
Post #3847