Best Free SQL Editors - Page 2

DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures. It is an excellent tool for any project development team or DBA managing multiple copies of the same database on an SQL Server. This database comparison tool has a clean and straight-forward user interface. Results are clearly presented so that you can immediately see the differences in your databases. It will make locating and eliminating differences in your database fast and easy. In a Development or Test environment, you tend to have frequent changes to your databases and database schemas. But on live (Production) databases with real and potentially sensitive data, changes to the database schema are rare and can be complicated. In order to avoid unsuccessful deployments of your database related projects, you have to be sure that your databases are synchronized.

LibreDB Studio is an open-source database IDE that runs on infrastructure you control and provides a browser-based workspace, with platform-specific local installation options. It supports connections to a range of relational, document, key-value, and analytics databases. Database professionals can browse schemas and objects, write and run queries, inspect execution plans, compare schemas, and view relationships in ER diagrams. The workspace also includes query history and audit records, session and query monitoring, role-based access controls, and OpenID Connect single sign-on. Designed for developers, data engineers, and database administrators, Studio can be deployed near the databases it accesses, keeping connections within a private network. The self-hosted software is available under the MIT license.