SQL SCRIPT RUNNER

SQL script runner is a package, wich run script from concrete folder and subfolder. You can use it when you have database firs project and before start server you want to update your database.

Setup model fields

• ConnectionString: Connection string to database,
• FolderPath: Path to root folder with sql script
• DeployScriptsTableName: Name of table where will be keep all deployed scripts
• DataBaseType: Typeof database (Postgresql, Mssql, Mysql)
• InitFolderPath: Path to folder with init scripts (like create database or create schema)

Example of use

var scriptRunner = SqlScriptRunner.GetScriptRunner(new SetupModel { ConnectionString = "Server=localhost; Database=tests; User Id=sa; Password=pa55w0rd!;TrustServerCertificate=true", FolderPath = "/mssql/scripts", InitFolderPath = "/mssql/scripts/init", DataBaseType = DataBaseTypeEnum.Mssql }).RunDeploy();

This example will be run all scripts (*.sql file) from folder /mssql/scripts folder and subfolders