RazorSQL 4.5.3

RazorSQL 4.5.3  is a SQL database query tool, SQL editor, database browser, and administration tool with support for all major databases and 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 twelve 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.

RazorSQL Highlights:

• Database Browser: Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more.
• Database Tools: Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more.
• Import Data:Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files.
• SQL Query Builder:Create select, insert, update, and delete SQL statements. Create multi-table joins.
• Edit Table Tool:Insert, update, and delete table data in a spreadsheet like format. Find and replace data, preview generated SQL, and more.
• SQL Editor:Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Uses the powerful EditRocket code editor that supports over 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, Java, XML, and more.
• Database Query Tool:Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more.
• Export Data:Export data in various formats such as delimited files, XML, HTML, Excel spreadsheets, and SQL insert statements.
• Built-in Database:Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.
• Data CompareCompare table data across databases, or compare the results of queries.

Major Features:

1.  A Database Navigator for browsing database objects.
2. An SQL Editor for creating SQL queries.
3. Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences
4. Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers
5. A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more.
6. Export Tool - Export data in various formats
7. Import Tool - Import data from delimited files, Excel files, or fixed width files into tables
8. Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration
9. A Generate DDL Tool for generating table, view, and index DDL.
10. Table / SQL Query Compare tool for comparing tables or queries across multiple connections
11. Auto column and auto table lookup
12. SQL Formatter
13. SQL Query builder tool
14. SQL Query Scheduler tool
15. Command Line Interface
16. PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers
17. An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers
18. SQL GUI Tools for generating SQL for various operations
19. Edit, delete, and insert database data with the Database Editor
20. Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS
21. Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata

Enhancements: Apache derby enhancements and bug fixes.