text: -- SPDX-License-Identifier: Apache-2.0
  -- Licensed to the Ed-Fi Alliance under one or more agreements.
  -- The Ed-Fi Alliance licenses this file to you under the Apache License, Version 2.0.
  -- See the LICENSE and NOTICES files in the project root for more information.
  
  PRINT N'Converting type to descriptor on [edfi].[StudentSchoolAssociationEducationPlan]'
  GO
  
  EXEC [migration_tempdata].[sp_ConvertTypeToDescriptor]
  'edfi', 'StudentSchoolAssociationEducationPlan',
  'edfi', 'EducationPlanDescriptor',
  'edfi', 'EducationPlanType'
  GO
  
  ALTER TABLE [edfi].[StudentSchoolAssociationEducationPlan]
  ALTER COLUMN [EducationPlanDescriptorId] [int] NOT NULL
  GO
  
  ALTER TABLE [edfi].[StudentSchoolAssociationEducationPlan]
  DROP COLUMN [EducationPlanTypeId]
  GO
  
  