DbNinja vs Redgate SQL Provision

DbNinja is a web application for administering and developing MySQL databases, including databases on remote hosted servers. It can manage database objects such as tables, events, indexes, triggers, procedures, views, users, and privileges. For maintenance, it backs up and restores database structure and data, and compares or synchronizes databases between hosts. Exports are available in CSV, SQL, Excel, and JSON formats. Query tools include syntax highlighting, saved favorite queries, and limits on fetched data and query execution time. You can connect to multiple hosts at once and work in tabs.

DbNinja is self-hosted: setup involves copying its package into a directory in your webroot and completing setup in a browser. It requires a PHP-enabled web server, PHP 5.3 or higher with mysqli, MySQL 4.1 or higher, and a recent major browser with cookies enabled. The Personal use plan is free and is for user-installed use from one computer at a time. Commercial licensing is available by quote.

Redgate SQL Provision combines SQL Clone and Data Masker for SQL Server to create virtualized database copies with sensitive data masked. It is intended for development, test and continuous integration environments. Teams can automate environment creation and refreshes, or let developers request fresh data themselves. A single interface manages database clones and permissions, while integrated masking is intended to shield sensitive information in non-production environments. Redgate says masking can help protect data subject to GDPR, HIPAA, CCPA and other regulations. The product advertises environment refreshes in seconds and storage savings of up to 99%. It supports Microsoft SQL Server and self-hosted deployment, with web and desktop deployment options. Licensing tiers are based on combined production data volume, with listed capacities from 1TB to 100TB. Customers between tiers must buy the next higher tier, and capacity is reviewed every 12 months after a subscription begins. Pricing is on request; there is no free plan and a fully functional 14-day trial is available.