2

Is there a way to create a trigger in SQL Server, or poll it for deletes?

Logstash and JDBC have been implemented, and there are already options for updating and inserting... but it seems delete is not an option.

If there is any way to do this, please leave suggestions.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Mattcul
  • 242
  • 1
  • 8
  • 1
    these answers might help: http://stackoverflow.com/questions/34477095/elasticsearch-replication-of-other-system-data/34477639#34477639 + http://stackoverflow.com/questions/40410920/elasticsearch-usage-with-mysql/40415430#40415430 – Val Feb 23 '17 at 04:55
  • Good links. Neither have a solid answer though; however they are helpful, thank you. – Mattcul Feb 23 '17 at 05:05
  • By "solid" you mean "ready baked" answer with a full solution that you can copy/paste? – Val Feb 23 '17 at 05:06
  • The first link has been implemented, and ran into the same problem; no delete option. The second option suggested using ES as append only, which does not help. It seems the 'how to delete' may be the real question I'm asking here. – Mattcul Feb 23 '17 at 05:08
  • Ok, that's good. Now you can update your question and explain what you did and what did not work. The last two tools mentioned in the first link handle deletes. – Val Feb 23 '17 at 05:10
  • Appreciate the help; it is a much narrower question now. – Mattcul Feb 23 '17 at 05:11
  • Still, I think it's worth it, because people with the same problem as you will be able to benefit from your experience with this. – Val Feb 23 '17 at 05:12

0 Answers0