We can use the SQL Compare Pro command line with PowerShell to automate the process of creating a new build script for a version of the database, from the object scripts in the VCS. However, what if we want to include static data in the build? This article describes how to the use the... read more
In a previous article, Getting started with SQL Clone, I described how SQL Clone could remove much of the administrative burden from the database provisioning process, the advantages of a new, lightweight process to spin up “real databases” for use in development and test work, and finally how to produce data images and then... read more
For large databases, it’s a hard and time consuming task to provide database developers with development or test copies of that database that resemble the production database, in terms of the size, distribution and nature of the data. It can take a lot of time to produce a copy of the latest database build,... read more
Many organizations invest heavily in their User Acceptance Testing (UAT) environments, setting up infrastructures that mimic the production environment, often using replicated production data. This is important because it means they can perform acceptance testing as well as security testing, performance testing, error-handling testing, and stress/load testing in production-like conditions, and so be confident... read more
