I want to sync any DML operations on Azure SQL DB to azure search index immediately.
I have gone through this question. How does Auto-indexing/sync of Azure SQL DB with Azure Search Works?
No answer in this question. This was posted almost 5 yrs back. With integrated change policy in place do we have auto sync feature by any means now.
Function app does not have a SQL trigger event attached.
I don't want to do a while true loop or any timer or call indexer when data gets update. Please suggest if there are any other best approach or any build feature.