0
votes

I have two data source one in MS SQL and one is Azure Table, both of them holds User's data but just different information.

Is there any risk or possible issues if I create two indexer for each of the data source and sync them into single index, so I can do one search instead of two.

I do not see option that allow me to create indexer only, so I wonder if Microsoft trying to prevent that or not.

1

1 Answers

2
votes

When you have more than one indexer updating the same index, races between updates to the same document are possible since Azure Search does not yet support document versioning. If the each indexer updates different document fields, then the order doesn't matter; if multiple indexers update the same field(s), then the last writer wins (and you can't control which indexer will be the last writer).

If you use a deletion detection policy to remove documents from the index, then, to avoid possible races, a document should be marked deleted in both SQL and Azure Table.

I do not see option that allow me to create indexer only, so I wonder if Microsoft trying to prevent that or not.

I don't understand the above question.