How to build-and-fill multiple development databases using PowerShell and SQL Data Generator

This article offers a build-and-fill method for development databases, where each developer will subsequently want to alter the data or metadata in his or her copy of the database. Read more

Creating database documentation in ePub format using SQL Doc and PowerShell

Phil Factor provides a PowerShell script that uses SQL Doc produce database documentation and then pandoc to publish it in ePub format. Read more

How to Automatically Fill your SQL Server Test Databases with Dummy Data

A PowerShell script to automatically populate a SQL Server database with dummy data, for database development and testing work. Read more

SQL Clone: the aspirin for your database provisioning headaches

For teams who use a shared development database out of necessity rather than choice, SQL Clone might make the dedicated model viable for the first time. Read more

Team-based database development with SQL Clone

For most development teams, the database provisioning process involves some element of compromise. Either the process is slow, but the database is realistic or the process is fast but the database unrealistic. Chris Hurley explains why SQL Clone can allow the team to develop and test with a real database, without the compromises. Read more

How to build multiple database versions from the same source: pre-deploy migration scripts

The final part of Alex Yates's three-part series tackles the complicated issue of automating deployments when the same table might have a different structure, in different production versions of the database. Read more

Getting started with SQL Doc and PowerShell

Phil Factor uses PowerShell and SQL Doc to automatically generate database documentation, and update it on every successful build. Read more

SQL Clone and backups protected with TDE – part 2

Steve Jones proves that SQL Clone can create a clone from a TDE-protected SQL Server database backup. Read more

SQL Clone and databases protected with TDE – part 1

Steve Jones proves that SQL Clone can create a clone from a SQL Server database that is protected by Transparent Data Encryption (TDE). Read more

Automating DacPac deployments using the SQL Compare command line and PowerShell

How to extract a database migration script, or a database build script, from a DacPac and then use it in a PowerShell-automated database deployment. Read more

Redgate Test Data Manager

Redgate Flyway

Redgate Monitor

Overview

Protect

Automate

Monitor

Product articles