RazorSQL 6.0

RazorSQL is an SQL query tool, database browser, SQL editor, and database tool
4 
Rating
Your vote:
Latest version:
9.4.6 See all
Download

Review

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 30 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more. 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. Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more.
Features:
- A Database Navigator for browsing database objects.
- An SQL Editor for creating SQL queries.
- Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences
- Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers
- 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.
- Export Tool - Export data in various formats
- Import Tool - Import data from delimited files, Excel files, or fixed width files into tables
- Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration
- A Generate DDL Tool for generating table, view, and index DDL.
- Table / SQL Query Compare tool for comparing tables or queries across multiple connections
- Database Data Search tool for searching single or multiple database table and view data.
- Database Object Search tool for searching for database objects.
- Backup tools such as the Database Backup Tool and Table Backup Tool
- Database conversion tools for many popular databases.
- Auto column and auto table lookup
- SQL Formatter
- SQL Query builder tool
- SQL Query Scheduler tool
- Command Line Interface
- PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers
- An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers

Videos and screenshots (12)

Comments (2)

User

Your vote:

J
Joe Razzinanine
It is nice that it supports so many databases - even ones on the cloud.

Was it helpful?  yes(0) no(0) | Reply
T
Not sure why this got a low rank from a user given they didn't give a reason. For environments with multiple DBMS systems and users on multiple OS platforms, Razor is tough to beat. I've now used it for MSSQL Server, Oracle, Greenplum, PostgreSQL, MySQL, and now MongoDB. It hooks up, runs, and does all of my syntax highlighting in any of these environments, no questions asked, right out of the box. And being able to keep my SQL IDE when crossing over from Windows to Linux Mint was great.

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.

Was it helpful?  yes(0) no(0) | Reply

Related software

Universal SQL Editor
Universal SQL Editor
rating

Write and execute SQL statements with this database query tool.

MySQL Workbench
MySQL Workbench
FREE
rating

Visual tool for database architects, developers and DBAs.

Toad for SQL Server - Freeware
Toad for SQL Server
FREE
rating

It is a productivity toolset for SQL Server administration and development.

dbForge Studio for MySQL
dbForge Studio for MySQL
rating

The universal MySQL and MariaDB client for database management.

Advanced Database Query
Advanced Database Query
rating

Allows execution of SQL statements on MS SQL Server, MySQL & Oracle databases.

Related suggestions