As a test automation engineer, I want to spin up a fresh database quickly. What I don't want to do is copy-paste each and every update script and then execute them one by one in the MSSQL management tools GUI.
With db-cola I can update multiple databases in seconds. No more copy-paste-executing procs. No more confusion with multiple MSSQL management tool windows. Just a quick update---the way it should be!
-
Run certain scripts first, or omit certain ones. Need to execute your scripts in a specific order? db-cola has you covered.
-
Replace
USE [database]
easily. Does your script specify a database, but you want to execute it on a different one? No problem. Easily replace database names and usernames (and anything else!) without having to modify your sql files. -
Prevent errors with GO groups. db-cola automagically inserts GO statements into your script to avoid errors, without saving any changes to your file.
-
Log it. You can schedule a task to run db-cola and log the results in a file, or you can sit and watch db-cola's magic in the console.
-
Update multiple databases. You can specify one or many database connection strings. db-cola will connect to and update them all.
I use db-cola alongside database snapshots for fast database modification and restoration. Click here for an example.