Product Articles for Automated Deployments using the PowerShell Cmdlets
Published 24 September 2019
These articles demonstrate the use of SCA's PowerShell cmdlets, offering practical implementation examples. The database source in most cases is any set of object-level build scripts (established using SQL Source Control, or by other means) that represent the current state of the database version we want to build
Article Title | Brief Description | Featured cmdlets |
A 30K ft view of the SCA PowerShell cmdlets using workflow diagrams to explain their interaction and simple PS scripts to demo database builds or updates. | ||
Simple SQL Change Automation Scripting: Connections, iProjects and Builds | Demos each of the main SCA data objects for building databases, namely the database connection, project and build objects | |
Describes what's in the release object (the Update script to do the synchronization, an HTML report of the release, and a report of any code issues) and demos basic scripts for using it in SCA build and update operations | ||
Validate a database build, document the database | ||
Build and fill a database using JSON and SQL Change Automation | Sync a test database with source control using SCA, then fill with validated test data held in JSON files | |
SQL Change Automation Scripting: Getting Data into a Target Database | Single row or bulk load strategies for getting data into a database build | |
How to create 'stub' objects, in SQL Change Automation pre-deployment scripts, to overcome the problems caused by 'missing objects' when building databases that have circular, or mutual, dependencies | ||
