SQL Developer Suite

Speed up and simplify SQL Server development

Download 14-day free trial

The SQL Developer Suite makes SQL Server development efficient and ensures database changes are safe.

It includes SQL Source Control, SQL Prompt, and SQL Compare Pro – the industry-standard SQL Server comparison tool used by 71% of the Fortune 100.

You get everything you need to speed up coding, set up simple change management, and take your first steps in Database Lifecycle Management. Try it today, free.

Download 14-day free trial

Pricing information

$1,795
per user

Buy now

How the SQL Developer Suite helps you work with SQL Server

Compare and deploy database schemas and contents

Compare and deploy database schemas and contents

Make change management simple – compare and deploy schemas and data with a few clicks, or generate SQL scripts to bring them in line, with SQL Compare Pro and SQL Data Compare Pro.

  • Save time syncing databases: set up comparisons in seconds, check the differences, and specify the changes you want to sync.
  • Eliminate mistakes in deployment: automatically create accurate scripts for deploying database updates by hand.
  • Prepare your database for automation: with your database in source control, you can set up CI and release management, allowing automated deployments, using SQL Source Control and the DLM Automation Suite.

Compare from backups or deploy from source control

Deploy from source control or backups

Roll out database changes from your backups or from source control, the single source of truth for database changes, using SQL Compare Pro and SQL Data Compare Pro.

  • Deploy from source control: update databases straight from your source control system using SQL Source Control, also included in the SQL Developer Suite.
  • Sync from backups and script files: use native backup files, SQL Backup Pro files, or SQL scripts as the source for your database changes.
Code SQL effortlessly

Code SQL effortlessly

Write SQL fast with keyword completion, customizable snippets, and suggestions for completing INSERT, ALTER, and JOIN statements, from SQL Prompt.

  • Code-completion: get keyword and object suggestions as you type, along with appropriate conditions for completing INSERTs, ALTERs, and JOINs.
  • SQL snippets: code as fast as possible and add your own favorite fragments to the list.
  • Tab history: save, search, and recover your query tabs in SQL Server Management Studio.

Keep code readable

Keep code readable

Make inherited code readable and help your team work to a single standard, with SQL Prompt's one-click, customizable code reformatting.

  • Code reformatting: reformat any query to your preferred layout at the click of a button.
  • Script summaries: get a summary of the actions any script performs, together with their order.
  • Customizable formatting: set the reformatting style that SQL Prompt uses to match the conventions you and your team prefer.

Hassle-free database documentation

Cut out repetitive work, keep your teams up to date, and pass audits with complete database documentation, generated automatically by SQL Doc.

  • Get instant documentation: generate full database documentation, including object definitions and details about dependencies, with a few clicks.
  • Use your favorite format: work with .html, .chm, or Microsoft Word files.
Database source control within SSMS

Database source control in SQL Server Management Studio

Make teamwork simple, set up a single source of truth for database development, and take your first steps in Database Lifecycle Management with SQL Source Control.

  • Source control that fits your workflow: SQL Source Control works inside SQL Server Management Studio, so you can access source control without leaving your IDE.
  • Keep your database up-to-date with two clicks: get the latest updates from source control and share your own changes straight from the Object Explorer.
  • Works with your source control system: plug your database code into Team Foundation Server, Subversion, Git, Vault, Mercurial, Perforce, or any other source control system.

Track database changes and see who changed what, when, and why

Track database changes and see who changed what, when, and why

SQL Source Control gives you a complete record of database changes, making it simple to track, manage, or revert them.

  • Simple, safe change management: check commit comments and view SQL changes at the line level before accepting an update.
  • Risk-free experimenting: try out changes on your local version – if you don't want to keep them, you can revert with a few clicks.

Write and run unit tests quickly and simply

Catch bugs early with unit tests

