Conductor4SQL Overview

Conductor4SQL is an advanced database management solution that permits organisations to effectively manage a large number of database instances with an unlimited number of databases, especially those which are dispersed over a large geographic area. A key advantage of this solution is that it can greatly reduce a lot of the frustration when managing multiple databases over erratic networks because of its automation capabilities. It supports multiple database technologies such as MS SQL Server, Azure SQL, Azure SQL Managed Instance, Microsoft Fabric Data Warehouse, MySQL and PostgreSQL.

The Conductor4SQL Modules

Conductor4SQL is divided into modules, taking the pay for what you need approach.

• SQLClassic - the original classic version of Conductor4SQL and is limited to just MS SQL Server. You can read more about this edition here https://enterpriseworx.github.io/conductor4sql-technical-documentation/.

• SQLPro - a module focused on mundane task automation and monitoring.

  • Live Alerts - Immediately know about issues such as No comms, Low disk space, failing jobs, and long-running queries. Some built-in alerts are Microsoft SQL Server–specific (for example SQL Agent, jobs, and replication).
  • Centralised Query - Query multiple instances of multiple database types (MS SQL Server, Azure SQL, Azure SQL Managed Instance, Microsoft Fabric Data Warehouse, MySQL and PostgreSQL) using the standard SQL syntax from a centralised location.
  • Backup & Maintenance - Configure local or cloud database backups and database maintenance from a central location (MS SQL Server only)
  • Auditing - Audit DDL changes and create email alerts for any defined dangerous changes.

• SQLSync - a module focused on replicating selected Microsoft SQL Server tables (Azure SQL, Azure SQL Managed Instance, or on-premises) to Microsoft Fabric Data Warehouse or another SQL Server destination using Change Tracking.

• SQLSense - a module focused on sensitive data detection and checking on database access to that sensitive data. This greatly assists with data protection compliance.