Accepted Answer

• Vote up

  1

  Vote down

  

  Replied by shadab.sohail on Sunday, February 19 2012, 05:36 PM

  The best way I would say is the first one: XML export import.. its very easy..
  But again it all depends upon your purpose, if you want to migrate some WFs with dependent objects at once shot, then yes I would suggest XML export import.
  
  If you need to migrate only some small objects (say some designer or WF manager objects) then you can go for copying through repository manager or through designer(for designer objects) or through WF manager (for WF manager objects) itself. But for this you have to be connected to both the repositories while coping.
  
  Some time you may need to migrating entire project and want to have a complete log of deployment, then you can go for creating deployment group using deployment wizard. You might use pmrep to automate exporting objects on a daily or weekly basis. To use this command, you must create a control file with all the specifications that the Copy Wizard requires. The control file is an XML file defined by the depcntl.dtd file. A deployment control file is an XML file that you use with the DeployFolder and DeployDeploymentGroup pmrep commands to deploy a folder or deployment group. You can create a deployment control file manually to provide parameters for deployment, or you can create a deployment control file with the Copy Wizard. If you create the deployment control file manually, it must conform to the depcntl.dtd file that is installed with the PowerCenter Client. You include the location of the depcntl.dtd file in the deployment control file.
  One good thing is you can roll back a deployment to purge the deployed versions from the target repository or folder. When you roll back a deployment, you roll back all the objects in a deployment group that you deployed at a specific date and time. You cannot roll back part of a deployment.
  
  In the PowerCenter Client, you can export repository objects to an XML file and then import repository objects from the XML file. Use the following client applications to export and import repository objects:
  Repository Manager: You can export and import both Designer and Workflow Manager objects.
  Designer: You can export and import Designer objects.
  Workflow Manager: You can export and import Workflow Manager objects.
  pmrep: You can export and import both Designer and Workflow Manager objects. You might use pmrep to automate exporting objects on a daily or weekly basis.
  
  I would really appreciate some more inputs on this topic.. guys please share your experience and knowledge..
  
  Regards,
  Shadab

  1 vote by saurav.mitra

  zakir.mohammed.h@gmail.com, ajeet.singh and saurav.mitra likes this post.