Hi @Uday Solanki ,
Is the reply helpful?
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi
I've been trying to find a solution for this company, where they several databases and applications cross referencing sql queries to pull data for different application.
Here's the summary of existing structure,
Existing structure
Database
With travel app being their key app which perform search and collects/updates data from other two DB's.
Proposal
One of the suggestion is that to have Azure Search or Elastic search index on top of DB's so all the application will look to index via API instead of direct sql query.
However with the requirements and existing data structure sitting on different db, having a single index or split indexes for each db. Question relies on how to keep the data sync? or is there a possibility to perform a single search on different index at once?
Much appreciate for any feedback.
Hi @Uday Solanki ,
Is the reply helpful?
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.