#1 SQL script for updating DotNetPanel database to WebsitePanel

[Webio]

This script is changing assemblies name from DotNetPanel. and DNP. to WebsitePanel. in all places I've found inside DotNetPanel DB:

UPDATE Providers SET ProviderType = REPLACE(REPLACE(ProviderType,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');
UPDATE ServiceItemTypes SET TypeName = REPLACE(REPLACE(TypeName,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');
UPDATE ecSupportedPlugins SET TypeName = REPLACE(REPLACE(TypeName,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');
UPDATE ecProductType SET ProvisioningController = REPLACE(REPLACE(ProvisioningController,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.'), NativeItemType = REPLACE(REPLACE(NativeItemType,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.'), ServiceItemType = REPLACE(REPLACE(ServiceItemType,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');
UPDATE ResourceGroups SET GroupController = REPLACE(REPLACE(GroupController,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');
UPDATE ScheduleTasks SET TaskType = REPLACE(REPLACE(TaskType,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');
UPDATE ServiceDefaultProperties SET PropertyValue = REPLACE(REPLACE(PropertyValue,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');

[Webio]

as far I can see only this entries must be updated for making DotNetPanel DB to work under new WebsitePanel assemblies.

[Webio]

One more place to update:

UPDATE ServiceProperties SET PropertyValue = REPLACE(REPLACE(PropertyValue,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');

[Webio]

and another place for upgrade:

UPDATE ScheduleTaskViewConfiguration SET [Description] = REPLACE([Description],'DotNetPanel','WebsitePanel');

[Webio]

and one more place:

UPDATE ecSystemTriggers SET TriggerHandler = REPLACE(REPLACE(TriggerHandler,'DotNetPanel.','WebsitePanel.'),'DNP.','WebsitePanel.');

[Webio]

Remember to run last query because I had problems with registering new clients. Their invoices couldn't be approved. I'm not sure if this affects other payment providers than Offline with auto approval (I'm using it to allow new clients to have 14 days of testing and I'm checking time perioed after registration on my own).

[Pavel Tsurbeleu]

One more place that has been overlooked is:

UPDATE [dbo].[UserSettings] SET [SettingsName] = N'WebsitePanelPolicy' WHERE [SettingsName] = N'DnpPolicy'
GO