How to execute large SQL scripts

1) Big SQL Script File Runner

https://bigsqlrunner.codeplex.com/

2) ApexSQL Run Script

https://knowledgebase.apexsql.com/how-to-execute-large-sql-scripts/