 RazorSQL - 4.1 query, navigate, and manage all major sql databases (File Size: 12.0M) Current Version: 4.1 Release Date: 2007-11-06 License: Shareware Price: $49.95 Broken Link? Newer Version? Tell us! Product Description: 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. What's new in this version: * General: Added built-in navigator and connection support for Sybase SQL Anywhere * General: Added built-in navigator and connection support for Firebird * General: Added built-in navigator and connection support for Informix * General: Added built-in navigator and connection support for FrontBase * General: Added built-in navigator and connection support for OpenBase * General: Added built-in navigator support for Ingres * General: Added support for allowing spaces in databases, schemas, tables, columns, etc. for databases that support this type of naming * General: Added support for querying, modifying, etc. objects that have spaces in the name * Edit Table Tool: Enhanced look and feel, added toolbar, and increased editable space * Edit Table Tool: Added search functionality * Edit Table Tool: Added button to allow cell editing in new window * Edit Table Tool: Added replace and replace all functionality * SQL Editor: Make it so double-clicking a table cell brings up edit tool with the correct cell in editable mode * SQL Editor: Add edit menu item to query table context menu * SQL Editor: Add edit menu item to query results cell context menu * SQL Editor: Added toolbar to query results section with sort, filter, search, edit, re-execute, export, compare, view query options * SQL Editor: Added Row Count value to the status bar for queries executed with the "Fetch All Rows" action * SQL Editor: Enhance auto column lookup for pre from clause aliases for multi-table joins * Create Table Tool: Added engine type option (InnoDB, MyISAM) for MySQL * Create Table Tool: Added enumeration option for MySQL * Create Table Tool: Added ability to add Check constraints * Create Table Tool: Added identity / auto-increment for the major databases that support it. * Create Table Tool: Added default value * Create Table Tool: Added ability to add scale to decimal values * Create View Tool: Added schema dropdown to the create view tool * Alter Table Tool: Added scale and Not Null options to the Add Column section * Alter Table Tool: Added ability to add check constraints * Alter Table Tool: Added ability to select multiple columns for adding foreign keys * Alter Table Tool: Added ability to drop columns * Alter Table Tool: Added ability to drop constraints * Alter View: Added Alter View Tool * Added Query Scheduler tool to schedule queries for various intervals and number of executions and write the output to a file * Added Create Trigger Tool* * Added Edit Trigger Tool* * Added Drop Trigger Tool* * Added Drop View Tool* * Added Drop Table Tool * Added Drop Index Tool* * Added Create Index Tool* * Added Create Sequence Tool* * Added Drop Sequence Tool* * Added Drop Procedure, Function, Package, and Package Body Tool* * Informix: Added support for viewing, creating, and editing procedures, functions, and triggers * Ingres: Added support for creating, editing, and dropping procedures * SQL Anywhere: Added support for creating, editing, and dropping triggers and procedures * Firebird: Added support for creating, editing, and dropping triggers and procedures * Derby: Added support for creating and dropping triggers * Connection Wizard: Auto JDBC URL configuration added for Firebird, FrontBase, Ingres, Daffodil DB, Mckoi, MimerSQL, Pointbase, Teradata, and Informix * Connection Wizard: Added create=true onto derby and daffodil connection urls * Connection Wizard: Added Embedded option for Daffodil DB / One$DB * Connection Wizard: MySQL: Automatically add the ?noDatetimeStringSync=true for MySQL Connector/J 3.1.7 or later. * Connection Wizard: Added download button for JDBC drivers for Ingres, MimerSQL, Pervasive, and Teradata. * Tools: More databases now prepopulate the current database and/or schema on dropdowns * Database Navigator: Added additional Create, Alter, and Drop options * Database Navigator: MySQL - Added View DDL option for tables and views * Database Navigator: SQLite - Added View DDL option for tables, views, indexes, and triggers * Database Navigator: Oracle - Added View DDL option for tables, views, indexes, constraints, sequences, materialized views, procedures, function, packages, package bodies, and triggers * Database Navigator: OpenBase - Added triggers and users * Database Navigator: FrontBase - Added functions * Database Navigator: HSQLDB - Added indexes for table and users * Database Navigator: Ingres - Added indexes and sequences * Database Navigator: SQL Anywhere - Added indexes and triggers * Database Navigator: Firebird: Added functions, triggers, indexes, sequences, and users * Database Navigator: Derby - Added indexes and triggers * Database Navigator: Informix - Added functions, triggers, indexes, and users * Database Navigator: Enhanced Database Navigator filter for databases with built in support * SQL Explain Plan: Added support for SQLite * Query Builder: auto-wraps columns with single quotes, etc. that need wrapping * Query Builder: Supports multiple tables in select and auto-generates join clauses Operating System Requirements: This product is designed to run on the following operating systems: * Mac OS X 10.5 Intel * Mac OS X 10.5 PPC * Mac OS X 10.4 Intel * Mac OS X 10.4 PPC * Mac OS X 10.3.9 * Mac OS X 10.3 * Mac OS X 10.2 Additional Requirements: * Java 1.4 or higher Screenshots:
|
