

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.Ĭhanges Added support for using the PostgreSQL pgpass file format when authenticating JDBC connectionsAdded support for using a password file (a file containing nothing but the password) when authenticating JDBC connectionsDatabase Conversion: When converting to MySQL / MariaDB, added the ability to choose the generated SQL insert type Added Test Connection call to DB Tools -> Command Line Call GeneratorAdded Connect call to DB Tools -> Command Line Call GeneratorInformix: Added the ability to set the DBDATE connection property for setting the date formatSQL Server: DDL Generation: create index statements no longer generated for default primary key indexes when generating table DDLFirebird to PostgreSQL Table Conversion: Double and Float columns now get converted to PostgreSQL double precision columnsSalesforce: Comments are stripped from queries automaticallySQL Server: Alter table add column not supporting entering max for column lengthEdit Table Tool: If sort query results preference is set to true, causes problems with the edit table toolPostgreSQL: IN_OUT parameters not supported in the call procedure toolCall Procedure Tool: Error messages are not always displaying to the screenĬhanges Added the ability to set a client timezone via the Preferences -> Query Results Tab. 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 twelve other programming languages.

RazorSQL ships with a built in relational database engine that is up and running out of the box and requires no end user administration. Any other JDBC or ODBC (Windows only) compliant database is also supported. 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, SimpleDB, SQL Anywhere, SQLite, SQL Azure, and Sybase.
