Skip to content

4: Using this method with dedicated SQL Pools and SQL Server

Jump to bottom
Kevin Chant edited this page Jun 9, 2022 · 1 revision

You can use this migration-based approach with both dedicated SQL Pools and SQL Server. Which can be useful. Especially if looking to use Azure Synapse Link for SQL Server 2022 because you can update both of them in the same workflow.

A few points I want to highlight though:

  1. You can remove the -SchemaVersionTable $null syntax at the end of the Single-Serverless-Pool.yml YAML file. Due to the fact that it can create the SchemaVersions table in your dedicated SQL Pool.

  2. You might want to create the SchemaVersions table in advance so that you can change its distribution type if intending to use it in a dedicated SQL Pool.

  3. Bear in mind that you can use different Transact-SQL syntax in the dedicated and SQL Pools.

Clone this wiki locally