PRINT N'----------------------------------------------------------------------------------------------------------------------'
PRINT N'-- Refactor 2.5'
PRINT N'----------------------------------------------------------------------------------------------------------------------'
GO
PRINT N'----------------------------------------------------------------------------------------------------------------------'
PRINT N'-- Cleanup formatted files'
PRINT N'----------------------------------------------------------------------------------------------------------------------'
GO
delete [mig_director].[Folder] where [FolderId] in ('FormatFiles', 'LoadFiles', 'SourceDuplicates', 'Archive')
delete [mig_director].[TrackFolder] where [FolderId] in ('FormatFiles', 'LoadFiles', 'SourceDuplicates', 'Archive')
go
PRINT N'----------------------------------------------------------------------------------------------------------------------'
PRINT N'-- Cleanup obsolete Table load options'
PRINT N'----------------------------------------------------------------------------------------------------------------------'
GO
delete [mig_director].[DirectorOption] where [OptionName] in (
	'Export.SaveCommandFile'
,	'Export.TableLoadBatchSize'
,	'Export.TableLoadMaxErrors'
,	'Export.TableLoadTimeOut'
,	'Export.FuzzyLoad'
)
go
PRINT N'Update complete.'
GO