nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deploy | Editing a DCR

rohitspathak123

Hi,

I am new to data deploy concept. We have setup data deploy for DCR content to database. So if we create a new DCR and a new record will be inserted into Database.

1. What will happen when an existing DCR is edited ?
2. Will data deploy update the corresponding record in data base ?
3. On DCR edit is it true that data deploy first deletes the existing record in database and then inserts the updated dcr content to database ?
4. Also what happens if we delete a DCR ? How do I make sure that corresponding database record also gets deleted ?

Please pardon me if these are very basic questions.

Rohit

Find more posts tagged with

Comments

moonkhanna

Hey Rohit, Answers inline though I have not used DD for some time now..

Hi,

I am new to data deploy concept. We have setup data deploy for DCR content to database. So if we create a new DCR and a new record will be inserted into Database.

1. What will happen when an existing DCR is edited ? Provided you are pushing a unique identifier from your DCR which is acting as Primary key in your DB, corresponding record will be deleted and new record written
2. Will data deploy update the corresponding record in data base ? yes
3. On DCR edit is it true that data deploy first deletes the existing record in database and then inserts the updated dcr content to database ? I believe, it deletes the complete table and then writes it back..
4. Also what happens if we delete a DCR ? How do I make sure that corresponding database record also gets deleted ? You will need to have a separate delete workflow. Best approach would be not to delete the complete record but just add a deletion flag to your table

Please pardon me if these are very basic questions.

Rohit

Again, I am rusted on DD as of now.. others can correct me on information provided

ISCBorisB

Hi,

I am new to data deploy concept. We have setup data deploy for DCR content to database. So if we create a new DCR and a new record will be inserted into Database.

1. What will happen when an existing DCR is edited ?
2. Will data deploy update the corresponding record in data base ?
3. On DCR edit is it true that data deploy first deletes the existing record in database and then inserts the updated dcr content to database ?
4. Also what happens if we delete a DCR ? How do I make sure that corresponding database record also gets deleted ?

Please pardon me if these are very basic questions.

Rohit

Read about Data Deploy DAS (Database Auto-Synchronization) Mode.

If you run your DD in the DAS Mode your Content/EA Changes will be automatically Deployed to the DB.
That includes creating Content, editing Content, deleting Content - the whole shebang.

If you do not run DD in DAS, absolutely nothing happens to Database upon all this events. In this case you will use
DD in conjunction with the Open Deploy (OD) in either Standalone or Target-side Deployments. With that,
DB changes reflect your Deployment logistics like Workflows, Scheduled Deployments, ad-hoc Deployments and
the like.

For what it's worth, in my personal experience Clients prefer DD deployments far more often than DAS

rohitspathak123

Hi,

Can anyone confirm, how does data deploy behaves in case of updating a DCR ?
Does data deploy deleted the existing database row & creates a new one when we edit an existing DCR?

moonkhanna

Hi,

Can anyone confirm, how does data deploy behaves in case of updating a DCR ?
Does data deploy deleted the existing database row & creates a new one when we edit an existing DCR?

Hi Rohit, yes that is correct.. but you need to have a Primary key field in your DCT for this purpose.. so when it pushes data it also pushes the primary key...

rohitspathak123

Hi Munish,

Thanks for your reply. It was helpful. One more thing.

1. If I delete a DCR can data deploy delete the record related to this DCR from database ?

2. Do I need to write something extra to achive DCR deletion and corresponding database record deletion using Data Deploy ?

Rohit

santosh013

Hi Rohit,
You can get your answer if you go through the PDF(dd.560a.admin.pdf).
In our case the PDF helped a lot to understand the basics.

Any query(if still there) is welcome,

Thanks,

moonkhanna

Hi Munish,

Thanks for your reply. It was helpful. One more thing.

1. If I delete a DCR can data deploy delete the record related to this DCR from database ?

2. Do I need to write something extra to achive DCR deletion and corresponding database record deletion using Data Deploy ?

Rohit

hi Rohit,

you need to write a separate delete workflow or procedure for this purpose. I do not remember the exact details now.. but DD Guide should have that information as Santosh indicated..