About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
See full specifications

windows default iconPortable RazorSQL Publisher's description

Query, Edit, Browse, and Manage Databases

The Portable RazorSQL application can help you query, update, navigate, and manage all major databases.

With Portable RazorSQL, an SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view tables, import and export data, build queries with a query builder tool, and navigate databases with the database navigator. It even comes with a built-in relational database engine that requires no configuration.

Here are some key features of "Portable 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, Paradox, Pervasive, Pointbase, Solid, and Teradata.
В· MySQL, PostgreSQL, and MS SQL Server PHP bridges for connecting to MySQL, PostgreSQL, and SQL Server databases via PHP. Allows remote access to MySQL, PostgreSQL or SQL Server databases running behind PHP enabled web servers
В· A MS SQL Server ASP bridge for connecting to SQL Server databases via ASP. Allows remote access to SQL Server databases running behind ASP enabled web servers
В· A RazorSQL JDBC Bridge for connecting to databases via a JEE/J2EE Application Server or Servlet Container

Database and SQL 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
В· Generate DDL Tool for generating table, view, and index DDL.
В· 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 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
В· Auto Completion for tables and columns
В· 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.
В· SQL Favorites for quickly and easily inserting commonly used queries into the editor
В· Key Ahead functionality for one-click population of user-defined text
В· Regular Expression 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 Browser:
В· 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.
В· Single-click generation of DDL for tables, views, and indexes.
В· Search tables and view data.
В· Single-click generation of SQL select, insert, update, and delete queries.

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

What's New in This Release:

· PostgreSQL Backup and Export Table tools - Now generate create sequence statements prior to the create table statements if a column references a sequence
· PostgreSQL Backup and Export tools - added option for whether to include serial columns in generated insert statements
· Added ability to view print output for Sybase SQL Anywhere and Sybase IQ
· Auto-detect certain statement separators for the Import from SQL file and Execute SQL script processes

· Made database name a required field when creating new PostgreSQL connections

· PostgreSQL Export / Backup Tools - Not generating DDL for serial columns correctly
· Edit Table Tool - When text has line breaks, text is getting formatted incorrectly in popup window
· Using keyboard shortcut with Shift on Mac causes action to occur twice in some instances

System Requirements:

· Java
Program Release Status: Minor Update
Program Install Support: Install and Uninstall

Portable RazorSQL Tags:

Click on a tag to find related softwares

Is Portable RazorSQL your software?

Manage your software

Most Popular

windows default icon Apache Tomcat 7.0.41
Apache Tomcat is an open source software implementation of the Java Servlet and JavaServer Pages technologies.... Read more
windows default icon WampServer 2.4
WampServer is a Windows web development environment.
windows default icon PS3 Media Server 1.81.0
PS3 Media Server is a DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose ... Read more
windows default icon TwonkyMedia Server 7.0.7
TwonkyServer makes it possible for your devices to retrieve your media files from wherever they're stored... Read more
windows default icon AnjLab.SqlProfiler 1.1.1423.75
The express edition of Microsoft SQL Server 2005/2008 is free.

Related Category

» FTP Servers (61)
» Mail Servers (122)
» News Servers (5)
» Web Servers (126)