Welcome to the treasure trove of Red Gate's free tools. These tools are absolutely free, no sign-up is required, but there's also no technical support. You can leave questions and comments for many of these tools on the Red Gate Forum, under the discontinued or unsupported categories.
Data Cleanser is a free SSIS component that allows you to carry out common data cleansing tasks, such as: converting currencies, trimming strings, normalizing letter cases and data formats, finding and replacing text based on a regular expression. Download.
This is a small .NET application that can be used to collect useful system information. It can copy the data to the clipboard or a logfile ready to be emailed back to our Support team. It needs the .NET framework installed, and should be run locally from the computer to be 'diagnosed'. Open the zip archive and drag the executable file to the computer's desktop, then run it and follow the instructions! Download.
A small utility for moving and merging database lists from Red Gate SQL Multi Script. Download.
A tool that lets you interactively run and view test scripts created by Red Gate's ANTS Load software. Download.
A tool for analyzing application memory usage, including loaded libraries, system heap memory and .NET memory. Download.
A nifty little tool that allows you to compare snapshot files from SQL Compare. Download.
SQL Snapper is a free utility that creates a SQL Compare schema snapshot of a SQL Server database. This snapshot can then be used as a database source in Red Gate's SQL Compare.
You will find SQL Snapper useful when you have databases deployed at a customer's site, and you need to use SQL Compare to compare the schema of a remote databases with your reference database. If the remote database cannot be accessed from your machine, you can ask your customers to use SQL Snapper to create a SQL Compare snapshot of their database's schema, and send the snapshot file to you. You can then load the snapshot into SQL Compare, and generate the appropriate upgrade script for the customer.
You'll need to download and install SQL Compare to get the latest version, but you don’t need a SQL Compare license to use SQL Snapper. You can find full details in this blog post: https://www.simple-talk.com/blogs/2014/07/21/compare-those-hard-to-reach-servers-with-sql-snapper/.