I wanted to know if there is a way in solidCP or sql scripts that are available to switch a service form one type to another and all addons/quotas etc.
I would like to upgrade SQL 2014 servers to SQL 2016.
You can switch the provider in the Enterprise server SQL.
You can change the provider in [dbo].[Services] table of the database. From ProviderID 1203 to 1701 (Double check the ProviderID in [dbo].[Providers] to make sure these are correct for your database).
Thanks Trevor – I was aware of that. Any easy way to update all of the quotas?
To do the change of MsSQL you need to do this in the series of steps:
1) Change the ProviderID in [dbo].[Services] to match the new one found in [dbo].[Providers].
2) Modify the GroupID in [dbo].[HostingPlanResources]. You can find this in [dbo].[ResourceGroups].
3) Modify the QuotaID in [dbo].[HostingPlanQuotas]. The QuotaID can be found in [dbo].[Quotas].
Do note: For MsSQL there are 7 Quotas and they may not be sequentional numbers.
This should then change the quota in the hosting plan and for the customers.