Skip to content

Database Tools


Application Performance

Precise

Idera Precise is a database management and performance analysis tool. It helps database administrators optimise performance, find and resolve problems, and increase the security and availability of their databases. The tool supports a wide range of database platforms, including Oracle, SQL Server, DBXNUMX and MySQL.


Backup and Administration

DBArtisan

DBArtisan is a database administration tool developed to administer databases. DBArtisan is designed to help database administrators manage and optimise the performance of their databases. The tool supports a variety of database platforms, including Oracle, SQL Server, DB2, Sybase, Snowflake, Teradata and MySQL. DBArtisan offers features such as security management, performance analysis, schema and data management, as well as easy access to databases via a graphical user interface. It also helps automate key database administration tasks to reduce manual work and improve efficiency.

SQL Admin Toolset

Database administrators need simple and quick ways to manage their SQL Server environment. SQL Admin Toolset provides 24 essential desktop tools for SQL Server to save time by simplifying routine administrative and troubleshooting tasks.

SQL Enterprise Job Manager

IDERA SQL Enterprise Job Manager is a database administration tool specifically developed to help database administrators manage and automate jobs for SQL Server. It provides database administrators with an overview of all scheduled jobs and their performance, as well as the ability to create, edit and delete jobs. Jobs can be scheduled to run at specific times or on certain events, and it is also possible to create and manage jobs that are linked to certain databases or servers.

The tool also has a function to track and manage failed jobs, as well as a function to generate reports and monitor the performance of the jobs. This can help database administrators identify and resolve problems with the jobs and improve the performance and availability of the databases.

SQL Safe Backup

SQL Safe Backup is a tool for safe backup of SQL Server databases from Idera (formerly Embarcadero Technologies). The tool is designed to automate and optimise the backup process for SQL Server databases. It enables database administrators to create database backups with minimal impact on performance and availability, and to restore databases with high speed and quality.

SQL Safe Backup offers features such as:

  • Incremental backups that only copy changes since the last full backup, reducing the time and bandwidth required for backups.
  • Compression and encryption of backups to minimise storage costs and protect data.
  • Support for creating backup copies to various storage devices, including disk, tape, network or cloud services.
  • Ability to restore databases to a point in time or an earlier version number.
  • Create automatic reports to track and monitor backup status and performance

SQL Safe Backup is one of the tools in the IDERA SQL Admin Toolset.

SQL Virtual Database

Idera SQL Virtual Database is a feature of Idera’s data management software that allows users to create a virtual copy of a SQL Server database. The virtual copy, or VDB, can be used for a variety of purposes, such as testing, reporting, or providing a read-only copy of the data to users without giving them access to the live database. The VDB is created using a process called “snapshot” which creates a point-in-time copy of the data stored in a different location. This allows the VDB to be used independently of the live database without affecting its performance. The VDB can be restored to a previous state at any time, and it can be used to test upgrades and schema changes before they are implemented on the live database.

SQL Toolbox

IDERA SQL Toolbox is a collection of tools for SQL Server administrators. It is a collection of different tools that help to manage, monitor, and optimise SQL Server databases, similar to IDERA SQL Management Suite, but with more focus on various specific tasks. It provides a comprehensive set of tools to manage and optimise SQL Server databases, and can be used to manage large numbers of databases across multiple servers.


Data Modeling and Architecture

Enterprise Architect

Sparx Systems Enterprise Architect is a visual modelling and design tool for software and business systems. It supports a wide range of modelling languages and standards, including Unified Modelling Language (UML), Business Process Modelling Notation (BPMN), and ArchiMate.

It has features for designing and documenting software architecture, reverse engineering existing code, creating and managing requirements, testing and validation, and more. It also includes collaboration and project management tools to support teamwork and version control.

It is a comprehensive tool that can be used by software developers, systems architects, business analysts, and other stakeholders to design, document, and validate the structure and behavior of complex systems. It also supports various platforms like Windows, Mac, Linux and also available as Cloud version.

ER/Studio

ER/Studio is a database modeling tool designed to help developers, database administrators, and architects create, manage, and optimise database models for SQL Server, Oracle, DB2, Sybase, and other database platforms.

The tool has a graphical user interface that enables users to create and manage database structures, including tables, joins, and stored procedures, as well as to compare and synchronise database structures between different database environments. The tool also has tools to automate SQL script generation, data and metadata retrieval, and helps keep track of database model versions.

ER/Studio is a professional tool designed to help optimise database models, improve performance and security, and facilitate collaboration between developers, database administrators, and architects.


Database Development

DB Change Manager

DB Change Manager is a tool for database administration specifically developed to help database administrators manage and trace database changes. The tool allows database administrators to keep track of who does what and when in the database and to track and roll back changes to the database.

DB Change Manager offers features such as:

  • Track all changes to the database, including tables, views, stored procedures, features and triggers.
  • Collect metadata and track changes to the database structure.
  • An automated generation of SQL scripts for changes in the database.
  • How and check changes to the database employing simple approval and workflow processes.
  • Monitor and track performance for changes in the database.

