ApexSQL Database Power Tools for VS Code 2020 has been released
About ApexSQL Database Power Tools for VS Code: ApexSQL Database Power Tools for VS Code is an extension for Visual Studio Code which allows users to connect to MySQL and MariaDB instances, run queries and display results, export query results into several standard formats, generate DDL and DML scripts from object explorer on existing platforms like Windows, Linux, macOS.
May 7, 2020
ApexSQL Mask 2020 has been released
About ApexSQL Mask: ApexSQL Mask is a tool that can automatically classify and mask sensitive SQL Server data. It has 55+ built in data classification filters and more than 220 predefined data masks. The tool can mask data at column and/or row level with automatic sensitive data classification and it can be run directly from command line interface.
April 30, 2020
ApexSQL Defrag 2019 R2 has been released
About ApexSQL Defrag: ApexSQL Defrag is an enterprise SQL Server tool used for analyzing, monitoring and managing SQL Server index fragmentation. The application allows detailed index fragmentation analysis on server, database and table level. With ApexSQL Defrag you can rebuild or reorganize fragmented indexes in real time, as well as create policies and apply them to multiple databases or servers.
April 29, 2020
ApexSQL Audit 2020 has been released
About ApexSQL Audit: ApexSQL Audit is a SQL Server auditing and compliance tool with a wide range of features for auditing access, changes, and security on SQL Server instances, databases, and objects. It audits queries, DDL and DML operations, security events (authentication changes, permissions changes, and attempted logins), events on stored procedures and functions, and provides out-of-the-box compliance templates such as HIPAA, GDPR, PCI. ApexSQL Audit saves captured information in a centralized auditing repository and provides comprehensive reports.
April 29, 2020
ApexSQL DevOps toolkit 2020 R2 has been released
About ApexSQL DevOps toolkit: ApexSQL DevOps toolkit is a set of open-source PowerShell cmdlets for automating workflow pipelines to integrate database changes, test and deliver to production. It supports integration with Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Hudson, Visual Studio Team Services, Team Foundation Server, and other CI/CD servers. It contains predefined Continuous Integration (CI) and Continuous Delivery (CD) PowerShell script templates for standalone use where all pipeline steps can be customized, reordered, added and removed. It also contains a native TeamCity, a native Atlassian Bamboo, a native Jenkins continuous integration server, a native Azure DevOps Server (TFS) / Azure DevOps Services plugin and a standalone Web dashboard for configuration and execution of CI and CD workflow pipelines via point and click graphical interface.
April 23, 2020
We are proud to announce that ApexSQL Doc for MySQL is released. The new MySQL database documentation tool gives database developers the possibility to document multiple MySQL databases at the same time as well as the possibility of choosing which database options and database objects should be included in the documentation.
April 22, 2020
ApexSQL Pump 2020 R2 has been released
About ApexSQL Pump: ApexSQL Pump is a tool that can import and export data from SQL Server database to 13+ commonly used data formats (CSV, Excel, Word, XML, JSON, etc.) and it can be used to migrate data between systems. The tool allows users to configure data export by offering many options that can be saved as a template. The import and export process can be run directly from command-line interface.
April 16, 2020
ApexSQL Manage 2020 R2 has been released
About ApexSQL Manage: ApexSQL Manage is an enterprise SQL Server tool used to discover SQL Server instances on the network and provide a high-level analysis of configuration. ApexSQL Manage enforces best practices by reviewing and detecting issues on discovered instances and can compare SQL Server instances and snapshots, as well as to create detailed documentation at the server level in Word, PDF, HTML and CHM file formats. Additionally, the application allows the creation of SQL Server instance snapshots, active SQL Server login management on multiple instances and executes SQL scripts to fix failed health check results.
April 15, 2020
ApexSQL Data Diff 2019 R2 has been released
About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool that detects data differences and resolves them without errors. It compares and synchronizes live databases, database backups, and data under source control. ApexSQL Data Diff integrates with SQL Server Management Studio and has a command line interface, to allow for unattended execution.
April 8, 2020
We are proud to announce the first extension for Visual Studio Code from the ApexSQL family: ApexSQL Database Power Tools for VS Code. This extension provides a connection to the MySQL and MariaDB instances, explores database objects, generates DDL (Create, Alter, Drop) and DML (Select, Insert, Update, Delete) scripts for a variety of objects (tables, view, stored procedures, functions).
April 7, 2020