SQL Source Control

What is SQL Source Control?

Connect your database to your version control system

SQL Source Control has version control schemas and reference data, rolls back changes, and maintains the referential integrity of your database. Solve other database challenges, such as deployment without losing data.

And because it works with the tools you already use, it's an easy setup.

Conecta-se ao SQL Server Management Studio

Versioning your schemas and static data

See who made what changes, when, and why

What's New in SQL Source Control

Melhor suporte Git para Azure Dev Ops / Team Foundation Server Git e Git Hooks

Manage pre- and post-deployment scripts in SQL Source Control to automate SQL changes during deployment

Key Features of SQL Source Control

Automate SQL changes during deployments

Pre- and post-deployment scripts can make SQL changes before and after your deployments. These scripts are managed in SQL Source Control to be selected during deployment with SQL Compare or SQL Change Automation.

Version control at your fingertips within SQL Server Management Studio

It's easy to record and share your code changes, because SQL Source Control runs inside SQL Server Management Studio.

You don't have to stop what you're doing or pass handwritten change scripts.

Versioning your schemas and reference data

Store and share any SQL Server objects and static data. Confirmation and update take two clicks in Object Explorer.

To see what's new, you can check the changes to the individual rows of SQL, with the differences highlighted.

See a complete history of changes

Review the complete revision history of a database or database object.

You can see who made the changes, when they made them, and why.

Handles referential integrity for you

When you commit or upgrade, SQL Source Control maintains the referential integrity of your database for you.

It works in the right order for changes and even handles keys and constraints.

It uses the same engine as SQL Compare, the world's most trusted tool for synchronizing database changes.

Push and pull Git repositories

Synchronize your local and remote Git repositories within Management Studio.

Pull changes from your remote repository, submit your changes locally, and upload them directly to your remote repository to share with the rest of your team.

Revert any changes you don't want

It's simple to revert and resolve conflicts in Object Explorer.

This also offers a risk-free protective box. If you want to experiment in your database, go for it. You can undo changes that you don't want to keep.

Lock the objects you're working on

You can lock the object you're working on in SQL Server Management Studio with just one click, so your changes aren't overwritten.

Your team can see what's blocked, as well as information about who blocked it.

Work in a central database or on your own local copy

You and your team can work on a shared database or use a dedicated local copy.

SQL Source Control supports both models for database development.

Either way, it helps you share code, avoid conflicts, and see who's doing what, so you can work without stepping on each other's toes.

Delete objects with filters

If you don't want to share certain objects, such as users or permissions, you can delete them with filters.

You can delete objects by type, name, and owner, or specify more complex conditions.

It's simple to share just what you want with your team.

See what's changed, with icons

Icons in Object Explorer show when a change has been made to a database by you or your team.

You'll never forget to commit to version control.

Deploy your changes without data loss

Avoid losing data during complex deployments with migration scripts.

You can add these custom SQL scripts to the deployment scripts generated by SQL Compare. They specify how to make the change and ensure that your data remains secure.

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit, and Microsoft Windows Vista 32-bit

Resolution: 1024×768