ApexSQL Source Control

SQL Server source control

Integrate source control with SQL Server database development

?Integrate SQL source control directly into SSMS

?Use dedicated or shared development models

?View conflicts and resolve directly in the UI

?View a detailed history of changes

?Lock objects to prevent overwrites

?Set team policies for check outs and locks

?Apply changes with dependency aware scripts

?Create and apply label from source control

Features

Popular source control systems support

Native and command line support for all the most popular source control systems including Git, Mercurial, Perforce, Subversion, and Team Foundation Server or any source control system which have command line support

Choice of database development models

Support for simultaneous work on dedicated and shared databases

Working folder

Link database to any folder in the file system

Object filtering

Exclude database or repository only objects from source control by schema, type or specific objects

Action center

Work with the latest object changes in real time

Batch operation processing

Perform source control operations on multiple objects simultaneously

Conflict resolution

Merge changes with either a built-in or third-party script diff/merge tools

Checking out and locking objects

Check out and lock objects in order to prevent others from making changes

Change rollback

Undo the latest changes made against selected objects

Historical view

See the complete history of all committed object changes

Static data support

Place your static data under source control for easier tracking of changes

Labels

Create labels and get by label easily

Database development policies

Set source control implementation rules by using policies

Object status

See the current status of objects in a shared database

Change log

Track who made changes, when, and on which objects in a shared database

Offline mode

Ability to work offline for distributed source control systems

System requirements

Hardware requirements

 Dual Core 2.0 GHz CPU

 4 GB memory

 50 MB disk space (depends on the number of linked databases) 

SQL Server

 Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005

 Azure SQL Database, SQL Server on Amazon RDS 

Add-in integration

 SQL Server Management Studio 2016, 2014, 2012, or 2008

OS

 Windows Vista/Server 2003 and above

Required 

Microsoft .NET Framework 3.5 SP1 

Note 

Native support for Git, Mercurial, Subversion, Perforce and Team Foundation Server 

 

 

Compare

Integration

      SQL Server Management Studio 2008 R2 - 2016 ? ?

Cloud

      Azure SQL Database ? 

      SQL Server on Amazon RDS ? 

Database development models

      Dedicated ? ?

      Shared ? ?

Features

      Branching / merging ? ?

      Change log ? ?

      Checking out and locking objects ? ?

      Ignore comparison and synchronization options ? ?

      Migration scripts ? ?

      Object filtering ? ?

      Revision history ? ?

      Static data ? ?

      Working folder ? ?

      Built-in difference merging ? 

      Check out and lock policies ? 

      Database level object status ? 

      Labels ? 

      Object check out ? 

Source control system support

      Git

      Subversion

      Team Foundation Server

      SourceGear Vault

      Mercurial Native CLI

      Perforce

 

 

Roadmap

Associate work item ID with commit

Link the committed changeset with the specified work item ID on TFS

Branching and merging support

Create new Git branch and merge projects from different branches directly from SQL Server Management Studio

SSDT projects support

Work with SQL Server Data Tools (SSDT) projects from SQL Server Management Studio