Query, update, navigate and manage all major databases from one database tool. RazorSQL is a universal database query tool, programming and sql editor, database navigator, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite, and Sybase. Any other JDBC or ODBC (Windows only) compliant database is also supported. RazorSQL ships with a built-in relational database engine that is up and running out of the box and requires no end-user administration. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects; 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, tools for creating, editing, and executing stored procedures, triggers, and functions, a tool to compare table data and/or query results, and SQL history. 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.