SQL Scripts for next catalog

1. Change the source and target catalog year
2. Run these scripts one at a time in the correct order
3. One of them takes a long time

RUN EACH STORED PROCEDURE, ONE AT A TIME

declare @NewCatalogId int declare @OldCatalogId int set @NewCatalogId = 4 set @OldCatalogId =3

--exec CloneUCFDegrees @SourceCatalogId=@OldCatalogId, @TargetCatalogId=@NewCatalogId --exec ClonePartnerDegree @SourceCatalogId=@OldCatalogId, @TargetCatalogId=@NewCatalogId

--exec UpdateUCFCourseId @TargetCatalogId = @NewCatalogId --exec UpdateUCFDegreeId @TargetCatalogId = @NewCatalogId

--exec CloneCourses @SourceCatalogId = @OldCatalogId --exec CloneCourseMapper @SourceCatalogId = @OldCatalogId --THIS ONE TAKES A LONG TIME

--exec CloneCustomCourseMapper @SourceCatalogId = @OldCatalogId --exec CloneCustomCourseSemester @SourceCatalogId = @OldCatalogId

--exec CloneNotes @SourceCatalogId = @OldCatalogId

--update [Catalog] set Active = 1 where id = @NewCatalogId -- SETS THE CATALOG TO ACTIVE SO THAT IS VIEWABLE ON THE PORTAL (DisplayOnWeb display it on the website) --update [Catalog] set [Current] = 1 where id = @NewCatalogId --SETS THE CURRENT CATALOG, THERE CAN ONLY BE ONE CURRENT CATALOG, SET THE RESET TO 0

--update [Catalog] set [Current] = 0 where id = 1

--update [Catalog] set [Current] = 0 where id = 2