Some features may actually exist where I’ve said they don’t, or I might have done something wrong that causes the error. Some were good, and some not so good.Īlso, I didn’t spend a great deal of time with each IDE as that would take too long. The user interfaces were quite different between them.
Many other standard features were implemented in a similar way, such as code complete or exporting data. Many features seem standard and were implemented in different ways, such as explain plans. The easier a tool is to create a connection, the better.
Others involved setting up a System DSN on your computer and connecting via that, and others involved installing other drivers and tools just to connect. Some were simple and just involved entering a database, service name, username, and password. This excludes tools like SQL*Plus and SQLcl.īefore we get into my recommendations and more details about each IDE, there were a few things I noticed when testing and analysing these SQL editors.įirst, the connection process was different for many of them. It also excludes data modelling tools and data visualisation tools. While Notepad++ is a great tool and has SQL syntax highlighting, it doesn’t let you run SQL queries. This excludes text editors such as Notepad++. Must be able to write and run SQL queries.This guide has been created and was last updated in 2020. Some sites had a comparison of IDEs but they were out of date.
I’ve seen many questions on websites such as Quora and Stack Overflow about “which IDE is the best” and “which SQL Editor should I use”, and while there were some good answers, there wasn’t really a single place to compare all of the options. It’s a list of all SQL editors available for major databases: Oracle, SQL Server, MySQL, PostgreSQL, SQLite, and MariaDB.
This guide is a comparison of all SQL IDEs currently available.
Pricing of RazorSQL starts at $99.95 USD for a single user, and tiered discounts are offered for multiple license purchases.Are you looking for an SQL IDE (Integrated Development Environment) or SQL editor? Take a look at this list of all of the IDEs currently available. RazorSQL 7.0 is available for immediate download at.
Versions of RazorSQL are available for Windows, Mac OS X, Linux, and Solaris. New features in version 7.0 include database conversion support for converting DB2 database tables to PostgreSQL and several other database types, more support for the Amazon Redshift database, and enhanced DDL generation options. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects such as tables, views, indexes, procedures, functions, and triggers tools for importing and exporting data in various formats such as MS Excel, delimited files, SQL insert statements, HTML, XML, and text a database browser for the viewing of database objects and structures search tools for searching for database objects and database data, tools for building SQL queries and generating SQL and DDL, a SQL formatting tool, SQL history tracking and and SQL favorites tool for storing frequently used SQL statements, and a robust programming editor and query tool with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and many other programming languages that features tools for searching and replacing data, programmable macros, coding sidekicks for various programming languages, a file system browser, function and method browsers, and much more. Users can also use the built in relational database engine for their database needs. Connect to other databases via JDBC or ODBC (Windows only). RazorSQL supports over 30 databases, examples of which include the following: PostgreSQL, Amazon SimpleDB, Apache Derby, DB2, Firebird, FrontBase, H2, HSQLDB, Informix, Intersystems Cache, JavaDB, MS Access, MySQL, OpenBase, Oracle, Pervasive, SQLite, SQL Azure, SQL Server, Sybase, Sybase SQL Anywhere and Teradata. Using RazorSQL, users can query, edit, browse, and manage all major databases from one tool. RazorSQL 7.0, an SQL editor, database query tool, database browser, and database administration tool, is now available.