datadeploy

Mich

Hi I have created a customised data schema for deploying our DCT. However, at the moment I manually have to delete all the rows in the database before I run the script to deploy the DCRs as if the row already exists there would be a unique constraint error. Is there a way to update the rows in the tables when an existing DCR changes and to not have to delete the table values before inserting the dcrs if the dcr already exists. Thanks

Migrateduser

You dont have to delete the rows before you run a deployment. DD handles updates. You can set the flage real-update="yes" to do updates, by default DD deletes the rows and inserts the row. To avoid the unique constraint violations make sure you choose your keys correctly. DD does not control the way you choose the keys.