JohnBost SFIv2 migration.md

Migration JohnBost SFIv2 migration

GUID Fixing

How to detect problems:

ControlSecurityConfiguration

SELECT
	STRING_AGG(CAST(id as nvarchar(50)), ' / ')
FROM ControlSecurityConfiguration
GROUP BY
	idControl,
    idScreenSecurityConfiguration
HAVING COUNT(*) > 1

ViewEntityFieldConfiguration

SELECT
	STRING_AGG(CAST(id as nvarchar(50)), ' / ')
FROM ViewEntityFieldConfiguration
GROUP BY
	idEntityType,
	idAdminField,
	idField,
	idViewEntity
HAVING COUNT(*) > 1

DataStreamMappingConfiguration

SELECT
	STRING_AGG(CAST(id as nvarchar(50)), ' / ')
FROM DataStreamMappingConfiguration
GROUP BY
	destField,
	idDataStreamCommandConfiguration,
	destinationParameter
HAVING COUNT(*) > 1

JohnBost

Fix ControlSecurityConfiguration

DELETE FROM ControlSecurityConfiguration
WHERE id IN (
	'7B89260A-FDA3-44BA-BEC6-A84000CE374E',
	'B109DE73-D523-4D18-96D3-A79A011F6D3E',
	'B4E48411-C9EA-420F-BAF6-A79A011F6DA0',
	'66C26623-4901-4C1B-9F2A-A79A011F6DCF',
	'BA8912E8-EAC3-4010-A704-A79A011F6DFE',
	'AF0D4BB8-E935-4A85-B8F9-A79A011F6E2D',
	'BDF11AC0-A447-4C84-A3EC-A76E0106F59E',
	'AAE600C9-722E-40CB-956E-A76E0106F600'
)

ViewEntityFieldConfiguration

DELETE FROM ViewEntityFieldConfiguration
WHERE id IN (
	'0EF6B874-FCEF-4330-80AC-A7710119BA8D',
	'BAA71EF2-B688-4ABA-B95D-A79400F2EA9D',
	'D019F2EE-0F4E-4DC6-B371-A79400F45C27',
	'7D0EF864-950F-4FC9-9C2B-A79400F45C27',
	'6FB6A1F9-3E5A-40B9-865F-A75200BF4EBE'
)

DataStreamMappingConfiguration

DELETE FROM DataStreamMappingConfiguration
WHERE id IN (
	'AED147D0-EC7B-45C7-B796-A799010A9574',
	'DB654E87-0896-4C75-827D-A799010A9574',
	'AA838337-90DB-4219-8576-A79400EEDD9D',
	'4E8F7327-08BC-467C-8CB5-A79400EEDD9D',
	'CDE815E6-13E0-4EBD-AF5C-A79400EEDD9D',
	'D56C3B07-F8F9-4AA4-A318-A799010A9574',
	'D42E3CCF-3248-42AD-ABB8-A799010A9574',
	'884BE194-32C3-4F01-AE50-A799010A9574',
	'5311B11B-8BED-4CBF-9529-A79400EEDD9D',
	'D5093B5C-D1EB-450A-83AE-A799010A9574',
	'77D9034D-2F30-4990-AA86-A79400EEDD9D',
	'212BC0A3-0FA9-47B5-8180-A799010A9574',
	'FFA6C657-1DD6-481E-9D0D-A79400EEDD9D'
)