|
2017
|
|
Jun 21
|
ApexSQL Compare
|
2017
|
File and folder comparison. Compare SQL Server objects directly from SQL Server Management Studio and Visual Studio. Two-way compare and merge. Full support for Command line interface. Three comparison modes: Character, Line, Block. Syntax highlighting for 9 languages: C#, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML. Ignore script options: Ansi options, Authorization, Collation, Comments, Constraint names, Filegroups, Indexes, Lock escalation, Permissions, With encryption. Support for SQL Server Management Studio 2012 integration and higher. Support for Visual Studio 2010 integration and higher. Support for Windows Explorer integration. Support for Azure SQL Database. Support for SQL Server on Amazon RDS. Exporting comparison results into HTML
|
Developer
|
|
|
Jun 20
|
ApexSQL Propagate
|
2017 R2
|
Usability improvements. Improved quality
|
DBA
|
|
|
Jun 19
|
ApexSQL Doc
|
2016 R4
|
Support for Tableau server (HTML, CHM). 8 new CLI switches. Usability improvements. Improved quality
|
Developer
|
|
|
Jun 19
|
ApexSQL Search
|
2016 R6
|
Usability improvements. Improved quality
|
Developer
|
|
|
Jun 14
|
ApexSQL Audit
|
2017 R3
|
Usability improvements. Improved quality
|
DBA
|
|
|
Jun 07
|
ApexSQL Complete
|
2017 R7
|
Export result grid data to Excel. CRUD procedures. Execution alerts. Usability improvements. Improved quality
|
Developer
|
|
|
Jun 07
|
ApexSQL Diff
|
2017 R3
|
Support for SQL Server Management Studio 17 integration. Include new objects in the synchronization process switch [/sno]. Usability improvements. Improved quality
|
Developer
|
|
|
Jun 07
|
ApexSQL Plan
|
2017
|
Support for SQL Server Management Studio 2012 integration and higher. Data flow line thickness. Layouts panel. Live query plans. Manipulation with the query plan graphical elements. Query execution plans. Customized data flow properties. Customized operation properties. Operation cost highlight. Join diagram. Line level statements analysis. Query plan XML viewer. Show missing index details. Table I/O. Expressions. Parameters. Plan tree and top operations. Query columns. Wait stats. Deadlock analysis. Multiple query tabs. History and comments. Query performance. Query store. GUI themes
|
DBA
|
|
|
Jun 06
|
ApexSQL Data Diff
|
2016 R5
|
SQL Server 2017 CTP 2 support. SQL Server Management Studio 17 integration. Usability improvements. Improved quality
|
Developer
|
|
|
Jun 05
|
ApexSQL Monitor
|
2017 R2
|
Usability improvements. Improved quality
|
DBA
|
|
|
Jun 01
|
ApexSQL Trigger
|
2017 R2
|
Support for SQL Server on Amazon RDS. Usability improvements. Improved quality
|
Developer
|
|
|
May 25
|
ApexSQL Unit Test
|
2016 R5
|
SQL Server 2017 CTP 2 support. SQL Server Management Studio 17 integration
|
Developer
|
|
|
May 24
|
ApexSQL Log
|
2017
|
SQL Server 2017 CTP 2 support. Usability improvements. Improved quality
|
DBA
|
|
|
May 23
|
ApexSQL Defrag
|
2017 R3
|
SQL Server 2017 CTP 2 support. Limited, sampled and detailed index scanning modes. Fast and deep index analysis. Cancel pending jobs. Predefined policies and policy templates. Separate section for alerts. Filter, group and export alerts. Filter activities. Usability improvements. Improved quality
|
DBA
|
|
|
May 22
|
ApexSQL Search
|
2016 R5
|
SQL Server 2017 CTP 2 support. Improved quality
|
Developer
|
|
|
May 18
|
ApexSQL Generate
|
2016 R6
|
SQL Server Management Studio 17 integration. Usability improvements. Improved quality
|
Developer
|
|
|
May 18
|
ApexSQL Recover
|
2017
|
SQL Server 2017 CTP 2 support. Usability improvements. Improved quality
|
DBA
|
|
|
May 17
|
ApexSQL Restore
|
2017
|
SQL Server 2017 CTP 2 support. Usability improvements. Improved quality
|
DBA
|
|
|
May 16
|
ApexSQL Source Control
|
2017 R4
|
Associate work item ID with changeset on TFS. TFS check-in policy. Create new branch. Merge projects. Usability improvements. Improved quality
|
Developer
|
|
|
May 15
|
ApexSQL Doc
|
2017 R3
|
Snapshot database schema (Word, PDF). Support for Tableau server (Word, PDF). Usability improvements. Improved quality
|
Developer
|
|
|
May 15
|
ApexSQL Build
|
2017
|
Support for SQL Server on Amazon RDS. Azure SQL Database V12 "full" support (all new features). Support for C# solution for Visual Studio 2015 and 2017. GUI themes. Export data source. Save as batch. Usability improvements. Improved quality
|
Developer
|
|
|
May 08
|
ApexSQL Refactor
|
2017 R2
|
Usability improvements. Improved quality
|
Developer
|
|
|
May 04
|
ApexSQL Audit
|
2017 R2
|
Usability improvements. Improved quality
|
DBA
|
|
|
Apr 20
|
ApexSQL Audit
|
2017
|
Complete UI redesign. Reporting application. SQL Server 2017 CTP 2 support. Automatic auditing instance deployment. Before after data encryption. Predefined reports for compliance standards. Filter configuration templates. Saving configuration to file system. E-mail recipient list. Import/export alert rules. Usability improvements. Improved quality
|
DBA
|
|
|
Apr 18
|
ApexSQL Doc
|
2017 R2
|
SQL Server vNext CTP1 support. Support for SQL Server Management Studio 17 integration. Snapshot database schema (HTML, CHM). Usability improvements. Improved quality
|
Developer
|
|
|
Apr 13
|
ApexSQL Complete
|
2017 R6
|
Usability improvements. Improved quality
|
Developer
|
|
|
Apr 12
|
ApexSQL Monitor
|
2017
|
Full web version. Custom reports. SQL Server vNext CTP1 support. Improved performance. Usability improvements. Improved quality
|
DBA
|
|
|
Apr 10
|
ApexSQL Defrag
|
2017 R2
|
SQL Server vNext CTP1 support. Online rebuild of indexes. Usability improvements. Improved quality
|
DBA
|
|
|
Mar 30
|
ApexSQL Source Control
|
2017 R3
|
Support for Visual Studio Team Services Git repositories. Improved built-in merge/diff tool. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 27
|
ApexSQL Refactor
|
2017
|
SQL Server vNext CTP1 support. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 23
|
ApexSQL Trigger
|
2017
|
Repository database for storing the auditing architecture and data. 5 new CLI switches. 20 new return error codes. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 23
|
ApexSQL Decrypt
|
2017 R2
|
SQL Server Management Studio 17 integration. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 21
|
ApexSQL Generate
|
2016 R5
|
3 new CLI switches. The "Fill only empty tables" option in the Options tab. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 16
|
ApexSQL CI/CD toolkit
|
2017
|
PowerShell cmdlets. PowerShell integration to Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Visual Studio Team Services, Team Foundation Server, and any other CI server with PowerShell support. Check for invalid objects. Build a database directly from source control. Include static data in builds. Generate synthetic test data. Run SQL unit tests. Synchronize target database with source control. Automatically create rollback scripts. Document and report on changes. Create deployment package. Archive all output files in a central folder. Audit sensitive tables with DML triggers. Open sourced PowerShell code downloadable from GitHub. Customizable data sources. Support for advanced configuration through individual step project files
|
Developer
|
|
|
Mar 15
|
ApexSQL Diff
|
2017 R2
|
4 new CLI switches. New values for the output type switches: SQL compare results and database. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 15
|
ApexSQL Data Diff
|
2016 R4
|
4 new CLI switches. No differences detected return error code. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 14
|
ApexSQL Backup
|
2017 R3
|
Usability improvements. Improved quality
|
DBA
|
|
|
Mar 09
|
ApexSQL Build
|
2016 R2
|
45 new CLI switches that cover all GUI functionalities. 17 new return error codes. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 06
|
ApexSQL Refactor
|
2016 R7
|
Usability improvements. Improved quality
|
Developer
|
|
|
Feb 28
|
ApexSQL Doc
|
2017
|
GUI themes. Usability improvements. Improved quality
|
Developer
|
|
|
Feb 27
|
ApexSQL Unit Test
|
2016 R4
|
Usability improvements. Improved quality
|
Developer
|
|
|
Feb 22
|
ApexSQL Diff
|
2017
|
SQL Server Integration Services package comparison. Ignore lock escalation property of tables. Create snapshot of destination database before synchronization. Create rollback script for destination database before synchronization. Create script folder backup for destination script folder or source control before synchronization. XML export customization options. Export schema comparison differences to SQL and database. Script difference panel options. 26 new CLI switches. No differences detected return error code. Usability improvements. Improved quality
|
Developer
|
|
|
Feb 07
|
ApexSQL Source Control
|
2017 R2
|
SQL Server vNext CTP1 support. Usability improvements. Improved quality
|
Developer
|
|
|
Feb 01
|
ApexSQL Complete
|
2017 R5
|
Support for temporal tables in SQL Server 2016. Usability improvements. Improved quality
|
Developer
|
|
|
2016
|
|
Dec 29
|
ApexSQL Backup
|
2017 R2
|
SQL Server vNext CTP1 support. Usability improvements. Improved quality
|
DBA
|
|
|
Dec 28
|
ApexSQL Source Control
|
2017
|
Support for SQL Server Management Studio 17 integration. Improved shared database development model. Global object filtering settings. Manage number of changesets to be shown in History form. Manage number of labels to be shown in Labels form. Usability improvements. Improved quality
|
Developer
|
|
|
Dec 26
|
ApexSQL Complete
|
2017 R4
|
Tabs coloring. Search result grid. Usability improvements. Improved quality
|
Developer
|
|
|
Dec 15
|
ApexSQL Unit Test
|
2016 R3
|
Export test results as SQL script. Export test results to a database table. Customizable success thresholds. Usability improvements. Improved quality
|
Developer
|
|
|
Dec 14
|
ApexSQL Refactor
|
2016 R6
|
Visual Studio 2017 RC integration. SQL Server Management Studio 17 integration
|
Developer
|
|
|
Dec 13
|
ApexSQL Propagate
|
2017
|
Execute SQL scripts on multiple servers and databases. Parse SQL scripts for errors before execution. Edit scripts within the application. Manage database and SQL script lists. Export to plain text and CSV. GUI themes
|
DBA
|
|
|
Dec 12
|
ApexSQL Search
|
2016 R4
|
Visual Studio 2017 RC integration. SQL Server Management Studio 17 integration
|
Developer
|
|
|
Dec 07
|
ApexSQL Complete
|
2017 R3
|
Visual Studio 2017 RC integration. SQL Server vNext CTP1 support. SQL Server Management Studio 17 integration
|
Developer
|
|
|
Dec 01
|
ApexSQL Defrag
|
2017
|
Improved icons. Added icon overlays in server explorer to highlight fragmentation issues. Added options to select/deselect all indexes and toggle display with low, medium, or high fragmentation. Added options to set fragmentation levels and colors. Improved policy wizard. Improved charts. Usability improvements. Improved quality
|
DBA
|
|
|
Nov 21
|
ApexSQL Decrypt
|
2017
|
Decrypt SQL objects from multiple SQL Servers. Decrypt SQL Server objects directly from SQL Server Management Studio. Generate ALTER or CREATE SQL scripts. Generate composite or one SQL script per object. Backup a database before decryption. Preview original DDL script of encrypted objects. Preview action plan of the decryption SQL script. Filter encrypted SQL objects. GUI themes
|
Developer
|
|
|
Nov 08
|
ApexSQL Complete
|
2017 R2
|
Improved quality
|
Developer
|
|
|
Nov 07
|
ApexSQL Backup
|
2017
|
Backup statistics and charting. Charts for backup file disk usage. Charts for backup duration. Database compression charts. Charts for succeeded/failed jobs. Backup history charts. Specify the time range for each chart. Usability improvements. Improved quality
|
DBA
|
|
|
Oct 31
|
ApexSQL Unit Test
|
2016 R2
|
Create demo kit with "PUBS QA" sample database and 15 predefined unit tests. GUI theme integration with SSMS. Multi-selection of unit tests. Export tests execution results to XML. Added CLI switches for installing tSQLt framework and SQLCOP tests. Usability improvements. Improved quality
|
Developer
|
|
|
Oct 27
|
ApexSQL Doc
|
2016 R5
|
Document SSAS 2016 Tabular model written in TMSL. Save project as batch file. Usability improvements. Improved quality
|
Developer
|
|
|
Oct 24
|
ApexSQL Trigger
|
2016 R3
|
Usability improvements. Improved quality
|
Developer
|
|
|
Oct 20
|
ApexSQL Complete
|
2017
|
Visual Studio 2015 integration. Resume work. Close unmodified tabs. Copy result grid data as INSERT INTO. Copy result grid data as IN clause. Usability improvements. Improved quality
|
Developer
|
|
|
Oct 17
|
ApexSQL Search
|
2016 R3
|
Improved quality
|
Developer
|
|
|
Oct 13
|
ApexSQL Refactor
|
2016 R5
|
Improved quality
|
Developer
|
|
|
Oct 11
|
ApexSQL Data Diff
|
2016 R3
|
Support for SQL Server on Amazon RDS. Support for SQL Server Management Studio 2016 integration. Support for Source control data source. Schema mapping switch. Logging level switch. Sound playing switch upon finished operation. Improved HTML reports. Usability improvements. Improved quality
|
Developer
|
|
|
Sep 29
|
ApexSQL Defrag
|
2016
|
Detailed real-time index analysis. Rebuild and reorganize indexes. Centralized index maintenance job management. Create and manage index maintenance policies across multiple servers. Schedule index maintenance jobs. Index fragmentation reports. Export the reports to PDF, image or HTML
|
DBA
|
|
|
Sep 27
|
ApexSQL Monitor
|
2016 R3
|
A new dark color interface theme is now available. Usability improvements. Improved quality
|
DBA
|
|
|
Sep 22
|
ApexSQL Source Control
|
2016 R4
|
Support for SQL Server on Amazon RDS. New Script options: Ignore comparison options, Synchronization options, and Manage owners options. Improved Import connections feature: New Connections tab in the Options window, New pane for choosing databases that will be linked. Usability improvements. Improved quality
|
Developer
|
|
|
Sep 15
|
ApexSQL Doc
|
2016 R4
|
Export CLI help as HTML. Warnings handling switch. 15 new return error codes. Usability improvements. Improved quality
|
Developer
|
|
|
Sep 05
|
ApexSQL Recover
|
2016 R2
|
Improved quality
|
DBA
|
|
|
Sep 05
|
ApexSQL Log
|
2016 R3
|
Usability improvements. Improved quality
|
DBA
|
|
|
Aug 19
|
ApexSQL Search
|
2016 R2
|
Visual Studio 2015 integration. Visual Studio 15 integration
|
Developer
|
|
|
Aug 19
|
ApexSQL Refactor
|
2016 R4
|
Visual Studio 2015 integration. Visual Studio 15 integration
|
Developer
|
|
|
Aug 15
|
ApexSQL Monitor
|
2016 R2
|
Full support for AlwaysOn availability groups monitoring with graphical presentation of all WSFC nodes and AG replicas including the relations. Index monitoring including the index metrics and graphical presentation. Stricter alerting engine ensures triggering only alerts that complies with user defined alert period. Alert management with ability to resolve individual alerts, insert comments and reporting on active and resolved alerts. Query performance and query waits alerting. Query performance history. Individual query history. SNMP notifications on alerts. Improved functionality of custom metrics. Improved performance. Usability improvements. Improved quality
|
DBA
|
|
|
Aug 10
|
ApexSQL Unit Test
|
2016
|
Create and run unit tests based on tSQLt framework on any database. Easily maintain all unit tests in a single window. Follow tests results in output window
|
Developer
|
|
|
Aug 01
|
ApexSQL Doc
|
2016 R3
|
SQL Server Management Studio 2016 integration. SSRS report documentation. Document SSIS packages from SSISDB catalog. SSIS package details: Project parameters, Log entry information, Extended properties, Configuration settings. SSIS source and destination mapping. Dependencies between SSIS packages and referenced database objects. Usability improvements. Improved quality
|
Developer
|
|
|
Jul 19
|
ApexSQL Diff
|
2016 R2
|
SQL Server on Amazon RDS support. SQL Server Management Studio 2016 integration. Save project as batch file. Help to HTML switch. 17 new return error codes. Return error codes switch. Package options switches. Warnings handling switch. Silent switch. Ignore new objects switch. Ignore invalid objects switch. Improved CLI output messages: Comparison summary, Warnings output, Synchronization summary, Changes output. Usability improvements. Improved quality
|
Developer
|
|
|
Jul 15
|
ApexSQL Trigger
|
2016 R2
|
GUI themes. Usability improvements. Improved quality
|
Developer
|
|
|
Jul 14
|
ApexSQL Generate
|
2016 R4
|
SQL Server Management Studio 2016 integration. 20+ new predefined generators. Export CLI help as HTML. 20 new return error codes. Return error codes switch. Silent switch. Unique switch, Shuffle switch, Allow null switch, Include/Exclude switches. Improved output messages in the CLI: Generation summary, Warnings output, Preview with objects to process. Usability improvements. Improved quality
|
Developer
|
|
|
Jul 11
|
ApexSQL Restore
|
2016
|
SQL Server 2016 support. GUI themes. Usability improvements. Improved quality
|
DBA
|
|
|
Jul 05
|
ApexSQL Backup
|
2016 R2
|
SQL Server 2016 support. GUI themes. Optimized wizards. Multiple backup templates can be deployed at once. Point in time restore is improved and simplified. More complex filters and grouping are now supported by Activities, Schedules and History grids. Multiple schedules can be managed at once. Supported jobs enable\disable. Network resilience. Backup to Azure. Run a script after a restore. Implemented ApexSQL Backup Agent Updater. Usability improvements. Improved quality
|
DBA
|
|
|
Jun 30
|
ApexSQL Recover
|
2016
|
SQL Server 2016 support. GUI themes. Usability improvements. Improved quality
|
DBA
|
|
|
Jun 13
|
ApexSQL Audit
|
2016 R3
|
Improved performance. Improved quality
|
DBA
|
|
|
Jun 10
|
ApexSQL Complete
|
2016 R3
|
SQL Server 2016 support. SQL Server Management Studio 2016 integration. Improved quality
|
Developer
|
|
|
Jun 07
|
ApexSQL Source Control
|
2016 R3
|
SQL Server 2016 support. SQL Server Management Studio 2016 integration. Usability improvements. Improved quality
|
Developer
|
|
|
Jun 06
|
ApexSQL Generate
|
2016 R3
|
SQL Server 2016 support. Improved quality
|
Developer
|
|
|
Jun 06
|
ApexSQL Refactor
|
2016 R3
|
SQL Server 2016 support. SQL Server Management Studio 2016 integration. Improved quality
|
Developer
|
|
|
Jun 03
|
ApexSQL Search
|
2016
|
SQL Server 2016 support. SQL Server Management Studio 2016 integration. Improved quality
|
Developer
|
|
|
Jun 02
|
ApexSQL Log
|
2016 R2
|
SQL Server 2016 support. GUI themes. Usability improvements. Improved quality
|
DBA
|
|
|
May 25
|
ApexSQL Data Diff
|
2016 R2
|
SQL Server 2016 support. Azure SQL Database V12 "full" support (all new features). Schema mapping feature. Save project as batch file. Export CLI help as HTML. 17 new return error codes. Return error codes switch. Package options switches. Warnings handling switch. Ignore new objects switch. Silent switch. Improved output messages in the CLI: Comparison summary, Warnings output, Synchronization summary, Changes output. Improved HTML reports. Usability improvements. Improved quality
|
Developer
|
|
|
May 19
|
ApexSQL Trigger
|
2016
|
SQL Server 2016 support. Azure SQL Database V12 "full" support (all new features). Save project as batch file. Usability improvements. Improved quality
|
Developer
|
|
|
May 18
|
ApexSQL Clean
|
2016
|
SQL Server 2016 support. Azure SQL Database V12 "full" support (all new features). SQL Server on Amazon RDS support. Save project as a batch file. Usability improvements. Improved quality
|
Developer
|
|
|
May 10
|
ApexSQL Script
|
2016
|
SQL Server 2016 support. Azure SQL Database V12 "full" support (all new features). Save project as a batch file option. C# solution support for Visual Studio 2015. Options for setting the compatibility mode of the scripted database. Additional switches for committing to Source controls. Additional switches for setting the compatibility mode. Usability improvements. Improved quality
|
Developer
|
|
|
Apr 27
|
ApexSQL Source Control
|
2016 R2
|
Migration scripts support. Basic Git branching support. Usability improvements. Improved quality
|
Developer
|
|
|
Apr 19
|
ApexSQL Doc
|
2016 R2
|
SQL Server 2016 RC3 support. Azure SQL Database V12 "full" support (all new features). SQL Server on Amazon RDS support. Data model diagrams. SSAS cube documentation. Usability improvements. Improved quality
|
Developer
|
|
|
Apr 08
|
ApexSQL Audit
|
2016 R2
|
Improved performance. Usability improvements. Improved quality
|
DBA
|
|
|
Apr 01
|
ApexSQL Complete
|
2016 R2
|
SQL Server 2016 RC2 support. Improved performance. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 23
|
ApexSQL Diff
|
2016
|
SQL Server 2016 RC1 support. SQL Server Management Studio 2016 RC1 integration. Azure SQL Database V12 "full" support (all new features). Improved print reports. New export types: Excel and HTML structure reports for source and destination data sources. New output types: C# solution and executable installer. Ignore object selection specified in the project file for CLI. Ignore parsing errors for CLI. Usability improvements. Improved quality
|
Developer
|
|
|
Mar 21
|
ApexSQL Audit
|
2016
|
Before-after auditing is now CLR trigger based. Reports can now use multiple data sources simultaneously. Advanced application status with detail info about central and auditing instances. CLI for exporting reports to all of supported file formats. Application now supports alerts logging into Windows Event Log. SQL Server 2016 CTP3 support for before-after auditing is added. Usability improvements. Improved quality
|
DBA
|
|
|
Feb 26
|
ApexSQL Generate
|
2016 R2
|
Import database structure from SQL creation script. Merge SQL creation script with SQL static data script. Export to JSON format. Export to Excel format. Preview export results. 25 new predefined generators were added. IronPython generator. Manual Foreign key generator. Weighted list: Nested. Weighted list: Regular expression. Weighted list: Ranged. Check constraint violation warnings. Graphical dependency viewer. Usability improvements. Improved quality
|
Developer
|
|
|
Feb 11
|
ApexSQL Refactor
|
2016 R2
|
Code formatting impact preview has been improved. Usability improvements. Improved quality
|
Developer
|
|
|
Jan 15
|
ApexSQL Complete
|
2016
|
SQL Server 2016 CTP3 support. SQL Server Management Studio 2016 CTP3 integration. Usability improvements. Improved quality
|
Developer
|
|
