I have used the CIW and it is great for adding lists of agents and skills. But have not tried moving 1 CME into another with it.
In theory if you move all the objects in the first CME into folders, then import the second CME put these into new folders, and then import the third CME you should have what you want.
It should work but I would build a test environment before I tried it on on a live system.
I used it to import a xml file that was created from an excel spreadsheet.
Our customer was able to supply a list of all their agents (about 20000) and I used the CIW to import them about 1000 at a time, saving weeks of typing.
You can also get it to output the contents of yuor CME into a SQL Script ready to populate you new CME. If you have, or have access to, Oracle SQL skills you could maipulate the outputs of your 2 environments into one dump.
ImportWizard would be probably worth a try if you have three billion agents to import. Otherwise, considering that you will have to check the whole configuration anyway, recreating it in one CME would be much much easier.
Here is what I would do:
Recreate everything but People
Export People from CME A into CSV
Write a simple script to populate people into CME C, keeping in mind dbid needs to be increased and the next available dbid needs to be written in cfg_maxXXX (I forgot the real name…)
You can also do it in a few days by looking at their cfgDB, and realizing that:
dbid has to be increased for every object
max dbid is stored in cfg_maxXXXX.
A really simple hack would be to just add 5000 to all cfgid and dbids for site A and 8000 to SiteB and then import all of it into SiteC and then modify cfg_max to reflect the next dbid you want Genesys to use when a new object is created.
It is not just that but it is not that hard either.
I am sure Genesys is not going to be very happy if you do it, so if you can afford their tool go buy it…
I wonder if any of us can write an Import/Export Tool of our own…
IMHO, I think that when you import Persons you need to recreate the db links to have the right skills and agent_id assigned, groups, etc linked to the right Person.
Keeping that data integrity is critical and there are few tables in addition to CFG_PERSONS involved. After you import CFG_PERSONS you need to touch CFG_LOGIN_INFO, CFG_SKILL_LEVEL and the thing start to get pretty uggly if there groups and default places defined.
Really I think that host and applications objects can be easily exported and imported again changing just the dbid. (still would recreate the connections manually).
Everything else, unless there is a good understanding of the database schema and somebody with good SQL scripts, is going to be too risky to import just like that and the chances to screw up everything are pretty high.