DB Change Manager is a tool for database administration that helps automate and manage database changes while providing database administrators with ways to monitor and track changes in the database to improve security and performance.


Database Suites

SQL Comparison Toolset

The SQL Comparison Toolset allows database administrators to compare and synchronise database structures and data between different database environments. The tool enables database administrators to compare and synchronise databases, including tables, views, stored procedures, functions, and triggers, to ensure database consistency and integrity.

SQL Comparison Toolset offers features such as:

  • Compare and synchronise databases, including tables, views, stored procedures, functions and triggers.
  • Collect metadata and compare changes in the database structure.
  • Automate the generation of SQL scripts for database changes.
  • Manage and control database changes using simple approval and workflow processes.
  • Monitor and track the performance of database changes.

The SQL Comparison Toolset is a tool that helps database administrators compare and synchronise databases while providing the ability to monitor and track database changes to ensure database consistency and integrity. It is one of the tools in the IDERA SQL Admin Toolset.

DB PowerStudio

DB PowerStudio is designed to help database developers and administrators to manage, design and develop databases, mainly for SQL Server databases, but also supports other databases such as Oracle, MySQL and DB2.

DB PowerStudio offers various features such as:

  • SQL editor and debugger for writing, testing and debugging SQL scripts.
  • Database design and modelling tools for creating and modifying database structures.
  • Data management tools for managing data in tables, views, and stored procedures.
  • Database comparison and synchronisation tools for comparing and synchronising databases.
  • Security management tools for managing database security and user access.
  • Performance monitoring and tuning tools for monitoring and optimising database performance.
  • It also offers a feature of generating reports and charts from data in the databases.

DB PowerStudio is a comprehensive tool for database management and development. It enables database developers and administrators to manage and optimise their databases efficiently. It is a good option for SQL Server database management and development.

idera logo

SQL Management Suite

IDERA SQL Management Suite is a collection of tools that is used to manage and optimise SQL Server databases. It provides a wide range of functionality to help administrators, developers, and DBAs manage their SQL Server databases, including:

  • Performance monitoring and tuning to optimise the performance of SQL Server databases
  • Backup and recovery to protect data and ensure business continuity
  • Security and compliance management to ensure that databases meet regulatory requirements and are protected from threats
  • Automation and scripting to automate repetitive tasks and streamline database management
  • Query optimisation and index management to improve the efficiency of database queries

It provides a comprehensive set of tools to manage, monitor, and optimise SQL Server databases, and can be used to manage large numbers of databases across multiple servers. It also includes some of the features that IDERA SQL Security Suite includes.

idera logo

SQL Security Suite

IDERA SQL Security Suite is a security solution specifically designed for SQL Server databases. It provides a set of tools and features to help secure and protect SQL Server databases from threats such as unauthorised access, data breaches, and compliance violations. Some of the features that IDERA SQL Security Suite may include are:

  • Authentication and access controls to ensure only authorised users can access and modify the data in the database
  • Encryption to protect sensitive data from unauthorised access
  • Auditing and reporting to help detect and respond to security breaches
  • Compliance reporting to help meet regulatory requirements such as HIPAA, PCI-DSS, and SOX
  • Intrusion detection and prevention to help detect and prevent unauthorised access to the database

It is a third-party software that helps to secure your SQL servers from various threats, and it can be integrated with other security tools to provide a comprehensive security solution.


Monitoring and Performance

DB Optimiser

Embarcadero DB Optimiser simplifies SQL optimisation and development for application developers with many features for improving productivity and reducing errors. A rich SQL IDE with statement tuning, data source profiling, code completion, real-time error checking, code formatting and sophisticated object validation tools helps streamline coding tasks.

SQL BI Manager

SQL BI Manager provides agentless monitoring of the servers and services for SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services.

idera logo

SQL Defrag Manager

Idera Defrag Manager is a software tool from Idera that helps optimise the performance of SQL Server databases by defragmenting their indexes. Defragmentation is the process of reorganising the data in a database to increase the speed and efficiency of queries. When a database is heavily used, its indexes can become fragmented, which means that the data is spread out over many different pages and is not stored in a contiguous manner. This can lead to poor performance, as the SQL Server engine has to read multiple pages to retrieve the data it needs.

Idera Defrag Manager allows users to analyse and defragment the indexes in their SQL Server databases, either manually or on a schedule. It also provides detailed reporting on the fragmentation of the indexes, allowing users to identify which indexes are in need of defragmentation. The software also supports automated defragment of indexes and reporting of fragmentation levels. This can help to improve the performance and responsiveness of SQL Server databases and reduce the risk of data corruption.

idera logo

SQL Diagnostic Manager

Idera Diagnostic Manager is a software tool from Idera that helps to diagnose and resolve performance issues in SQL Server databases. It allows users to monitor and analyse the performance of their databases in real-time, and provides a wide range of diagnostic and troubleshooting tools to help identify and resolve issues.

It includes features such as:

  • Real-time performance monitoring and alerts
  • Historical performance data collection and reporting
  • Query optimisation and analysis
  • Performance tuning and troubleshooting
  • Index and statistics management
  • Automated diagnosis and resolution of common SQL Server issues

It also provides a web-based dashboard that allows users to easily view and manage the performance of their databases, and can be integrated with other Idera products to provide a comprehensive solution for managing and optimising the performance of SQL Server environments.

It can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues, improve the overall performance and availability of their SQL Server databases, and reduce the risk of data corruption.

idera logo

SQL Doctor

Idera SQL Doctor is a software tool from Idera that helps diagnose and resolve performance issues in SQL Server databases. It is designed to be easy to use and provides a wide range of diagnostic and troubleshooting tools to help identify and resolve issues.

It includes features such as:

  • Automatic diagnosis of common SQL Server issues
  • Real-time performance monitoring and alerts
  • Query optimisation and analysis
  • Performance tuning and troubleshooting
  • Index and statistics management
  • Web-based dashboard and reporting

It allows users to quickly identify and resolve performance issues, improve the overall performance and availability of their SQL Server databases, and reduce the risk of data corruption. Additionally, it can be integrated with other Idera products to provide a comprehensive solution for managing and optimising the performance of SQL Server environments. It can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues and improve the overall performance and availability of their SQL Server databases.

idera logo

SQL Inventory Manager

IDERA SQL Inventory Manager is a software tool from Idera that helps users to manage and inventory their SQL Server environment. It allows users to discover, inventory and document their SQL Server instances and databases, and provides detailed reporting on the configuration, performance, and security of their environment.

It includes features such as:

  • Automatic discovery of SQL Server instances and databases
  • Inventory and documentation of SQL Server configuration, performance, and security
  • Detailed reporting on SQL Server environment
  • Customisable data collection and reporting
  • Integration with other Idera products for a comprehensive solution

It allows users to quickly identify and resolve performance issues, improve the overall performance and availability of their SQL Server databases, and reduce the risk of data corruption. Additionally, it can be integrated with other Idera products to provide a comprehensive solution for managing and optimising the performance of SQL Server environments. It can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues and improve the overall performance and availability of their SQL Server databases.

idera logo

SQL Toolbox

IDERA SQL Toolbox is a collection of software tools from Idera that are designed to help manage and optimise SQL Server databases. The toolbox includes a variety of tools that can help with tasks such as performance monitoring, troubleshooting, backup and recovery, and more. Some of the tools that are included in the SQL Toolbox are:

  • SQL Safe Backup
  • SQL Defrag Manager
  • SQL Doctor
  • SQL Inventory Manager
  • SQL Virtual Database
  • SQL Comparison Toolset
  • SQL Diagnostic Manager
  • SQL Compliance Manager

Each tool is designed to address a specific aspect of managing and optimising SQL Server databases, and can be used together to provide a comprehensive solution for managing and optimising the performance of SQL Server environments. The tools can be used by database administrators, developers, and other IT professionals to quickly identify and resolve performance issues and improve the overall performance and availability of their SQL Server databases.


Security and Compliance

idera logo

SQL Compliance Manager

Simplify your SQL Server audits. SQL Compliance Manager is a comprehensive auditing solution that uses policy-based algorithms to track changes to your SQL Server objects and data. SQL Compliance Manager gives you detailed visibility to determine who did “what”, “when”, “where”, and “how”, whether the event is initiated by privileged users or hackers.

IDERA SQL Compliance Manager provides a centralised and automated solution for managing and auditing sensitive data, including the ability to:

  • Continuously monitor and audit sensitive data
  • Protect data by masking or encrypting sensitive columns
  • Detecting and alerting on sensitive data access
  • Generating compliance reports
  • Managing compliance policies

It helps organisations to protect sensitive data, such as personal information and financial data, from unauthorised access, and to meet the requirements of regulatory and industry standards for data security and privacy. It can be used by database administrators, developers, and other IT professionals, as well as compliance and security teams, to quickly identify and resolve compliance issues and improve the overall security and compliance of their SQL Server environments.

idera logo

SQL Secure

IDERA SQL Secure is a software tool from Idera that helps organisations to secure their SQL Server environment by identifying and remediating security vulnerabilities. It provides a centralised and automated solution for managing and auditing security, including the ability to:

  • Continuously monitor and audit security
  • Identify vulnerabilities and misconfigurations
  • Provide actionable remediation guidance
  • Generate security reports and alerts
  • Manage security policies

It helps organisations to secure their SQL Server environment by identifying and remediating security vulnerabilities, such as weak passwords, unsecured data, and misconfigured servers. It can be used by database administrators, developers, and other IT professionals, as well as security teams, to quickly identify and resolve security issues and improve the overall security of their SQL Server environments.


SQL Database

InterBase

InterBase is a relational database management system (RDBMS) developed by Embarcadero Technologies. It is a high-performance, low-maintenance, and secure database that can be used for a wide range of applications, including web, mobile, and desktop. InterBase is known for its small footprint, high performance, and ability to run on a wide range of platforms, including Windows, Linux, and macOS.