Idera Cloud Service

Easily manage your SQL Server databases in the cloud

SQL Server databases deployed in the cloud require careful configuration and monitoring. Deploying databases in the cloud can provide many benefits. However, if your databases aren’t correctly set up or managed, the resulting problems can be costly. Before, during, and after deployment, consider the following questions.

The path to successful cloud database management

If you are not managing SQL Server databases properly in the cloud, it is just a matter of time before lightning strikes. Proper database management across the environment involves multiple aspects and tasks, and produces critical benefits:

• Manage the inventory, security, configuration, disaster recovery, performance, migration, data, and data models of your databases on physical machines, virtual machines, and cloud-hosted virtual machines, as well as managed cloud databases.

Effectively managing your SQL Server databases in the cloud is essential

• Due to the increasing pressure to keep up with the digital transformation, many organizations need to move their databases to the cloud.
• SQL Server databases are moving to the cloud and managed cloud databases (such as Azure SQL Database and Amazon RDS for SQL Server) are also increasing in use.
• Migration to cloud-based databases and workloads is driven by organization management to realize cost savings.
• Cost savings do not necessarily happen automatically after migrating databases to the cloud.
• You need to manage and leverage your growing database environment, expand your infrastructure wisely, and manage risk to control costs.

IDERA CLOUD CAPABILITIES

Complete solutions for your cloud database needs. Experience the real benefits of cloud databases and increase organizational efficiency with tools such as

View performance and availability, track application transactions, and perform root cause analysis for your AWS environment with Uptime Infrastructure Monitor. Access and manage AWS platforms such as Amazon Redshift, MySQL, and PostgreSQL with the administration capabilities and database query tool in Aqua Data Studio. Monitor the performance of SQL Server or MySQL cloud deployments (including Amazon RDS for SQL Server, MySQL, MariaDB, or Aurora) with predictive alerting and diagnostics using SQL Diagnostic Manager. Tune the performance of SQL Server cloud deployments (including Amazon RDS for SQL Server) via expert recommendations using SQL Doctor. Backup to and restore from Amazon S3 with SQL Safe Backup.

Manage SQL Server and Oracle Data Sources

Connect to SQL Server and Oracle data sources from a single user interface. Register data sources manually or semi-automatically. Log in to multiple data sources. Drill down into the data sources to view registered databases on each server.

Manipulate Database Objects

Drill down into each database to display its objects and to inspect the structure of individual objects for quick visibility into databases. Navigate and search objects, create new objects, edit existing objects, execute context-sensitive commands, and browse outline views without SQL script. Manage database objects, including tables, constraints, indexes, views, procedures, functions, triggers, and packages. Efficiently navigate databases with many objects.

Interactively Edit SQL Code

Edit SQL code in the interactive development environment. Select from a list of context-sensitive suggestions for object and function names, and automatically insert SQL statements from templates to avoid looking up, memorizing, and typing. Prevent and fix common mistakes with SQL code quality markers. Validate SQL syntax and semantics in real-time to avoid parser violations and unresolved references. Automatically format displayed SQL code for easy navigation. Apply and share custom SQL formatting profiles for consistent SQL code layout. Improve queries by viewing the SQL query execution plan.

Selectively Execute SQL Queries to Retrieve Data

Associate SQL files with data sources, specify SQL session options, and selectively execute SQL statements in the integrated environment to quickly manipulate database content. Display the resulting data in a convenient grid. View logs of all executed SQL queries to analyze and document past actions.

Export Data to Common File Formats

Save extracted data to standard file formats (Excel, HTML, XML, delimited TXT, and SQL INSERT statements) for subsequent analysis and collaboration.

Connect to Cloud and Run in Cloud (Provisional)

Connect to database instances hosted in the cloud, such as SQL Server on Azure Virtual Machine (VM), SQL Server on Amazon Elastic Compute Cloud (EC2), and SQL Server on Amazon Relational Database Service (RDS).

Run on virtual machines hosted in the cloud, such as Windows on Azure Virtual Machine (VM) and Windows on Amazon Elastic Compute Cloud (EC2).

* Work on databases on-premises and in the cloud, and without installing anything on the affected instances.