You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm Trying to copy a Database between to elastic pools, the origin is a "Premium: 125 eDTU" and the destination is a "PremiumRS: 125 eDTU". I keep getting an error: "Long running operation failed with status 'Failed'. Additional Info:'The database edition 'Premium' cannot be different than the elastic pool service tier which is 'PremiumRS'". The error is pretty clear, but i can´t seem to be able to choose the destination WidthoutElasticPool() so that i can after update to the existing Elastic pool. This is the code i'm using:
I'm Trying to copy a Database between to elastic pools, the origin is a "Premium: 125 eDTU" and the destination is a "PremiumRS: 125 eDTU". I keep getting an error: "Long running operation failed with status 'Failed'. Additional Info:'The database edition 'Premium' cannot be different than the elastic pool service tier which is 'PremiumRS'". The error is pretty clear, but i can´t seem to be able to choose the destination WidthoutElasticPool() so that i can after update to the existing Elastic pool. This is the code i'm using:
`var originSqlServer = await azure.SqlServers
.GetByResourceGroupAsync(model.Origin.ResourceGroup, model.Origin.SqlServer, ct);
var destinationSqlServer = await azure.SqlServers
.GetByResourceGroupAsync(model.Destination.ResourceGroup, model.Destination.SqlServer, ct);
var templatedb = originSqlServer.Databases.Get(model.Origin.Database);
var database = await destinationSqlServer.Databases
.Define(model.Destination.Database)
.WithExistingElasticPool(model.Destination.ElasticPool)
.WithSourceDatabase(templatedb)
.WithMode(CreateMode.Copy)
.CreateAsync(ct);
database = await database
.Update()
.WithExistingElasticPool(model.Destination.ElasticPool).ApplyAsync(ct);`
The text was updated successfully, but these errors were encountered: