With RazorSQL you have the possibility to connect to any database you want, include multi-tabular display of queries and import data from various formats such as delimited files, Excel spreadsheets and fixed-width files.
RazorSQL is a SQL database query tool, SQL editor, database browser, and administration tool with support for all major databases and built in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite, and Sybase.
Here are some key features of "RazorSQL":
· 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
· a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and twelve other programming languages
· 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
· adds functionality with the API plugin
Limitations:
· 30 days trial
· Nag screen
What's New in This Release: [ read full changelog ]
Enhancements:
· 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
Changes:
· Made database name a required field when creating new PostgreSQL connections
Bugs:
· 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