Forum Discussion

GertjanA's avatar
GertjanA
Moderator
8 years ago

running upgrade scripts manually

Hello all, Planning an upgrade of EV9.0.4 to EV10.04 to EV11.0.1CHF5 There is doubt about the health of the EV9 databases. Due to this being a large environment, I would like to run a test upgrade ...
  • EVSupportVet's avatar
    EVSupportVet
    8 years ago

    Hello, 

    This should do it: 

    1. Stop all EV Services on all EV Servers in the site.


    2. On the EV Server, go to the installation directory and copy the following scripts to the SQL Server running the Vault Store database. These then need to be run specficially in this order.
      - VaultStoreDB_8_Updates.sql
      - VaultStoreDB_8_Migrate.sql
      - VaultStoreDB_8_Updates2.sql
      - VaultStoreDB_8_Programmability.sql


    3. Start the EV Services.

     

    Disclaimer: Please do not attempt this in a production evniornment unless instructed by support! 

EVSupportVet's avatar
EVSupportVet
Level 3

Hello, 

This should do it: 

1. Stop all EV Services on all EV Servers in the site.


2. On the EV Server, go to the installation directory and copy the following scripts to the SQL Server running the Vault Store database. These then need to be run specficially in this order.
  - VaultStoreDB_8_Updates.sql
  - VaultStoreDB_8_Migrate.sql
  - VaultStoreDB_8_Updates2.sql
  - VaultStoreDB_8_Programmability.sql


3. Start the EV Services.

 

Disclaimer: Please do not attempt this in a production evniornment unless instructed by support! 

GertjanA's avatar
GertjanA
Moderator
8 years ago

Thanks. Obviously, we will do this on a test-environment with a copy of production only.

Does this also upgrade the directory db's? and the Fingerprint? Thanks!

  • EVSupportVet's avatar
    EVSupportVet
    Level 3
    8 years ago

    Those only upgrade the VS DB'S.  Once you fire up the Directory Service, it will automatically upgrade the EVDB. 

    • GertjanA's avatar
      GertjanA
      Moderator
      8 years ago

      Hello EVSupportVet,

      I know that upgrading is supposed to be done using the services starting.

      In this specific case, I only have a copy of the databases, not of the 18 EV servers.....

      I prefer to run the scripts manually, to see what issues we might run into on the actual upgrade, to be able to fix those to accomodate a smooth upgrade. If this is not possible, I will have to use a hostsfile I think, which has one (test) server as 'all 18 running'. I've done that before (albeit in a much smaller setup).

      Thanks

       

      • Daniel_R_'s avatar
        Daniel_R_
        Level 5
        8 years ago

        Thinking about it....

        What if you do a test HW migration of primary evserver for pointing to test EVDB and then you do the upgrade to V10.

        Best Regards