Features - Herdo/SSDTLifecycleExtension GitHub Wiki

Artifact Creation

The artifact creation contains two primary workflows: scaffolding and script creation.

Scaffolding will support you to kick off your SSDT development, by providing you with initial DACPAC files, either for a blank development database project, labled 0.0.0, or from an already filled database project, labled 1.0.0.

Script creation is the primary component of the SSDT lifecycle extension. This will be creating diff scripts for you that represent the changes you make in your database projects. These generated scripts can then be reviewed, before getting automatically deployed to the database by the tools of your choice.

Version History Viewer

This feature is under construction.

Configuration

The configuration allows you to individualize the extension to the needs of your business workflow. The default configuration is targeted at the most basic use, but there are more options available to allow useful customization.

The standard configuration is provided without any extra work. However, if you want to customize your configuration, a ssdtlifecycle.json file will be saved in the Properties folder of your SQL database project. This allows you to put your configuraiton under version control, or even share the same configuration across multiple projects.

For a detailed guide about available configurations, please have a look at the configuration documentation.