az sql db update doesn't work if --edition Basic --service-objective Basic
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 3.5k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 60
Description
### Type of issue
Code doesn't work
### Reference command name
I use `az sql db update` quite a lot as I have a script that scale databases.
I have no problem running it and scale Azure SQL Database to whatever tier like:
`az sql db update -s MyServer -g MyResourceGroup -n MyDatabase --edition Standard --service-objective S2 --subscription "MySubscription"`
Problems arrive when I run something like:
`az sql db update -s MyServer -g MyResourceGroup -n MyDatabase --edition Basic --service-objective Basic --subscription "MySubscription"`
In that case the database won't scale and returns the error:
`Error | ERROR: (InvalidMaxSizeTierCombination) The tier 'Basic' does not support the database max size '268435456000'.`
But then I scale from `S0` to `Basic` form the Portal and everything works fine.
You don't believe it?
Look at this picture

### Feedback
There is a bug in the AZ SQL module when scaling to Basic.
For all other edition and tier there is no problem
### Page URL
https://learn.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-update
### Content source URL
https://github.com/MicrosoftDocs/azure-docs-cli/blob/main/docs-ref-autogen/Latest-version/latest/sql/db.yml
### Author
@mikefrobbins
### Document Id
4c91220f-45c6-84de-2473-07c1cd296beb
Contributor guide
Assessment
This issue has not been assessed yet.