Migrating Genesys Express from Oracle 9i to SQL Server 2000

[gengen]

Hello,

I'm a DBA tasked with migrating a current implementation of Genesys Express 4 (consisting of 6.5 and 7.0 components) from an Oracle 9i setup to SQL Server 2000 MSDE.  Yes, those database versions are unsupported by their vendors; but we are victims of circumstance in this case.  On top of that, we unfortunately do not have support from Genesys available.  My colleague (on the application/software side) and I are attempting this without help.  This is a configuration migration only, it seems, because all hardware (PBX, servers, interface cards, etc...) is to remain as it is.  We need to be able to tell our supervisors that when we "flip the switch" to point production to SQL Server instead of Oracle, all will work without fail.

Could anyone give me an idea on how to begin this migration?  Where do we start?  How do I determine what needs to be migrated? 

Thanks,
-Seth.

[bublepaw]

Easiest way is to use upgrade wizard from Genesys but to get this one probably You need original installation CD or access to tech support. As an unsupported alternative You can try to script Oracel 9i database content into series of inserts, create new database structure using scripts provided with configuration server and run script to populate new database. All those operations should be done when configuration server is stopped. It means that effectively it is best to do it when CC is closed.

[gengen]

Thank you, bublepaw, for your response.

I have already taken a shot at the unsupported alternative you suggested.  I have, what I believe to be, a comparable database in SQL Server populated with, what I believe to be, the correct configuration data from Oracle.  Specifically, I imported data from <ORACLE_DB>.GENECFG to <MSSQL_INSTANCE>.GCTI7.dbo.  I don't know if the Oracle schema is standard, but the SQL Server 2000 instance seems to be the MSDE version that shipped with Genesys and is already setup with some databases in it - one of them being the GCTI7 database.

Do you know how to now point the Genesys configuration to SQL Server?  What logins need to exist in SQL Server to satisfy connection parameters?

As for the upgrade wizard, that is another path I am exploring.  We have some original installation CD's.  I tried the Configuration Configuration Wizard to export configuration data, which validated the data I had already migrated.  I have not yet tried the "upgrade" option in that wizard yet.  Would that effectively move the configuration to SQL Server?

Just trying to get all my ducks in a row.

-Seth.

[gengen]

Update regarding the Configuration Conversion Wizard...

The option to "Upgrade Configuration Database" met a dead end when I was asked for a username and password to the new schema within the same database.  There was no option to "migrate" to a different database.

-Seth.

[bublepaw]

Configuration server config files confserv.cfg should have section which points to database (both engine, database server, name and username/password)

[gengen]

Thank you, bublepaw.  I found it.  It does indeed point to the configuration schema in Oracle.  I will have a look at this next week since I'm out tomorrow.

Thanks,
-Seth.