View on GitHub

SqlBuildManager

SQL Build Manager is an all in one tool for building and maintaining a package of SQL scripts to manage builds and updates across your fleet of SQL Server databases.

Local Builds

If you have a single database to update, you can use a local build.

Sample command:

sbm build 
    --packagename "mypackage.sbm" ^
    --username "dbusername" ^
    --password "dbpassword" ^
    --server "targetserver" ^
    --database "targetdb" ^

With a local build, the build history and log are stored within the .sbm file. You can get access to the logs either by opening up the Windows app sqlbuildmanager.exe’s Logging -> Show Build Logs menu or opening the .sbm file with a Zip file handler (7-zip, Windows zip handler, etc.) and see the .log files.

FYI: an .sbm file is a zip file that contains: