duplicated block id: 1 size: 78 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (58:148) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (57:146) duplicated block id: 2 size: 72 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (66:148) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (94:176) duplicated block id: 3 size: 71 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (67:148) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (94:173) duplicated block id: 4 size: 37 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (13:53) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (16:57) duplicated block id: 5 size: 30 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (157:190) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (152:185) duplicated block id: 6 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/RunSQLStatementExportCSV.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (16:45) duplicated block id: 7 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (16:45) duplicated block id: 8 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (16:45) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (16:45) duplicated block id: 9 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/RunSQLStatementExportCSV.ps1 (13:42) duplicated block id: 10 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/RunSQLStatementExportCSV.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (16:45) duplicated block id: 11 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/CreateSQLDWExtTableStatements.ps1 (16:45) duplicated block id: 12 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (16:45) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (16:45) duplicated block id: 13 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (13:42) - Assessment/AssessmentDriver_V2.ps1 (15:44) duplicated block id: 14 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/RunSQLStatementExportCSV.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/CreateSQLDWExtTableStatements.ps1 (16:45) duplicated block id: 15 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (16:45) duplicated block id: 16 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (16:45) - Assessment/AssessmentDriver_V2.ps1 (15:44) duplicated block id: 17 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (16:45) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/CreateSQLDWExtTableStatements.ps1 (16:45) duplicated block id: 18 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/CreateSQLDWExtTableStatements.ps1 (16:45) - Assessment/AssessmentDriver_V2.ps1 (15:44) duplicated block id: 19 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/CreateSQLDWExtTableStatements.ps1 (16:45) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (16:45) duplicated block id: 20 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (16:45) - Assessment/AssessmentDriver_V2.ps1 (15:44) duplicated block id: 21 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/RunSQLStatementExportCSV.ps1 (13:42) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (16:45) duplicated block id: 22 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (16:45) - Assessment/AssessmentDriver_V2.ps1 (15:44) duplicated block id: 23 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/RunSQLStatementExportCSV.ps1 (13:42) - Assessment/AssessmentDriver_V2.ps1 (15:44) duplicated block id: 24 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (16:45) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (16:45) duplicated block id: 25 size: 27 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/CreateSQLDWExtTableStatements.ps1 (16:45) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (16:45) duplicated block id: 26 size: 24 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (272:296) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (264:289) duplicated block id: 27 size: 18 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts/CleanScripts.py (201:221) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas/ChangeSchemas.py (230:250) duplicated block id: 28 size: 17 cleaned lines of code in 2 files: - Assessment/AssessmentDriver_V2.ps1 (403:422) - Assessment/AssessmentDriver_V2.ps1 (465:484) duplicated block id: 29 size: 16 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts/CleanScripts.py (224:244) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas/ChangeSchemas.py (253:272) duplicated block id: 30 size: 14 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (153:167) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (180:194) duplicated block id: 31 size: 14 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunSQLScriptFile.ps1 (104:119) - Assessment/RunSQLStatement.ps1 (156:172) duplicated block id: 32 size: 14 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (30:43) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (30:43) duplicated block id: 33 size: 14 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (158:172) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (180:194) duplicated block id: 34 size: 13 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunSQLScriptFile.ps1 (125:138) - Assessment/RunSQLStatement.ps1 (180:193) duplicated block id: 35 size: 13 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (196:211) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (191:206) duplicated block id: 36 size: 11 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/CopyDataToExcel.ps1 (30:44) - Assessment/CopyDataToExcel_V2.ps1 (76:90) duplicated block id: 37 size: 11 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunSQLScriptFile.ps1 (144:155) - Assessment/RunSQLStatement.ps1 (200:212) duplicated block id: 38 size: 10 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/PreAssessmentDriver.ps1 (44:53) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts/ScriptMPPObjectsDriver.ps1 (14:24) duplicated block id: 39 size: 10 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts/ScriptMPPObjectsDriver.ps1 (14:24) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (47:57) duplicated block id: 40 size: 9 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (203:212) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (338:348) duplicated block id: 41 size: 9 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (44:52) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (45:53) duplicated block id: 42 size: 9 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts/CleanScripts.py (51:63) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas/ChangeSchemas.py (89:101) duplicated block id: 43 size: 9 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (17:27) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (17:27) duplicated block id: 44 size: 8 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (219:228) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (215:224) duplicated block id: 45 size: 8 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (60:68) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (119:127) duplicated block id: 46 size: 8 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (6:15) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (6:15) duplicated block id: 47 size: 8 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/ScriptCreateExportImportStatementsDriver.ps1 (7:14) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/ScriptCreateExternalTableDriver.ps1 (7:14) duplicated block id: 48 size: 7 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (205:211) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunDSQLScriptsDriver.ps1 (283:289) duplicated block id: 49 size: 7 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (279:285) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (434:440) duplicated block id: 50 size: 7 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW/Generate_Step5_ConfigFiles.ps1 (271:278) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (434:440) duplicated block id: 51 size: 6 cleaned lines of code in 2 files: - Assessment/AssessmentDriver_V2.ps1 (394:399) - Assessment/AssessmentDriver_V2.ps1 (448:453) duplicated block id: 52 size: 6 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/CopyDataToExcel.ps1 (1:6) - Assessment/CopyDataToExcel_V2.ps1 (1:6) duplicated block id: 53 size: 6 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/RunSQLScriptFile.ps1 (96:102) - Assessment/RunSQLStatement.ps1 (147:153) duplicated block id: 54 size: 6 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment/CopyDataToExcel.ps1 (8:13) - Assessment/CopyDataToExcel_V2.ps1 (8:13) duplicated block id: 55 size: 6 cleaned lines of code in 2 files: - APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript/Generate_Step4_ConfigFiles.ps1 (4:9) - APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw/Generate_Step6_ConfigFiles.ps1 (4:9)