Configuration Database Migration from 7.6 to 8.1

[raza990]

Hi Guys,

We need to upgrade Genesys from 7.6 to 8.1, so we need to upgrade configuration database first but I am having some trouble.

Can we upgrade configuration database 7.6 to 8.1 directly or I need to upgrade it to 8.0 first then go with 8.1 ?

What is the best practice of configuration database upgrade ?

I tried something but failed:

1. Take export of config database from conversion wizard. Create new database with v8.1 CFG_Locale but when try to run sql export directly to SQL Management then there were errors.
2. try to restore sql export from conversion wizard but still nothing happened.

I would appreciate if you guys share your experience and help me in upgrading system.

Regards,
Raza

[Kubig]

You can upgrade directly to 8.1 release. Use CCW tool for these purposes, where you will be able to move the current schema data to the new database (where the copy of current database should be placed)

[raza990]

Thanks Kubig.

So for this I think I need to create new database and execute init script cfg_locale 8.1 and make the configuration server up. Then connect CCW with configuration database and import data .. Right ?

I already did but there are error. There is some query which try to insert NULL value and 8.1 schema doesn't support NULL value.

[cavagnaro]

No, just copy and run the wizard.
No scripts are needed to be run manually
Check logs on CCW folder

[raza990]

How to copy configuration database into new empty database ?

[Kubig]

Depends on used SQL platform - in general:

- Create empty database
- Copy structure and data from current database to the created
- Run the CCW

If you are not familiar with SQL, ask the DBA for execute it.

[raza990]

Upgraded !!! 

It was misunderstanding in upgradation process.

But when I open CME, I can see question mark "?" on Roles tab 

Is there anything to do with ?

[Kubig]

Check encoding configuration on application and database level (try to little bit more effort)

[cavagnaro]

Upgrade cme.... Read some docs mate