News  
  By label  
  By team  
  By product  

ApexSQL Blog

Product announcements, promotions and other ApexSQL news


ApexSQL Diff has gone PRO: the scouting report


In order to meet the customer needs across environments and price ranges, ApexSQL decided to release two versions of ApexSQL Diff – ApexSQL Diff Professional and ApexSQL Diff Developer

The ApexSQL Diff Developer version will be a lite version of the tool, tailored to meet the demands of the users who do not need the full set of features which will be available in ApexSQL Diff Professional



Please note:
Customers under valid subscription for ApexSQL Diff will automatically be upgraded to the Professional version


The most prominent features that will be available only in ApexSQL Diff Professional are:

Comparing and synchronizing native or natively compressed database backups
Comparing and synchronizing script folders
Comparing and synchronizing directly from source control
Command Line Interface (CLI) support
Augmenting the deployment script with pre or post synchronization scripts



Let us take a quick look at each feature 

Compare and synchronize native or natively compressed database backups

This feature allows to compare and synchronize supported data source directly to a native or natively compressed backup file, as well to perform object level schema recovery without the need for a full backup restore. ApexSQL Diff Professional engine will only the part of the backup file containing schema information, which is in general only small part of the file itself; in turn resulting in fast comparisons and object recoveries even from backups measuring tens or hundreds of gigabytes



Compare and synchronize script folders

This feature provides the ability to compare and synchronize file system folders containing SQL objects’ scripts. In other words, it allows updating the SQL scripts to match the live objects or quickly deploying the object’s scripts to a live database


Compare and synchronize directly from source control

This feature significantly simplifies integrating SQL databases with version control. It provides a quick way to get even the largest databases containing tens of thousands of objects with, what is essentially, a single check-in. On the other hand, it allows risk-free deployments of a new database build directly from source control, as ApexSQL Diff Professional will ensure that the no dependency will be left behind and that the updates will be executed in the proper dependency order. In addition, it allows synchronizing live objects with a specific revision of their versioned scripts 


Command Line Interface (CLI) support

The CLI allows complete automation of the comparison and synchronization process. Promoting changes from the development, to the test, integration and even production environments can be scheduled and performed error-free completely unattended


Augmenting the deployment script with pre or post synchronization scripts

This feature allows integrating customs scripts in the synchronization process thus allowing SQL scripts that will prepare the target database to be executed prior to the synchronization, or the database maintenance scripts to be executed post synchronization automatically

The full list of features for ApexSQL Diff Developer and ApexSQL Diff Professional as well as their differences are listed below:


Pricing will be made available soon
All existing customers have an ApexSQL Diff Pro license



Author Nikola Dimitrijevic

Labels: , ,