View difference between Paste ID: BVWP4PMV and 8BG37Ec8

 
 
 /*
 ------------------------------------------
 -- Create the SQL Scripts
 ------------------------------------------
 USE	SDS_KelsoSchoolDistrict_Staging_Wespac
 GO
 
 SELECT    'TRUNCATE TABLE ' + sysobjects.name
 FROM      sysobjects
 WHERE     sysobjects.name LIKE 'IdMap%'
 
 SELECT    'TRUNCATE TABLE ' + REPLACE(sysobjects.name, 'IdMap', '')
 FROM      sysobjects
 WHERE     sysobjects.name LIKE 'IdMap%'
 ORDER BY sysobjects.name
 */
 
 
 
 --USE	SDS_KelsoSchoolDistrict_Staging_Wespac
 --USE	SDS_SheltonSchoolDistrict_Staging_Wespac
 --USE SDS_IssaquahSchoolDistrict_Staging_Wespac
 --USE SDS_BainbridgeIslandSchoolDistrict_Staging_Wespac
 --USE SDS_YakimaSchoolDistrict_Staging_Wespac
 USE SDS_NorthThurstonSchoolDistrict_Staging_Wespac
 GO
 
 
 TRUNCATE TABLE IdMapGuardians
 TRUNCATE TABLE IdMapApplicationUserRoles
 TRUNCATE TABLE IdMapStudentGradePointAverages
 TRUNCATE TABLE IdMapGradePointAverageTypes
 TRUNCATE TABLE IdMapStudentFoodserviceSubsidies
 TRUNCATE TABLE IdMapAbsenceTypes
 TRUNCATE TABLE IdMapStudentHandicappingConditions
 TRUNCATE TABLE IdMapHandicappingConditions
 TRUNCATE TABLE IdMapPhoneNumbers
 TRUNCATE TABLE IdMapPersons_PhoneNumbers
 TRUNCATE TABLE IdMapPersonSchoolDepartmentAssignments
 TRUNCATE TABLE IdMapDisciplineActions
 TRUNCATE TABLE IdMapPrincipalSchoolYears
 TRUNCATE TABLE IdMapPrincipals
 TRUNCATE TABLE IdMapClassTermDateRanges
 TRUNCATE TABLE IdMapLanguages
 TRUNCATE TABLE IdMapEntities_Addresses
 TRUNCATE TABLE IdMapEntities
 TRUNCATE TABLE IdMapAddresses
 TRUNCATE TABLE IdMapTeacherSchoolYears
 TRUNCATE TABLE IdMapStudentSchoolYears
 TRUNCATE TABLE IdMapClassTermTypes
 TRUNCATE TABLE IdMapPhoneNumberTypes
 TRUNCATE TABLE IdMapFakePersons
 TRUNCATE TABLE IdMapStudentDisciplineRecords
 TRUNCATE TABLE IdMapDisciplineOffenses
 TRUNCATE TABLE IdMapClassTeachingAssignments
 TRUNCATE TABLE IdMapClasses
 TRUNCATE TABLE IdMapPersons_Languages
 TRUNCATE TABLE IdMapPersons_Ethnicities
 TRUNCATE TABLE IdMapStudentClassEnrollments
 TRUNCATE TABLE IdMapAutomatedLoginApplications
 TRUNCATE TABLE IdMapStudentClassAttendanceRecords
 TRUNCATE TABLE IdMapEntities_EmailAddresses
 TRUNCATE TABLE IdMapEntities_PhoneNumbers
 TRUNCATE TABLE IdMapPersons_Addresses
 TRUNCATE TABLE IdMapStudentClassTermGrades
 TRUNCATE TABLE IdMapClassAttendanceRecords
 TRUNCATE TABLE IdMapEmployees
 TRUNCATE TABLE IdMapGradeLevels
 TRUNCATE TABLE IdMapActivities_SupervisoryPersons
 TRUNCATE TABLE IdMapEmailAddressTypes
 TRUNCATE TABLE IdMapSchoolDistricts
 TRUNCATE TABLE IdMapAddressTypes
 TRUNCATE TABLE IdMapStudents_HealthConditions
 TRUNCATE TABLE IdMapSchoolYears
 TRUNCATE TABLE IdMapSchoolTypes
 TRUNCATE TABLE IdMapClassTerms
 TRUNCATE TABLE IdMapClassTermSegments
 TRUNCATE TABLE IdMapSchools
 TRUNCATE TABLE IdMapActivities
 TRUNCATE TABLE IdMapSkywardPersons
 TRUNCATE TABLE IdMapPersons
 TRUNCATE TABLE IdMapAbsenceReasons
 TRUNCATE TABLE IdMapTeachers
 TRUNCATE TABLE IdMapSchoolDepartments
 TRUNCATE TABLE IdMapStudents_Activities
 TRUNCATE TABLE IdMapStudents
 TRUNCATE TABLE IdMapEthnicities
 TRUNCATE TABLE IdMapGuardianTypes
 TRUNCATE TABLE IdMapPersons_EmailAddresses
 TRUNCATE TABLE IdMapEmailAddresses
 TRUNCATE TABLE IdMapFoodServiceSubsidies
 TRUNCATE TABLE IdMapStudentIllnessRecords
 TRUNCATE TABLE IdMapHealthConditions
 TRUNCATE TABLE IdMapStudentGuardianRelationships
 
 
 
 
 --USE	SDS_KelsoSchoolDistrict
 --USE	SDS_SheltonSchoolDistrict
 --USE SDS_IssaquahSchoolDistrict
 --USE SDS_BainbridgeIslandSchoolDistrict
 --USE SDS_YakimaSchoolDistrict
 USE SDS_NorthThurstonSchoolDistrict
 GO
 
 
 
 -- Student Attendance, Absence, and reasons
 TRUNCATE TABLE StudentClassAttendanceRecords
 DELETE AbsenceReasons
 DBCC CHECKIDENT ('AbsenceReasons', RESEED, 0)
 DELETE AbsenceTypes
 DBCC CHECKIDENT ('AbsenceTypes', RESEED, 0)
 
 
 -- Student Activities
 TRUNCATE TABLE Activities_SupervisoryPersons
 TRUNCATE TABLE Students_Activities
 DELETE Activities
 DBCC CHECKIDENT ('Activities', RESEED, 0)
 
 
 
 -- Student Health, handicapps, and Illness
 TRUNCATE TABLE Students_HealthConditions
 TRUNCATE TABLE StudentIllnessRecords
 DELETE HealthConditions
 DBCC CHECKIDENT ('HealthConditions', RESEED, 0)
 TRUNCATE TABLE StudentHandicappingConditions
 DELETE HandicappingConditions
 DBCC CHECKIDENT ('HandicappingConditions', RESEED, 0)
 
 
 
 
 
 -- Classes, Enrollments Assignment
 TRUNCATE TABLE StudentClassTermGrades
 DELETE StudentClassEnrollments
 DBCC CHECKIDENT ('StudentClassEnrollments', RESEED, 0)
 DELETE ClassAttendanceRecords
 TRUNCATE TABLE ClassTeachingAssignments
 DBCC CHECKIDENT ('ClassTeachingAssignments', RESEED, 0)
 DELETE Classes
 DBCC CHECKIDENT ('Classes', RESEED, 0)
 
 
 
 
 
 
 -- Class Terms, Types, and Segments
 TRUNCATE TABLE ClassTermDateRanges
 DELETE ClassTermSegments	--DBCC CHECKIDENT ('ClassTermSegments', RESEED, 0)
 DELETE ClassTerms			--DBCC CHECKIDENT ('ClassTerms', RESEED, 0)
 DELETE ClassTermTypes		--DBCC CHECKIDENT ('ClassTermTypes', RESEED, 0)
 
 
 TRUNCATE TABLE StudentFoodserviceSubsidies
 DELETE FoodServiceSubsidies
 DBCC CHECKIDENT ('FoodServiceSubsidies', RESEED, 0)
 
 
 -- Student Discipline
 TRUNCATE TABLE StudentDisciplineRecords
 DELETE DisciplineActions
 DBCC CHECKIDENT ('DisciplineActions', RESEED, 0)
 DELETE DisciplineOffenses
 
 
 
 
 -- Student Grade-Point averages
 TRUNCATE TABLE StudentGradePointAverages
 DELETE GradePointAverageTypes
 DBCC CHECKIDENT ('GradePointAverageTypes', RESEED, 0)
 
 
 -- School District Departments
 TRUNCATE TABLE PersonSchoolDepartmentAssignments
 DELETE SchoolDepartments
 DBCC CHECKIDENT ('SchoolDepartments', RESEED, 0)
 DELETE SchoolDistricts	--DBCC CHECKIDENT ('SchoolDistricts', RESEED, 0)
 
 
 
 
 
 
 
 
 -- Role/School year augmented association records
 DELETE PrincipalSchoolYears
 DELETE StudentSchoolYears
 DELETE TeacherSchoolYears
 
 
 -- Schools, Types, and School Years
 DELETE Schools
 DBCC CHECKIDENT ('Schools', RESEED, 0)
 DELETE SchoolTypes	--DBCC CHECKIDENT ('SchoolTypes', RESEED, 0)
 DELETE SchoolYears	--DBCC CHECKIDENT ('SchoolYears', RESEED, 0)
 
 
 
 -- Roles
 TRUNCATE TABLE StudentGuardianRelationships
 TRUNCATE TABLE SkywardPersons
 TRUNCATE TABLE Employees
 DELETE Principals	--DBCC CHECKIDENT ('Principals', RESEED, 0)
 DELETE Teachers		--DBCC CHECKIDENT ('Teachers', RESEED, 0)
 DELETE Students		--DBCC CHECKIDENT ('Students', RESEED, 0)
 DELETE Guardians	--DBCC CHECKIDENT ('Guardians', RESEED, 0)
 DELETE GuardianTypes
 DBCC CHECKIDENT ('GuardianTypes', RESEED, 0)
 
 
 
 
 
 
 
 
 
 -- Contact info association records
 TRUNCATE TABLE Persons_Addresses
 TRUNCATE TABLE Entities_Addresses
 TRUNCATE TABLE Entities_EmailAddresses
 TRUNCATE TABLE Entities_PhoneNumbers
 TRUNCATE TABLE Entities_Addresses
 TRUNCATE TABLE Persons_EmailAddresses
 TRUNCATE TABLE Persons_Ethnicities
 TRUNCATE TABLE Persons_Languages
 TRUNCATE TABLE Persons_PhoneNumbers
 
 
 
 -- Languages, Ethnicities and Subsidies
 DELETE Languages
 DBCC CHECKIDENT ('Languages', RESEED, 0)
 DELETE Ethnicities
 DBCC CHECKIDENT ('Ethnicities', RESEED, 0)
 
 
 
 -- Automated Logins and Application Users
 TRUNCATE TABLE AutomatedLoginAccounts
 DELETE AutomatedLoginApplications	--DBCC CHECKIDENT ('AutomatedLoginApplications', RESEED, 0)
 TRUNCATE TABLE ApplicationUsers_Roles
 DELETE ApplicationUsers
 DBCC CHECKIDENT ('ApplicationUsers', RESEED, 0)
 
 
 
 -- Contact info records
 DELETE EmailAddresses
 DBCC CHECKIDENT ('EmailAddresses', RESEED, 0)
 DELETE PhoneNumbers
 DBCC CHECKIDENT ('PhoneNumbers', RESEED, 0)
 DELETE Addresses
 DBCC CHECKIDENT ('Addresses', RESEED, 0)
 
 
 
 
 DELETE Persons
 DBCC CHECKIDENT ('Persons', RESEED, 0)
 
 DELETE Entities
 DBCC CHECKIDENT ('Entities', RESEED, 0)