Forum Discussion

GertjanA's avatar
GertjanA
Moderator
9 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 on a copy of the production databases first, from 9.0.4 to 10.0.4. I would like to do that using the SQL scripts, but to be able to do that, I do need to know ofcourse which scripts to run, and the order in which they need to be run.

Does anyone know if there is a document available which describes this? Has anyone done this before?

Thanks.

  • EVSupportVet's avatar
    EVSupportVet
    9 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
    9 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! 

    • GertjanA's avatar
      GertjanA
      Moderator
      9 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
        9 years ago

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