-
Notifications
You must be signed in to change notification settings - Fork 1
Stage 5: Create and Configure SQL Database
Sanoobk edited this page Sep 25, 2019
·
1 revision
Create an Azure Single SQL Database using the Microsoft link.
-
Use a 'Basic' tier and 100 MB storage as this is sufficient for this POC. For DataSource, use 'None'.
-
Complete rest of the steps up to 10.
-
In the Query the database step 3, copy paste the 'bikes.sql' contents file provided as part of this source repo and 'Run'.
-
The Bikes SQL Table with sample data should be populated.
-
A document database like Cosmos DB could be a better alternative.
-
Integration with Azure search index schema is better with Cosmos DB as both services are in the direction of Schema-less.
-
If a Normalized SQL DB is used, then a View can be used joining the required tables and then integrate the view with Azure Search.