We would like to periodically refresh our non production environments with the production reference tables data for development, troubleshooting etc
- We do not want to restore the database each time we do a refresh
- Tables include contacts, config items, attr_alias etc
- Configuration items should maintain the PR own_resource_uuid and the CORA data
- We will not refresh call_req, chg, wf etc data
- Products: Service Desk, Service Catalog
- At this time, removal of PI from ca_contact and other tables is not a requirement.
I could write a SSIS package, but this would take time, and there are products I can buy. However, I am looking for a CA solution.