Query, update, navigate and manage all major databases from one database tool. RazorSQL is a universal database query tool, programming editor, database navigator, and administration tool with built-in connection capabilities for DB2, Derby, HSQLDB, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, 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, 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, tools for creating, editing, and executing stored procedure 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.