AnsweredAssumed Answered

Contacts replication from Prod to QA using SQL (NO PDM Command methods)

Question asked by vchinni on May 30, 2018
Latest reply on Jun 11, 2018 by Paul_Coccimiglio

Is it possible to replicate just the contact tables (ca_contact, usp_contact) from Prod to QA using SQL for CA Service Desk Manager 14.1.x release?

I have tried exporting the data using Tasks > Generate Scripts > Select specific tables > Selecting both Data and Schema into a SQL script. Then dropped SQL constraints (reference link shown below) followed by truncate ca_contact table that fails to run due to the following error.

Cannot truncate table 'mdb.dbo.ca_contact' because it is being referenced by a FOREIGN KEY constraint.

 

https://docops.ca.com/ca-service-management/14-1/en/administering/configure-ca-service-desk-manager/managing-your-database/drop-and-restore-constraints

Outcomes