CODEWITHSUNDEEP
sqlazureazure-sql-databasepartitioning
Arun S
Arun S

Reputation: 1453

Partition switching migration from SQL Server to Azure SQL DB

I need to migrate my SQL DWH partition switching logic to Azure SQL Database. Have anyone done this before and is there any complexity in doing the same. I dont find any references in Google for this migration.

Upvotes: 0

Views: 506

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46193

Partition maintenance code (adding/removing boundaries dynamically) is the same between SQL Server and Azure SQL Database. The only material difference is the filegroup specification, which needs to be [PRIMARY] in the case of Azure SQL Database.

Upvotes: 1

Related Questions