Azure Elastic DB - Modify schema in each shard

Question

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?

Answer 1

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.