
RazorSQL is the software you need to query, update, navigate and manage databases from one database client. RazorSQL ships with a relational database engine that requires no configuration. Connect to other databases via either ODBC or JDBC.
Drivers are included for DB2, HSQLDB, Oracle, PostgreSQL, SQL Server, and Sybase.
Run SQL scripts; visually edit, create, alter, and view tables; import and export data; and browse database structures with the navigator. Also included are a query builder, a tool to call stored procedures, a tool to compare table data and/or query results, query logging, and SQL templates for creating structures on several databases.
The SQL programming editor includes support for SQL, PL/SQL, TransactSQL, SQL PL, and Java and includes auto column completion, auto function/method lookup, syntax highlighting, key-ahead, multi-tabular display of queries, find/replace, find/replace in files, and bracket matching.
Add functionality with the plugin API. RazorSQL supports all major databases.
Software features of "RazorSQL":
Advanced Connection 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. Also can connect to any database that supports JDBC or ODBC (Windows only) such as Access, Daffodil, H2, Ingres, Interbase, Mimer SQL, Mckoi, Pervasive, Pointbase, Solid, and Teradata.
· A RazorSQL MySQL PHP Bridge for connecting to MySQL databases via a PHP page. Allows remote access to MySQL databases running behind PHP enabled web servers
· A RazorSQL JDBC Bridge for connecting to databases via a JEE/J2EE Application Server or Servlet Container
Tools
· Create, Alter, and Drop Tables and Views
· Create and Drop Indexes and Sequences
· Create and Drop Stored Procedures, Functions, Packages, and Triggers
· Create and Drop Databases and Users
· Edit Table Tool
· Edit Stored Procedures, Functions, Packages, and Triggers
· Describe Tables and Views
· View contents of Tables and Views
· View contents of Stored Procedures, Functions, Packages, and Triggers
· SQL Query Builder for Select, Insert, Update, and Delete Statements
· Export Data in text, HTML, XML, Excel, delimited file format or as insert statements
· Import Data into tables from delimited files, Excel files, or fixed width files
· Execute Stored Procedures
· SQL Explain Plan Tool
· SQL Query Scheduler
· Compare Table Data or Query Results
· File Compare Tool
· Zip Utility for viewing/extracting Zip and Jar files
· File System Browser
· Database Meta Data Viewer (Functions, Types, etc.)
· Command Line Interface for running RazorSQL tools from the command line.
SQL Programming Editor
· Syntax Highlighting for SQL, PL/SQL, TransactSQL, SQL PL, Batch, C, COBOL, CSS, C++, C#, Java, JavaScript, JSP, HTML, PHP, Perl, Python, Ruby, Shell Script, and XML
· Automatic Column Lookup
· Automatic Table Lookup
· SQL Formatter
· Support for parameterized queries
· Execute, Execute Fetch All, and Execute Batch functions
· Multi-Tabular Display of Query Results
· Sortable Query Results
· Filterable Query Results
· Searchable Query Results
· SQL History for All Queries, and Query Logging Per Connection
· Auto-function lookup for all supported programming languages and auto-method lookup for Java and JSP
· Query List, Tag List, and Function / Method List options for clickable display of queries, tags, or functions / methods contained in the editor
· File tools such as head, tail, get section, search / regex search, move, copy, rename, delete, size, and get info.
· Key Ahead functionality for one-click population of user-defined text
· Find, Find/Replace, Find/Replace in Files
· Bracket Matching, Tag Matching, and Goto Line commands
· Printing Support for Editor Content and Query Results
· Support for dozens of file encodings
· Built-in and Custom User Templates
· Connection Keep-Alive
· Plugin API (Allows users to add custom functionality to RazorSQL)
Database Navigator
· A tree structure to navigate database objects
· Use RazorSQL provided database specific system queries or user supplied queries for database navigation, or navigate the database structures using the default JDBC/ODBC driver settings.
· Single click content viewing on tables, views, etc.
· Column information including column name, keys, data type, nullable information, etc.
· Displays information on objects such as procedures, functions, triggers, indexes, constraints, sequences, etc.
Built-in Database
· Requires no end-user configuration
· Get connected to a robust database right out of the box
· Uses the powerful HSQLDB database engine
Requirements:
· Java 1.4.1 or higher.
Limitations:
· 30-day trial
| Publisher | Richardson Software |
|---|---|
| Downloads | 2 |
| Requirements | 2008 13:21 |
| Date Added | 16th May, 2008 |
| File Size | 12.19 MB |
| Report | Send us a report |
| Reviews | Review RazorSQL 4.2.6 now |
| Rate this file |
