-
Notifications
You must be signed in to change notification settings - Fork 12
4: Using this method with dedicated SQL Pools
Kevin Chant edited this page May 4, 2022
·
1 revision
You can use this migration-based approach with dedicated SQL Pools.
A few points I want to highlight though:
-
You can remove the -SchemaVersionTable $null syntax at the end of the azure-pipelines-Single-Serverless-Pool.yml YAML file. Due to the fact that it can create the SchemaVersions table in your dedicated SQL Pool.
-
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.
-
Bear in mind that you can use different Transact-SQL syntax in the dedicated and SQL Pools.