SQL ETL soft delete

[djordjedjukic]

Is it possible when a document in RavenDB is deleted, to set the IsDeleted property to true, instead of deleting it?

[arekpalinski]

Let me make sure that I understand. You'd like to send a document to SQL database with IsDeleted: true instead of propagating the deletion to SQL table?

That's not possible because at the time the ETL process processes the tombstone of a deleted document then that document does not exist.

[djordjedjukic]

Yes, that is the case.

Thank you.

[ayende]

You can do that using instead of trigger on the database side, no?

[DejanMilicic]

So something in the lines of https://stackoverflow.com/a/7763409/158320

[djordjedjukic]

I will check that. Because the object is complex (1 document from ravendb is mapping on 5 tables in SQL) maybe I will use hard delete in SQL if that is easier.