DbUp extension for Visual Studio Code

A Visual Studio Code extension that provides a context menu item to create DbUp script files using pre-defined format.

Installation

1. Open VS Code.
2. Ctrl+Shift+X to open the Extensions panel.
3. Search for DbUp for Visual Studio Code and install.

Configuration

This plugin will save a file using the format defined in its settings. Well-known placeholders can be used in the format and are expanded when a file is generated.

By default the plugin uses the format: V{yyyy}.{MM}.{dd}.{HH}.{mm}.{ss}_{description}.sql

Example: V2021.09.22.04.01.10_ABT-435-product-defs.sql

The format can be altered to whatever format you desire for you project/team/company.

Note that this format has been chosen by default as it meets some basic requirements:

1. Provides a file name format to allow DbUp to execute it in alph-numeric order.
2. Prevents file naming collisions regardless of what branch a file may be generated in.

Well known placeholders

These placeholders can be used anywhere in the format.

• {yyyy} - four digit year
• {MM} - two digit month
• {dd} - two digit day
• {HH} - two digit hour
• {mm} - two digit minute
• {ss} - two digit second
• {description} - description of the file as entered by the user

Changing or viewing settings

1. Open Visual Studio Code
2. Press Ctrl+, or go to File -> Preferences -> Settings
3. Expand Extensions -> DbUp