Hi Mohan,
For just SDM, once MDB backup/restore is completed on, the only thing you may need to do is fixing the Service Desk orphaned user. Some times even this step is not needed. There after you just run pdm_configure and on the pdm_configure screen you provide the new database server/instance name. Lindsay's post earlier was spot on.
What I'm now confused about is, the reference to "not working". When you run pdm_configure, you have the option to change the DBHost to the new host and once, you commit through and finish pdm_configure successfully there after, it'll remember the new databaase info. Are you referring to the old node info showing up on pdm_configure screen as "not working". This is mostly OK until after you have provided correct DB node info to pdm_configure and let it complete successfully.
Regarding CAWF, adjusting pm.xml and wl.xml files to use correct JDBC URL would address this as well. Lindsay referred to this one earlier too "The configuration for CAWF should be found in the pm.xml and wl.xml files in the folder $NX_ROOT\bopcfg\www\CATALINA_BASE_WF\conf\Catalina\localhost."
If you are still having some issues, we could definitely use some log files to understand what is not working and why. NX_ROOT/log directory is what I'd normally look for.
Hope this helps.
_R