инструмент для работы с SQL базами, SQL query tool
Дата публикации:
PRYANIK, 22.01.2018 - 13:31
Richardson Software RazorSQL
описание (rus)RazorSQL - это инструмент запросов SQL, браузер базы данных, редактор SQL и средство администрирования базы данных для Windows, Mac OS X, Linux и Solaris.
RazorSQL предоставляет как простые в использовании визуальные инструменты, так и расширенные функции, позволяющие пользователям выполнять просмотр, редактирование, управление, администрирование и программирование баз данных.
Особенности RazorSQL:
Навигатор базы данных для просмотра объектов базы данных;
Редактор SQL для создания SQL-запросов;
Визуальные инструменты для создания, редактирования, удаления, описания, изменения и просмотра таблиц, представлений, индексов и последовательностей;
Visual Tools для создания, редактирования, удаления и выполнения хранимых процедур, функций и триггеров;
Прочный редактор программ, который включает мощный редактор кода EditRocket, который поддерживает 20 языков программирования, включая SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML и т.д.;
Export Tool - экспорт данных в различные форматы;
Инструмент импорта - импорт данных из файлов с разделителями, файлов Excel или файлов с фиксированной шириной в таблицы;
Корабли со встроенным механизмом реляционных баз данных (HSQLDB), который запущен и запущен из коробки и не требует администрирования конечных пользователей;
Генерировать DDL-инструмент для генерации таблицы, просмотра и индексации DDL;
Инструмент сравнения таблиц/SQL-запросов для сравнения таблиц или запросов по нескольким соединениям;
Инструмент поиска данных базы данных для поиска одной или нескольких таблиц базы данных и просмотра данных;
Инструмент поиска объектов базы данных для поиска объектов базы данных;
Инструменты резервного копирования, такие как средство резервного копирования базы данных и инструмент резервного копирования таблиц;
Инструменты преобразования баз данных для многих популярных баз данных;
Автоматический поиск столбцов и автоматических таблиц;
SQL Formatter;
Инструмент SQL Query builder,
Инструмент SQL Query Scheduler;
Интерфейс командной строки;
Мосты PHP для подключения к базам данных MySQL, PostgreSQL и SQL Server удаленно через веб-серверы с поддержкой PHP;
Мост ASP для удаленного доступа к базам данных MS SQL Server через веб-серверы с поддержкой ASP;
SQL GUI Tools для генерации SQL для различных операций;
Редактировать, удалять и вставлять данные базы данных в Редактор базы данных;
Работает со всеми основными операционными системами, включая Windows, Mac OS X, Linux, Solaris и любую другую Java-совместимую ОС;
Тестирование с помощью 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 и Teradata.
» Нажмите, для открытия спойлера | Press to open the spoiler «
»» Нажмите, для закрытия спойлера | Press to close the spoiler ««
description (eng)RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.
RazorSQL 9 has been tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases: Athena, H2, MongoDB, Salesforce, Aurora, Hive, MonetDB, SimpleDB, Cassandra, HSQLDB, MS, SQL, Server, solidDB, DB2, Informix, MySQL, SQLite, DBASE, Ingres, Netezza, SQL, Anywhere, Derby, Interbase, OpenBase, SQL, Azure, Druid, Int.Sys., Cache, Oracle, Sybase, (ASE), DynamoDB, JavaDB, Paradox, Sybase, IQ, Filemaker, MariaDB, Pervasive, Teradata, Firebird, Microsoft, Access, PostgreSQL, Vertica, Frontbase, Mimer, SQL, Redshift, VoltDB, Greenplum
Features RazorSQL 9
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 such as MySQL, Oracle, DB2, PostgreSQL, SQLite, MS SQL Server, and MS Access.
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, macOS, Mac OS X, Linux, Solaris, and any other Java enabled OS
Import Tool: When importing from XLSX files, if cell format is not set to scientific notation, values get converted from scientific notation to regular numbers Query Results to the Same Tab: Queries that don't return results no longer take up space in the query results section Query Results to the Same Tab: Better setting of columns widths after the first result set
Enhancements Added support for Couchbase Navigator / Database Browser Filter: Allow comma separated values in the contains and not contains fields Added a Connections -> New Tab (New Connection) menu option to the Connections main menu and context menu Added a Connections -> New Tab (Copy Editor) menu option to the Connections main menu and context menu Added a Connections -> Same Tab (Switch Connection) menu option to the Connections main menu and context menu Added New Session (New Connection) and New Session (Copy Editor) options to the new button popup Added support for Derby 10.15 for supported operating systems. NOTE: Linux 32-bit and legacy Mac OS X versions do not support Derby 10.15 Copy Table to Another Database: Added a Generate Alter Table checkbox. If checked foreign keys are attempted to be assigned via alter table statements Changes Linux 64-bit: Updated Java Runtime Environment to version 11 macOS (Catalina and Mojave version): Updated Java Runtime Environment to 11.0.5 Windows 32-bit and 64-bit: Updated Java Runtime Environment to 11.0.5 Editor Auto Save. If user closes an unsaved file and auto save is on, still prompt if the user wants to save the file Export Numeric Formatting Changes: If exporting query results (SQL, Delimited File, XML, HTML, Text): Formatting used is based on query results preference values for Locale options (primary) and decimal separator (if locale option not set) If exporting query results (XLS, XLSX): No formatting is used. Locale specific preferences within Excel determine how the cells are formatted If exporting from table(s): Numeric formatting is based on Number Format locale selected on the export window with the default being no specific formatting SQL -> Recent Queries menu options: Order is now based on order the statement was executed not just the timestamp when the statement was executed DynamoDB: Scan Requests with where clauses: For tables that have more rows than the "Max Results Per Query" value set on the RazorSQL connection profile, RazorSQL will continue to scan the table until either more rows than the Max Results Per Query value are returned, or there are no more rows to scan MySQL and MariaDB connections, autoReconnect property is now set to true by default Keep Alive: Default keep alive interval changed from 4 minutes to 2 minutes Keep Alive Preference: Added an option for 0.5 (30 seconds) to the keep alive interval Bug Fixes
Enhancements PostgreSQL: Added support for procedures Amazon Redshift: Added support for procedures Amazon Redshift: Added support for connecting via AWS credentials files Changes PostgreSQL Create User: Added support for the create role option Database Conversion: SQL Server to Oracle and vice-versa. Converter converts default values of GETDATE() to SYSDATE and vice-versa RazorSQL log file size capped at 1 GB Added a preference for max SQL History database size in megabytes Bug Fixes
Import Tool: Copies of Excel files are created and opened for reading to prevent out of memory situations from corrupting original Excel file Import Tool: Improved performance when importing from XLSX files Upgraded Apache POI Excel library to version 4.1.1 Bug Fixes
Enhancements Query Results: Added the following options to the right-click menu of each results column and to the results menu: Average Values in Column, Count Values in Column, Count Distinct Values in Column, Max Value in Column, Min Value in Column, Sum Values in Column DynamoDB: Added the abilty to query against nested maps up to 5 layers deep using SQL syntax Example query: select * from test_nested_map where outermap.innermap.innermap2.height = 60; outermap, innermap, and innermap2 are all maps in this example DynamoDB: Added the ability to use syntax similar to the AWS command line for table scans. See RazorSQL DynamoDB SQL Support for details Compare Tool: Improved performance Added new DynamoDB scan expression and SQL syntax templates Bug Fixes
Changes javascript Validator: Leading line feeds in text can cause an issue with the validator Snowflake to Local Database Conversion: Number data type conversion is now supported Salesforce: The All Rows syntax in queries is no longer case sensitive Database Object Search: Added a View Contents right-click option for column name search results Upgraded Cassandara datastax driver to version 3.8.0 Upgraded BigQuery driver to version 1.2.2.1004. This fixes an issue with numeric columns not being able to be queried Bug Fixes
Enhancements Query Results: Added the ability to sum, average, find mininum, and find maximum for selected cells only in addition to all cells Firebird: Create Database Tool and Add Connection Tool: Added the ability to create Firebird version 4 / ODS version 13 database files File System Browser and Project Browser: Added right-click menu option for Open File Share Connection File System Browsser and Project Browser: If there are active database connections, double-clicking a file prompts for whether to open the file and share a current connection Added support for Yellowbrick Changes BigQuery Database Browser: Only datasets under a particular project are shown in the project's tree BigQuery Database Browser: SQL generation now includes the project id in the generated SQL Toolbar: Show File System Browser button is now shown on the toolbar by default Linux: Web browser display: If x-www-browser is available, this command is used to open web browsers on Linux systems Bug Fixes
Enhancements Added a Tools -> URL Encoder tool Added a Tools -> URL Decoder tool Database Object Search: View Contents on a column name now scrolls to and selects the first row in that column in the query results Amazon Athena: Added the ability to generate DDL for views Changes Amazon Athena Database Browser: Object types are now set to Tables and Views. Tables are listed in Tables section and Views are listed in Views section Amazon Athena: Generate Table DDL now uses output from the show create table command Bug Fixes
Changes Import Tool: Importing from a saved profile no longer pre-populates the delimited file end row. The last row of the file is assumed by default SQLite: Added a Change File button for quickly changing the SQLite database file on an existing SQLite connection profile Oracle Database Browser: Changed default query to get all schemas Bug Fixes
Enhancements Import Tool: Delimited Files: Added support for the following date formats for Date columns in addition to yyyy-MM-dd: MM/dd/yyyy (06/22/2020) M/d/yyyy (6/2/2020) MM/dd/yy (06/02/20) d-MMM-yy (2-Jun-20) Import Tool: Added support for generating insert statements that have multiple rows of values per one statement to reduce overhead for MySQL, PostgreSQL, SQL Server, Derby, DB2, and Athena Changes Import Tool: Blank rows in spreadsheets and delimited files are now skipped Import Tool: XLSX Files: Importing cells with formulas is now supported Import Tool: Enhanced the process for guessing column types and sizes when creating a table during the import process Import Tool: If first row of file being imported looks to be column names, the start row of the file will be set to row 2 instead of row 1 Athena Export Tool: Added support for generating SQL statements in multiple rows per one insert statement syntax Oracle: For new installs, default to showing all schemas instead of non-empty schemas. Empty schemas can be hidden by the Edit -> Preferences -> Database Browser -> Oracle: Hide Empty Schemas in Database Browser checkbox Oracle Editor: Added more line number detail to Oracle query errors
Enhancements Import Tool: Added ability to change the delimiter / line break escape character to something other than double quote Import Tool: Added option to forego delimiter / line break escaping Added an execute SQL button on generate SQL popup window DynamoDB Database Browser: Changed Row Count option to the following Row Count (Estimate): This method gets the row count from the DynamoDB table meta data. This count is updated by DynamoDB every 6 hours Row Count (Full Scan): This method scans the whole table to get the row count. This method uses more resources to get the count Changes Execute Procedures: Errors that occur in a procedure are displayed even if the procedure was able to return results prior to the error. Previously the error was not reported Local Database / HSQLDB: create table tool defaults creating tables as cached (on-disk) tables instead of in-memory. Memory tables can be created by selecting the Memory option in the Table Type drop-down Bug Fixes
Enhancements Added support for Amazon AWS Keyspaces Cassandra: Added the ability to set the consistency level on the connection when creating a new Cassandra connection. The consistency can be set by clicking the Configure button next to the Conn. Properties field. Added an Edit -> Move to First Visible Line (control / command + page up) menu option for moving the cursor to the first visible line in the editor Added an Edit -> Move to Last Visible Line (control / command + page down) menu option for moving the cursor to the last visible line in the editor Query Results Tab Right-click Menu: Added a Copy Selected Column Names and Results to Clipboard option Results: Added an Arrange Columns in Alphabetical Order option to the Results menu and Results tab right-click menu Results: Added a Goto Column option to the Results menu and Results tab right-click menu Changes Cassandra: Database Browser now reloads automatically when creating a new table Mac: macOS Big Sur: Display changes to better support Big Sur Selected text is no longer moved when using tab or shift+tab if control/command key is pressed Bug Fixes
RazorSQL 9.2.1 + crack (ключ) Enhancements - Export Tool: Export Delimited Filess: Option to set escape character to something other than double quote - Export Tool: Export Delimited Files: Added option to wrap everything in escape character - Cassandra 3x DDL Generation: Added support for generating with clustering order by clauses to generated table DDL Changes - Database Conversion: SQL Server to H2 conversion: newid() in default column values is now converted to random_uuid() Bug Fixes
Enhancements DynamoDB: Added support for inserting / updating data to columns with a list data type. NOTE: Data must be in a valid JSON format DynamoDB: Added support for the SQL drop table statement Bug Fixes
Changes macOS version: Upgraded included JRE to 11.0.9 Bug Fixes macOS version: Possible RazorSQL crash when connecting or disconnecting external displays HSQLDB to SQL Server Table Conversion: Converting tables in the HSQLDB PUBLIC schema throws an error