Hi @Ketan Suthar ,
Thank you for using Azure. I see you also posted this question on StackOverflow and it has received a few responses. Adding some additional info and resources:
How will we transfer and upload on index of search engine for existing data?
There are two basic workflows for populating an index: push your data into the index programmatically, or pull in the data using a search indexer. Read this doc for more details: Data import in Azure Cognitive Search
What will be the easy way to update the data on search engine with new records in our Production Database?
You can import search documents into a specified index using HTTP POST. For large numbers of updates, batching of documents (up to 1000 documents per batch, or about 16 MB per batch) is recommended and will significantly improve indexing performance. Read this doc for more info.
POST https://[service name].search.windows.net/indexes/[index name]/docs/index?api-version=[api-version] Content-Type: application/json api-key: [admin key]
Is there anyway we can automatically update the index whenever there is change in database records? The new Incremental enrichment feature in Azure cognitive search can help with this.
Please let us know if you have further questions