Search code examples
c#azureazure-sql-databaseddlazure-elastic-sharding

Azure Elastic DB - Modify schema in each shard


I'm new to the Elastic DB Feature from Azure and it looks really awesome. But what i could not find is how you can update the schema of all shards. So if i have multiple Shards and i want to add/remove a Column, Table or just add/remove a Stored Procedure.

Well all Shards are Databases which i could access and modify one by one but is there no way to publish schema changes to multiple shards at once?


Solution

  • if you don't mind playing with a preview, have a look at SQL Database Elastic Jobs which would allow you to execute scripts across SQL Databases.