Thank you for your feedback. We’re considering this for a future release of Azure Search.
Azure Search Product Team
Having this feature would save us a lot of trouble. Please advise when it will be available.
+1 Everything falls apart if you cannot have a development instance (LocalDb) that is exactly the same as your production instance.
Local emulation is absolutely essentially in order to avoid treading on each other's toes using a shared instance. There is local emulation for pretty much all major storage engines, such as CosmosDB and SQL Server.
This issue has been outstanding for almost 5 years. It is about time.