MSI Package setup for MVC.Net core web app

Here is the requirement given below .. => MS-SQL with custom "sa" username & Password without user input.. => Running SQL Script to generate Database => install .net core 3.1 , .net core hosting bundle 6.0 => Configure IIS . => copy web application files => run web application on localhost using IIS server => port open inbound rule create => basic training & documentation The software priority [login to view URL] but we can also use installshield, innosetup , wixtoolset etc.