Trying to build some sort of ETL process that copies rows from SQL Server into Elasticsearch indexing server.
My ETL process should be able:
- Detect new rows inserted to the SQL Server table.
- Detect updated rows in SQL Server table.
No so much interested in the ETL tools to use but rather Db patterns/script that will allow me to somehow query the SQL server to provide the above information.