Product articles
How to deploy a database plus static data using SQL Compare and SQL Data Compare
Tony Davis shows how to get a database, plus any static data, into source control, and then uses the "/include:StaticData" switch in the SQL Compare Pro command line, fromPowerShell, to automate the process of creating a new build script. Read more
Backup and restore of a SQL Clone
What if you now do development work on a clone, but you to continue working on you own local clone while ‘disconnected’, such as when travelling? One simple option if the original database contains no private data, or the image has been masked, is to performance a normal backup and restore operations the clone, although you'll now be working with a normal, full-sized database. Read moreAutomating database deployments to and from source control using SQL Compare and PowerShell
How to use SQL Compare Pro command line with PowerShell to automate the processes of getting a new database into source control, updating the source with the latest database changes, creating a new build script for a database version, and creating a deployment script to synchronize an existing database with source. Read moreAutomatically keeping ‘hotfix’ and production database schemas in sync
How to use the SQL Compare Pro command line to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the source database. Read moreHow to use custom filters in SQL Compare
How to use filters in SQL Compare, when you don’t work with all the objects in a database. Read more
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 moreCreating 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 moreHow 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 moreHow 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 moreRedgate Hub
-
Product Articles
Tips and how-to guides for Redgate products
-
University
Easy to follow video courses
-
Events
Join us online, or get sponsored
-
Forums
Ask, discuss, and solve questions about Redgate's tools
-
Community
Develop your skills and meet Redgate Advocates and Friends
-
Simple Talk
In-depth articles and opinion from Redgate's technical journal