Azure SQL Database
An Azure relational database service.
6,326 questions
Azure upgrade sql database from Gen 4 to Gen 5
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 11%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Simar
6
Reputation points
I am trying to upgrade my SQL database from Gen4 to Gen5 but I get the following error message -
"The current Pool Performance and per database performance settings do not allow the number of databases selected. " What to do in such a case?
![110105-sql.png][2]
Azure SQL Database
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,631 Reputation points2021-06-29T10:56:40.543+00:00 Hi @Simar , welcome to Microsoft Q&A forum.
Could you please provide more details related to existing configuration and the new configuration you want to upgrade to? Below are the details that would help:
- Existing Pool Setting vs New Pool Setting
- Existing per database settings vs new Per Database setting
- How many databases are there?
Sign in to comment
Sign in to answer