Bild von SQL Source Control

SQL Source Control

Verknüpfen Sie Ihre Datenbank mit Ihrem Quellcodeverwaltungssystem

SQL Source Control

Während des gesamten Lebenszyklus einer Anwendung unterliegen Datenbanken, genauso wie .NET Code, häufigen und unerwarteten Änderungen. Daher sollten Datenbanken, ebenso wie der Quellcode der übrigen Anwendung, unter Versionskontrolle stehen.

SQL Source Control ist ein Add-In für SQL Server Management Studio und Visual Studio, das Ihre Datenbank mit Ihrem Quellcodeverwaltungssystem verknüpft.

  • Speichern Sie eine vollständige Historie aller Änderungen, so dass Sie jede nicht mehr gewünschte Änderung rückgängigmachen können
  • Versionieren Sie Änderungen am Datenbankschema sowie an statischen Referenzdaten
  • Arbeiten Sie, wie Sie es gewohnt sind, entweder an einer zentralen (gemeinsamen) Datenbank oder Ihrer eigenen lokalen Version

SQL Source Control is an add-in for SQL Server Management Studio that links your database to your source control system.

Because it works with tools you already use, there’s no lengthy setup, yet it gives you the ability to source control schemas and reference data, roll back changes, and maintain the referential integrity of your database.

And it helps you solve other database challenges, like deploying without losing data.

SQL Source Control works with

  • Team Foundation Server
  • Subversion
  • Git
  • Vault
  • Mercurial
  • Perforce

or any source control system with a command line

Key features of SQL Source Control

Source control at your fingertips inside 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 round handwritten change scripts.

Source control your schemas and reference data

Store and share any SQL Server object and static data. Committing and updating takes two clicks in the Object Explorer.

To see what’s new, you can check changes down to the individual lines of SQL, with highlighted differences.

Roll back any changes you don't want

It’s simple to roll back and resolve conflicts from the Object Explorer.

This also gives you a risk-free sandbox. If you want to experiment on your database, go ahead. You can undo any changes you don't want to keep.

Handles referential integrity for you

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

It works out the right order for your changes and even deals with keys and constraints.

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

Work on a central database or your own local copy

You and your team can work on a shared database or each use a local, dedicated 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 treading on each other’s toes.

Exclude objects with filters

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

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

It’s simple to share only what you want with your team.