ApexSQL Features

Based on 14 ApexSQL reviews. Allows data movement from one database to another.

Based on 14 ApexSQL reviews. Provides data backup and recovery functionality to protect and restore a database.

As reported in 14 ApexSQL reviews. Allows users to access and work on data concurrently, supporting several views of the data.

Stores the database metadata, that is the definitions of data elements, types, relationships etc. This feature was mentioned in 14 ApexSQL reviews.

Based on 14 ApexSQL reviews. Creates a copy of the database to maintain consistency and integrity.

Allows users to create, update and retrieve data in a database. 14 reviewers of ApexSQL have provided feedback on this feature.

Defines the logical design of the data before building the schemas. This feature was mentioned in 14 ApexSQL reviews.

Based on 14 ApexSQL reviews. Monitors and analyzes critical database attributes like query performance, user sessions, dead lock detail, system errors etc and visualize them on a custom dashboard.

As reported in 14 ApexSQL reviews. Encrypts and transforms data at the database from a readable state into a ciphertext of unreadable characters.

As reported in 14 ApexSQL reviews. Allows restricted user acess to modify depending on the access level.

Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.

Allows permissions to be granted or revoked in the database, schema or table levels.

Built-in native encryption with enterprise key management.

Provides multi-factor authentication with certificates.

Provides support for international character sets and full text search.

Supports multiple data types like primitive, structured, document etc.

Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Provides data recovery functionality to protect and restore data in a database.

Allows multi-version concurrency control.

Handles workloads, from single machines to data warehouses or web services with many concurrent users.

Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.

Helps interpret SQL queries and determine the fastest method of execution.

Data is organized as a set of tables with columns and rows like a table structure.

Allows users to create, update and retrieve data in a database.

Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.

Provides log-based or/and trigger-based replication.