I recently used the configuration migration tool, Data migration workbench, from PeopleTools and I am really impressed. Application designer has many great features to migrate objects from one environment to other but functional team always struggle with migration of configuration data. They have to constantly work with the technical team to create sql or data mover scripts and then test them during various migration. Also, if any config changes, which happens more often than code changes, then they have to communicate it out to the tech team. More than often something is missed, causing endless hours of analysis, delay cutover or even worse, rollbacks.
With DMW, the control is in functional team hand. I can create a migration definition project (same as a app desiger project) of config tables and relationships. I can add and remove data to migrate, online. Once the packet is ready to migrate, I can perform integrity checks to make sure all the data values are still valid and referential integrity is maintained. Finally data can be migrated into change packets that need to be physically migrated over to the target server (one of the drawbacks) where, on approval (yes, you can use AWE approvals to approve packages before they can be moved in) they are imported into the new environment.
The whole process takes a little bit of time to get use to (took me 1 day, for my first migration, to migrate 5 change packets) but once you get use to it, then it can be really quick and convenient (now it takes me 20-30 minutes to do the entire migration).
There are a lot of other advance level functionalities (auto relationships, compare, validations etc) that are also delivered, which can make migration process very robust and quick.
Contact me if you want to know more or need a demo