Home / server / Questions / 1048518
In Process
Kenny_I
Asked: 2021-01-05 06:53:33 +0800 CST

How to migrate Dedicated SQL Pool (DW) to Serveless Synapse?

  • 772

I have Azure Datawarehouse which has fixed pricing tier DW100. Usage is small and assuming that Serverless can be cheaper.

A) How do get information how much data processing have been occurring in last month to analyze costs? B) How to do migration to Serverless?

azure-sql data-warehouse

1 Answers

  1. Under Configure choose "General Purpose", you will have the choice between:

    • Provisioned
    • Serverless

    enter image description here

    You can also shift your current databases from Provisioned to Serverless. In the picture you have to do it one by one but probably there must be a way to do that in bulk through Azure PowerShell.

    • 0