Query, update, navigate, and manage databases from one database tool. RazorSQL is a universal database query tool, SQL editor, and database navigator. Use the built-in relational database engine for your database needs, or connect to databases such as Oracle, DB2, Microsoft SQL Server, Sybase, and PostgreSQL via the built-in drivers. Connect to other popular databases such as MySQL via a free JDBC driver download or via ODBC. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, and viewing tables; tools for importing and exporting data; a database browser for the viewing of database objects and structures; and a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and eleven other programming languages. Also included are a query builder, a tool to call stored procedures, a tool to compare table data and/or query results, and query logging. Add functionality with the plugin API.
Comments (2)
DBMS specific tools are better if you never leave a specific DBMS. SSMS is a better option for SQL Server, Toad does a better job for Oracle. But if you need flexibility to handle multiple OS and DBMS environments, Razor is easily the front-runner.
My only complaint is it only stores queries that have been executed in its history so on a hard reboot, I lose anything I had been writing that hadn't yet been executed. But honestly that's as much a user error as it is a Razor issue.