Discover defects when they're cheap to fix and lay the foundations for continuous integration with SQL Test.

  • Write tests in familiar T-SQL: write your tests in SQL Server Management Studio and run them with a single click.
  • Share tests with colleagues: check your tests into source control alongside your code, for easy sharing with your team.

Rapidly generate fully-customizable test data

Rapidly generate fully-customizable test data

Create realistic, fully-customizable test data in a flash, with SQL Data Generator. Boost your database testing process and demo databases without sharing private data.

  • Future-proof your databases: test your databases with large quantities of realistic data and make certain they'll stand the rigors of a production environment.
  • Comply with privacy legislation: generate realistic demo data and show your customers how your applications perform without sharing sensitive information.

Eliminate invalid objects

Keep your databases tidy and reliable, with a full list of invalid objects, including details of the problem, from SQL Prompt.

  • Catch every invalid object: SQL Prompt checks your whole database, lists the reasons for the problem, and gives you the object’s name and type, so you can find and fix things fast.
  • Check your fix worked with just one click: to double-check your fix worked, just refresh the find invalid objects list.

Find and fix errors caused by database differences

Pinpoint differences between databases with a few clicks and bring them in line, with SQL Compare Pro.

  • Catch every database difference: SQL Compare Pro finds each difference in database structure and highlights those lines of SQL, so you can quickly isolate errors.
  • Bring databases in line fast: generate a SQL script to fix errors with a few clicks, or apply changes straight from the UI.

Restore damaged or missing data, right down to a single row

Take the stress out of database repairs by syncing your lookup data at the row level, using SQL Data Compare Pro.

  • Work at the row level: sync data at whatever level you need – table, column, or row.
  • Quickly generate fix scripts: create scripts to bring your data back in line or work from the UI.

Take your next steps with the DLM Automation Suite

With source control and manual deployments in place, you have everything you need to set up the next steps in Database Lifecycle Management: continuous integration and release management.

The DLM Automation Suite gives you tooling for database CI and automated deployments, plus the monitoring tools you need to make sure your process is safe and reliable.

The Suite works with the CI and release management tools you already use. Setup is simple, you get more from your existing infrastructure, and you can use one consistent process for application and database development.

Find out how you can make your database development even more efficient on the DLM Automation Suite pages.

Start free with DLM Dashboard

DLM Dashboard tracks database drift – unexpected changes to your schema – and shows you who made these changes and when. It comes with the DLM Automation Suite and in a free community edition.

Get the free version today to see the schema state of your database environments and make final safety checks before deploying to Production with tools in the SQL Developer Suite, such as SQL Compare and SQL Source Control.

Download DLM Dashboard free

Includes 8 tools for development, source control, and change management

SQL Source Control

Connect your databases to your source control system

SQL Compare Pro

Compare and synchronize database schemas

SQL Data Compare Pro

Compare and synchronize database contents

SQL Prompt

Write, format, and refactor SQL effortlessly

SQL Search

Search your database quickly in SQL Server Management Studio

SQL Data Generator

Generate realistic test data fast, based on column and table names

SQL Doc

Automatically generate database documentation

SQL Test

Write and run unit tests in SQL Server Management Studio

What our customers are saying

Resources

Improving database development

An overview of how the tools in the SQL Developer Suite can be used together to address the problems of database development

Read the whitepaper (PDF)


Compliance: what it means for databases

A brief overview of the impact regulatory compliance, such as SOX, HIPAA, or SAS70, has on database development and administration.

Read the whitepaper (PDF)

“Last week, I think we deployed about 30 times. It's no longer painful.” - Rob Richardson, Consultant, StateServ Healthcare

Learn how StateServ use Redgate tools to halve release times, speed up patient data storage, and improve database delivery.

Read the case study (PDF)


“In the last two years we haven't had any bugs related to database objects at all.” - Michael Stoop, Database Developer, Calvi

Find out how Calvi, Europe's leading provider of telecom invoice management software, has avoided database-related bugs for the last two years.

Read the case study (PDF)