Development
RazorSQL
Richardson Software LLC.
About
RazorSQL is a tool designed for managing major databases from within a single application.The program allows users to execute SQL queries; visually edit, create, alter, and view tables; import and export data; build queries using a dedicated query builder; and browse databases via a database navigator.The application also features a built-in relational database that requires no configuration.RazorSQL supports all popular databases, including MySQL, Oracle, DB2, Microsoft SQL Server, PostgreSQL, Microsoft Access, Pointbase, and Sybase.
Advanced Connectivity Features
• Built-in support for DB2, Derby / JavaDB, Firebird, FrontBase, HSQLDB, Informix, MySQL, OpenBase, Oracle, PostgreSQL, SQLite, SQL Server, Sybase Adaptive Server Enterprise, and Sybase SQL Anywhere.It can also connect to any database that supports JDBC or ODBC (Windows only), such as Access, Daffodil, H2, Ingres, Interbase, Mimer SQL, Mckoi, Paradox, Pervasive, Pointbase, Solid, and Teradata.
• PHP Bridges for MySQL, PostgreSQL, and MS SQL Server, enabling connections to these databases via PHP.This provides remote access to MySQL, PostgreSQL, or SQL Server databases hosted behind PHP-enabled web servers.
• MS SQL Server ASP Bridge, enabling connections to SQL Server databases via ASP.This provides remote access to SQL Server databases hosted behind ASP-enabled web servers.
• RazorSQL JDBC Bridge, enabling connections to databases via a JEE/J2EE application server or servlet container.
Database and SQL Tools
• Create, alter, and drop tables and views.• *Creation and deletion of Indexes and Sequences
• *Creation and deletion of Stored Procedures, Functions, Packages, and Triggers
• *Creation and deletion of Databases and Users
• Table Editor Tool
• *Editing of Stored Procedures, Functions, Packages, and Triggers
• Description of Tables and Views
• DDL Generator Tool for creating DDL for Tables, Views, and Indexes
• Viewing of Table and View contents
• *Viewing of Stored Procedure, Function, Package, and Trigger contents
• SQL Query Builder for SELECT, INSERT, UPDATE, and DELETE statements
• Data Export to Text, HTML, XML, Excel, or Delimited file formats, or as INSERT statements
• Data Import into Tables from Delimited files, Excel files, or Fixed-width files
• Execution of Stored Procedures
• *SQL Explain Plan Tool
• SQL Query Scheduler
• Comparison of Table Data or Query Results
• File Comparison Tool
• Zip Utility for viewing/extracting Zip and Jar files
• File System Browser
• Viewing of Database Metadata (Functions, Types, etc.)
• Command Line Interface for running RazorSQL tools from the command lineSQL Editor
• Syntax highlighting for SQL, PL/SQL, Transact-SQL, SQL PL, Batch, C, COBOL, CSS, C++, C#, Java, JavaScript, JSP, HTML, PHP, Perl, Python, Ruby, Shell Script, and XML
• Automatic table and column completion
• Automatic column lookup
• Automatic table lookup
• SQL formatting
• Support for parameterized queries
• Execute, Execute All, and Batch execution functions
• Multi-tab display of query results
• Sortable query results
• Filterable query results
• Searchable query results
• SQL history for all queries and query logging for each connection
• Automatic function lookup for all supported programming languages, and automatic method lookup for Java and JSP• Query List, Tag List, and Function/Method List—options for interactively displaying the queries, tags, or functions/methods contained within the editor.
• File tools such as head, tail, get section, search/regex, move, copy, rename, delete, size, and get info.
• Type-ahead feature for populating user-defined text with a single click.
• Regular Expression Find, Find/Replace, and Find/Replace in Files.
• Brace matching, tag matching, and Go-to-Line commands.
• Support for printing editor contents and query results.
• Support for dozens of file encodings.
• Built-in and custom user templates.
• Keep-Alive connection maintenance.
• Plugin API (allows users to add custom functions to RazorSQL).
Database Browser
• Tree structure for navigating database objects.
• Use database-specific system queries provided by RazorSQL, user-provided queries, or default JDBC/ODBC driver settings to navigate the database or database structures.
• One-click content viewing for tables, views, etc.
• Column information, including column name, keys, data type, nullability info, etc.
• Displays information on objects such as procedures, functions, triggers, indexes, constraints, sequences, etc.
• One-click DDL generation for tables, views, and indexes.
• Table and data search.
• One-click generation of SQL SELECT, INSERT, UPDATE, and DELETE queries.Built-in Database
• Requires no configuration by the end user
• Connect to a robust database right out of the box
• Powered by the powerful HSQLDB database engine