Product articles SQL Change Automation Database Testing

  • SQL Change Automation
  • Generating Realistic Test Data
  • Database Testing

Build and fill a database using JSON and SQL Change Automation

Phil Factor demonstrates how to export data from a database, as JSON files, validate it using JSON Schema, then build a fresh development copy of the database using SQL Change Automation, and import all the test data from the JSON files. Read more

  • SQL Change Automation
  • Database Builds and Deployments
  • Database Testing

Deploying Multiple Databases from Source Control using SQL Change Automation

How to automatically build multiple test databases, from source control, and then fill them with standard test data sets, using SQL Change Automation, BCP and some PowerShell magic. Read more

  • SQL Data Generator
  • SQL Change Automation
  • Development and Testing with Clones
  • Database Testing

Basic data masking for development work using SQL Clone and SQL Data Generator

Richard Macaskill describes a lightweight copy-and-generate approach for making a sanitized database build available to development teams, using SQL Clone, SQL Change Automation and SQL Data Generator. Read more

Topics

  • Automation and workflow
  • Compliant Database Provisioning
  • Database Build tasks
  • Database Builds and Deployments
  • Database Continuous Integration
  • Database Deployments
  • Database DevOps
  • Database Development in SSMS
  • Database Development in Visual Studio
  • Database Documentation
  • Database Source Control
  • Database Testing
  • Development and Testing with Clones
  • Generating Realistic Test Data
  • Masking Data for Development and Testing
  • Performance monitoring and optimization
  • SQL Code Analysis
  • Schema Comparison Options
  • Server availability and health
  • Working with Containers

Filter by level