I'm looking for possible solutions to extract the responses.
1. Use Developer API - I don't see enough documentation to use the IAnswerData interface yet. Are there other API options I should look at?
2. Extract XML in an automated way and feed it to the alternate repository. Is there an automated way provided by Checkbox (a hook?)
3. Put an after trigger on the ckbx_Response table that selects the ckbx_ResponseAnswers into the alternate repository when the ckbx_Response.IsComplete becomes true.
4. Live with the split data store and make calls directly against the Checkbox database ckbx_Response & ckbx_ResponseAnswer tables.

Can anyone help flush out the viability of these options or offer their idea?

Thanks.