RazorSQL 5.5.2

Richardson Software RazorSQL – программа для управления основными базами данных внутри одной программы. Программа позволяет запускать SQL запросы, визуально редактировать, создавать, изменять и просматривать таблицы, импортировать и экспортировать данные, создавать запросы в программе создания запросов и просматривать базы данных в навигаторе баз данных. Программа также содержит встроенную реляционную базу данных, которая не требует никаких настроек. RazorSQL работает со всеми популярными базами данных, включая MySQL, PostgreSQL, InterBase, Firebird, Oracle, SQLite, SQL Anywhere, Sybase, MS SQL Server, DB2, Derby, FrontBase, JavaDB и многие другие.

Особенности программы:

• 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
• 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
• SQL GUI Tools for generating SQL for various operations
• Edit, delete, and insert database data with the Database Editor
• Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS
• Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB / HyperSQL, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata

What's New in This Release:

Enhancements

• Import Tool: Added insert or ignore and replace syntax options for statements generated by the import tool for MySQL and SQLite
• Export and Backup Tools: Added insert or ignore and replace syntax options for statements generated by the export and backup table and database tools for MySQL and SQLite
• Export and Backup Tools: Added option to generate multi-value / multi-row insert statement syntax instead of one insert statement for each row being inserted for Derby, DB2, MySQL, PostgreSQL, and SQL Server
• Improvements to load time performance
• Added Window - Focus in database navigator option to the Window menu
• Added Tools - PHP - Execute Program option
• Added Tools - PHP - Check Program Syntax option
• Added Tools - Perl - Check Program Syntax option
• Added Tools - Ruby - Check Program Syntax option

Changes

• Added validation to the import and export tool to require a database and / or schema to be entered if required by the database

Bug Fixes

• Oracle database navigator loads slowly on some systems
• Control-click does not bring up context menu on Mac for the database browser
• Windows context menu keyboard key does not bring up the context menu
• Comments in front of a query can cause edit table tool to remove the where clause when launching

Скачать программу RazorSQL 5.5.2 (32,08 МБ):