Forum Discussion

__Vladimir__'s avatar
__Vladimir__
Copper Contributor
Mar 09, 2021

Azure Synapse dedicated SQL pool vs. Azure SQL vs SQL

Hello,

currently we operate on-premises PostgreSQL DB that we use as our data warehouse.

 

I would like to set up a data warehouse in Azure, but the Azure portal is bit confusing, as there are multiple options:

1) in Azure Synapse, there is dedicated SQL pool (formerly labeled as Azure Data Warehouse)

Then, outside Azure Synapse there are two additional options:

2)  Azure SQL database ( /BrowseResource/resourceType/Microsoft.Sql%2Fazuresql ) and

3) "SQL database"   (/BrowseResource/resourceType/Microsoft.Sql%2Fservers%2Fdatabases)

 

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

describes that Azure SQL (#2 above) uses symmetric multiprocessing (SMP) while "Azure Synapse Analytics" (#1) above uses massively parallel processing (MPP).

My data needs are not so vast to utilize the MPP. Thus it seems I should be considering #2, i.e. outside the Synapse Analytics.

 

Azure SQL (#2) above further branches into "Single Database", "Elastic pool" and "Single instance managed DB".

 

I am guessing that for my scenario, "Azure SQL - Single Database" is the best option.

If I choose this, will I be able to use this storage in Azure Synapse Analytics?

 

Furthermore, to use Azure Data Factory (ADF) - if I set up "Azure SQL - Single Database", should I be aiming to use Data Factory within Azure Synapse Analytics, or outside it (i.e. use ADF in Azure portal)?

 

 

 

Resources