" /> config database schema update - Genesys CTI User Forum

Author Topic: config database schema update  (Read 1881 times)

Offline efrainclg95

  • Jr. Member
  • **
  • Posts: 63
  • Karma: 1
config database schema update
« on: March 01, 2022, 05:59:41 PM »
Advertisement
Good afternoon dear expert friends, I hope you are well first of all, I wanted to ask you for your help on a delicate point:

It so happens that we are updating the configserver from version 8.1.0 to 8.5.1, for this reason we find ourselves in the scenario of executing an update on the database schemas: config.

We already installed the new confserv, in 8.5, even objects can be created without problem, access to PULSE and GAX is ok.

To update the said schema, how should I proceed? What is the best procedure? I tried to use CCW but due to an error in the OS it does not work, I only have to do it through the database and this is my doubt, perhaps I should re-execute the script: CfgLocale_mssql (script generated after installation) in the config? or what script should I build to update, could you give me an example please.

Thanks a lot

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: config database schema update
« Reply #1 on: March 01, 2022, 06:54:29 PM »
Have you followed this [url=https://docs.genesys.com/Documentation/FR/latest/FRMG/MGUpgradeDBSchema]https://docs.genesys.com/Documentation/FR/latest/FRMG/MGUpgradeDBSchema[/url]?

Offline efrainclg95

  • Jr. Member
  • **
  • Posts: 63
  • Karma: 1
Re: config database schema update
« Reply #2 on: March 04, 2022, 05:52:23 PM »
Hello Kubig

Thanks for the contribution, well what I did was the following, (as a contribution for other people):

Download the database maintenance package from the Genesys portal.
Run the installation of the new version of confserv, backup mode installation.
Once installed I went to the database and executed in my case the following script: upg_cfg_810_to_811_mssql, and shut down the old confserv and start the new one.
The new confserv started without problems, the log recognized all objects and processes.
Finally disable the old confserv service.

I hope it can be of some use, as a recommendation to make a backup copy of the config database.

Thanks