Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Database .NET is a powerful and intuitive multiple database management tool. The program allows the administration of local or remote databases to browse objects, design tables, edit rows, export data, create new databases, and run queries with a consistent interface. The program includes table/data editor, index editor, syntax highlighting, SQL profiler, code manager, and multiple query tabs.

Supported databases include SQL Server, SQL Azure, Firebird, SQLite, MySQL, PostgreSQL, Oracle, IBM DB2 and Informix, Sybase ASE, MS Access and Excel, dBase IV, FoxPro, Data Sources, ODBC DSN, and OData. Can export to CSV, XML, TXT, XLS, or SQL Print Query Results.

License:    Free for personal or non-profit use

Changelog

- The main program update ( the Main ):
Add: increase substituted row ( the Replace the In the Grid ): Batch replace data cell data (Batch replacing cell values) (6078 )
Upd: Improved search row ( the Find the In the Grid ): change the current location as the starting point of search (6078)
Upd: (Oracle) objects to perform [automatic identification] with the need SchemaName treatment can avoid ORA-06550 / PLS-00302 error problem (6078)
Upd: Improved connection settings ( the Connection Profile ): support for more databases and more complete connection Property Description (6078)
Upd: Improved uncomment (Uncomment): 1. Support multi-line annotations /*...*/ cancellation process, 2. Improved single-line comments - the cancellation process, when the starting character is empty (6078)
Upd: Cumulative contain other minor updates, fixes and optimization (6078)
- Advanced View / Edit option ([ADV] Advanced Browsing / the Edit the Options):
Fix: automatically ( Auto Completion ): Fixed field names exactly matching process (6078)
- Query Design Tools ( Query Builder )
Fix: Automatic correlation table added: Fix field names exactly matching process (6078)
- Automatically and perception ( the AutoComplete and IntelliSense * ):
Fix: Fixed table, fields, keywords, etc. name exactly matching process (6078)
- Data Definition Language ( the Data Definition! Language (the DDL) ):
Fix: (SQL Server / SQLAzure / SybaseASE) Fixed index UNIQUE + NONCLUSTERED, the resulting omissions UNIQUE key issues (6078)
- Database Migration ( Database Migration ) (Pro):
Upd: Updated with all dbMigration .NET Software (6078)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Fix: Fixed (6078) after the update cause exceptions (*
Add: increase substituted row ( the Replace the In the Grid ): Batch replace data cell data (Batch replacing cell values)
Upd: Improved search row ( the Find the In the Grid ): change the current location as the starting point of search
Upd: (Oracle) objects to perform [automatic identification] with the need SchemaName treatment can avoid ORA-06550 / PLS-00302 error problem
Upd: Improved connection settings ( the Connection Profile ): support for more databases and more complete connection Property Description
Upd: Improved uncomment (Uncomment): 1. Support multi-line annotations /*...*/ cancellation process, 2. Improved single-line comments - the cancellation process, when the starting character is empty
Upd: Cumulative contain other minor updates, fixes and optimization

ADVANCED VIEW / EDIT OPTION ([ADV] Advanced Browsing / the Edit the Options):

Fix: automatically ( Auto Completion ):

Fixed field names exactly matching process QUERY DESIGN TOOLS ( Query Builder )
Fix: Automatic correlation table added: Fix field names exactly matching process

AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):

Fix: Fixed table, fields, keywords, etc. name exactly matching process

DATA DEFINITION LANGUAGE ( the Data Definition! Language (the DDL) ):

Fix: (SQL Server / SQLAzure / SybaseASE) Fixed index UNIQUE + NONCLUSTERED, the resulting omissions UNIQUE key issues

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

Fixed bug: ESEDatabaseView crashed when using the find option while the last item was selected.

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Changelog

Result set UI was redesigned (panels)
Results aggregation panel added
Navigator filters management was improved
ERD attributes view is now configurable (data type, icon, nullability)
Object editor breadcrumbs UI was redesigned
Advanced results copy was improved (row divider)
Results metadata resolve was fixed (problem with SQL expressions was resolved)
Run query from Query Manager view
Enum data type editor was fixed
Data export (CSV, XML and JSON) was fixed
DBeaver projects export/import was fixed
SQL parameters binding dialog was fixed
SQL parser was updated (performance problem with complicated queries was resolved)
SQL code completion now uses navigator filters
DDL generation was improved (multiple objects support)
Plaintext presentation was fixed (column reorder)
SOCKS proxy support was improved (PostgreSQL)
Support system variables in driver.xml file
Oracle: TNS connection fixed
Oracle: TNSNAMES custom path support
PostgreSQL: struct data types support was fixed
PostgreSQL: objects lookup was fixed
MySQL: single line comments were fixed
Many minor bugfixes and improvements

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

MANAGEMENT CODE:
Add: Custom SQL file location ( the Specifying at The LOCATION of SQL Files ): support the specified SQL file location
MAIN PROGRAM UPDATE:
Add: (ODBC / OleDB) increase function object (FUNCTIONS): with a view / perform other functions ...
Fix: When (ODBC / OleDB) If the amended database contains SCHEMA (VIEWS / PROCEDURES) and other objects loaded incomplete question
Fix: (FoxPro) to solve the data table contains time increments (AUTOINC) field-related issues: with a table reconstruction and data export functions ...
Add: (SQL Azure 12) increase the sequence object (SEQUENCES): with a view / execute / delete / script generation ... and other functions
Upd: (SQL Azure 12) updates object (PROCEDURES) script generation and execution process: Increase the return value display processing
Upd: (SQL Server / SQL Azure ) supports the table value function object (TABLE-VALUED FUNCTIONS) script generation and execution process
Fix: Fixed in the next multi-screen apps open part of the main sub-functions in a non-main window, the problem will still be displayed in the main window
Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.1.0.0 (2016/08/29)
Upd: Cumulative contain other minor updates, fixes and optimization
DATA DEFINITION LANGUAGE:
Upd: (SybaseASE) script to generate VIEWS / TRIGGERS / PROCEDURES / FUNCTIONS other objects match the name of [schema] [objectname] is displayed
Fix: This update to resolve joint name of the original object within the definition of inconsistencies due to renamed objects

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

SECURITY ADMINISTRATOR (DATABASE TOOLS: SECURITY MANAGER):
Add: Added user authorization process ( Managing the User the Permissions ): Support comprises: SQL Server / MySQL / Oracle / PostgreSQL / Firebird 3.0 + / IBM DB2
Add: Added role permissions setting process (Managing Role Permissions): Support comprises: IBM DB2
Add: Join a user password to change the setting (Changing Password): Support comprises: SQL Server / MySQL / Oracle / PostgreSQL / Teradata / Vertica / NuoDB / Firebird
Add: Join the user's password expiration settings (Password Expiration): Support comprises: SQL Server / MySQL 5.7.6 + / Oracle 12 + / PostgreSQL / Vertica
Add: support more users lock setting (Account locking): Support comprises: SQL Server / MySQL 5.7.6 + / Oracle / PostgreSQL / Vertica / SybaseASE
THE MAIN PROGRAM UPDATE:
Upd: Database Tools (Database Tools): Move to the previous menu and the main task bar, display more intuitive and simpler operation
Add: (Firebird) support to bind parameter function execution process ( the Binding the Parameters Function )
Upd: (Firebird) resumes execution function (FUNCTION) instruction code generation ( SCRIPT the AS -> the SELECT )
Upd: (ODBC / OleDB) script generates multiple right-click menu disable status update
Upd: Cumulative contain other minor updates, fixes and optimization
Misc: the with Compatible the MySQL 5.7.15 (2016/09/06) / the MySQL 5.6.33 (2016/09/06) / the MySQL 5.5.52 (2016/09/06)
Misc: the with Compatible the HP Vertica 8.0 (2016/09/10)
SQL HISTORY RECORDS:
Add: increase untyped (Undefined Type) manually clear the historical record processing
Upd: Update not performed tag [after Close] to save the process, are excluded from the [External File] to open the content in order to reduce unnecessary treatment record
DATA DEFINITION LANGUAGE:
Upd: (MySQL) table object is generated (TABLE): Reset attribute AUTO_INCREMENT = 1
Fix: (Firebird) function to generate the object program (FUNCTION / PROCEDURE): Take solve change when VARCHAR does not include the length of the field Length Shows
Fix: (Firebird) function generates object (FUNCTION): Fixed CHARACTER SET is not fully correct the problem specified
Upd: (Firebird) program generates object (PROCEDURE): increase in the processing and DEFAULT CHARACTER SET's

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Freeware

Whats new: >>

Export speed increased up to 2 times for most of export formats.
Minor bugfixes in expression calculation engine.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Improved support for using the STDCALL calling convention in winsqlite3.dll.
Fix the sqlite3_trace_v2() interface so that it is disabled if either the callback or the mask arguments are zero, in accordance with the documentation.
Fix commenting errors and improve the comments generated on EXPLAIN listings when the -DSQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option is used.
Fix the ".read" command in the command-line shell so that it understands that its input is not interactive.
Correct affinity computations for a SELECT on the RHS of an IN operator. Fix for ticket 199df4168c.
The ORDER BY LIMIT optimization is not valid unless the inner-most IN operator loop is actually used by the query plan. Fix for ticket 0c4df46116e90f92.
Fix an internal code generator problem that was causing some DELETE operations to no-op. Ticket ef360601

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

Search UI was redesigned (standalone version)
Search in files (SQL) was added
Value view panel: save and auto-save command were fixed. UI was fixed.
SQL autocomplete was fixed
Generate SQL from results: row order was fixed
CSV export was fixed (values quotation)
Navigator filters edit/update was fixed
MySQL: trailing SQL comments issue was fixed
MySQL: index prefix (sub part) support was added
MySQL: tables copy/paste feature was added
MySQL: auto-complete was fixed (use current schema for objects search)
PostgreSQL: materialized view indexes support added
PostgreSQL: views source code formatting fixed
PostgreSQL: array type handler fixed
PostgreSQL: data type aliases support was added
PostgreSQL, MS SQL: DROP INDEX was fixed
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- The main program update ( the Main ):
Add new Firebird database-specific connection settings ( New Firebird Connection Profile ) (6109)
Add: Support Windows login authentication mode (Windows authentication (Win_Sspi)) ( 6109)
Add: Support for individual library to a different user account login process (6109)
Add: Support Custom Port Settings (6109)
Add: Support Connection test process (6109)
Upd: additional connection property is set far more intuitive (6109)
Upd: Merge Local and Remote settings to simplify the processing (6109)
Upd (Firebird) database coding automatic setting processing (Automatically set charset): supports remote database (Remote database) detection process (6109)
Upd: (Oracle) update DBMS_OUTPUT outgoing messages and displays the number of columns limit from 16-1024 (6109)
Upd: Oracle component version update to Oracle.ManagedDataAccess.dll 12.1.24160719 (2016/09/17) (6109)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.103.0 (3.14.2) (2016/09/15) (6109)
Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.1.1.0 (2016/09/13) (6109)
Upd: SQLCe v4 elements updated to the SQL Server Compact 4.0 SP1 Hotfix (4.0.8902.1) (2014/06/10) (6109)
Upd: Cumulative contain other minor updates, fixes and optimization (6109)
- Automatically and perception ( the AutoComplete and IntelliSense * ):
Upd: Optimization table analysis processing to enhance the field perception (6109)
- Database Migration ( Database Migration ) (Pro):
Upd: Updated with all dbMigration .NET Software (6109)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Aggregate functions: Distinct count, Min/Max for non-numeric types, Mode and Median functions were added
MetaData panel was added in result panels
Results filters/ordering improvement (support of joins)
Data transfer: columns mapping was fixed (now support columns skip), BIGINT datatype support was fixed
MetaData compare wizard was fixed (PG)
JSON and XML support in value editor
Value edit panel: misc fixes (gtk)
ER diagrams: entity/attributes colors were fixed
Attributes binding performance increased
SQL completion processor was fixed
Multi-project workspaces support was improved
PostgreSQL: view and materialized view edit, a few metadata additions
MySQL: by default uses 5.x drivers to avoid problems with server charset
Oracle: metadata reading was improved
SQL Server: table data viewer fixed (use fully-qualified table name)
RedShift: driver update (+ support of LIMIT in table queries)
A lot of minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Improvements in Sub-release V.3.0.1:

IMPROVEMENT: The statement CREATE OR ALTER USER SYSDBA PASSWORD can now be used to initialize an empty securityN.fdb security database.
IMPROVEMENT: Nesting of keys in a plug-in configuration was enabled.
IMPROVEMENT: For URL-like connection strings on Windows, restriction of lookup to IPv4 only was enabled.
IMPROVEMENT: Line and column numbers (location context) are now provided for runtime errors raised inside EXECUTE BLOCK.
IMPROVEMENT: A switch was added to build POSIX binaries with a built-in libtommath library.
IMPROVEMENT: gbak now returns a non-zero result code when restore fails on creating and activating a deferred user index.
IMPROVEMENT: Implicit conversion between Boolean and string is now done automatically when a string for 'true' or 'false' is used as a value in an expression. Case-insensitive. Not valid when used with a Boolean operator—IS, NOT, AND or OR; not available for UNKNOWN.

Firebird 3.0.1 Release: Bug Fixes:

Core Engine:

XpbBuilder was failing to create a new TPB.
LEFT JOIN would incorrectly push a UDF into the inner stream, causing wrong results.
A user-defined collation failed to work with BLOBs.
An assertion could occur in createDatabase() when doing the overwrite check.
A subquery in the insert list expression was ignoring changes made earlier in the same executable block.
A database could suffer partial corruption in the “use all space” (no-reserve) mode.
BUGCHECK 165 (cannot find tip page)
Cascade deletion in a self-referencing table could raise the error “no current record for fetch operation”.
A “Data type unknown” error was occurring with the LIST operation.
Random “invalid transaction handle” errors were being returned from the engine.
ON UPDATE CASCADE was failing for a self-referencing Foreign Key.
REGRESSION: Performance was degraded when bulk inserting into a table with indices.
Trying to encrypt a database in the absence of the the appropriate key could corrupt it.
A small memory leak could occur when an empty result set was returned.
Granting of privileges to views was broken.
Parameters with multi-byte character sets were being allowed to exceed the length limit for VARCHAR fields.
Expression index could become inconsistent if CREATE INDEX was interrupted after b-tree creation but before committing.
Nested OR conditions could lead to incorrest results.
Consistency between roles and privileges in GRANT syntax needed improving in accordance with the SQL standard.
An attempt to execute a SELECT statement using isc_dsql_execute_immediate() would produce the wrong error message.
Affected rows were not being counted for some update operations with views.
IN/ANY/ALL predicates could cause sub-optimal execution (late filtering) of joins.
Unaligned memory access in MET_format() would cause segfault on big-endian machines.
32-bit locks on big-endian systems would lead to deadlock.
EXECUTE STATEMENT would throw a BLR error if the number of output parameters exceeded 256.
An incorrect result set (missing records) could be returned by an ORDER plan query navigating on a descending index.
Authentication was ending with first plug-in that had the user but would fail there, instead of continuing with the next plug-in.
SELECT WITH LOCK could raise unexpected update conflict errors under concurrent load.
A database could get decrypted after changing a couple of bytes in the database header without 'agreement' from the crypt plug-in.
POST_EVENT was not working with the Fb 3.0 server and client.
The operator IS exhibited a precedence problem.
REGRESSION: line/column numbering in error messages were being garbled if alias.name syntax was used in the offending statement.
The error “no current record to fetch” was thrown if some record was to be deleted both by the statement itself and by some trigger fired during statement
An expression index could be created while inserts into the table were in progress.

Server Crashes:

Access violation from certain UDFs would cause the server to crash.

API/Remote Interface:

Race conditions could arise when initializing wire compression.
A network protocol error was exhibited when performing a callback to a client for the database crypt key.
Some SPB parameters were failing in FB 3.0.
Transaction id tags for the Services API did not support new 48-bit transaction ids.
The Services API would not work with non-ASCII database names.

Utilities:

fbsvcmgr was not producing any error when it attempted to shut down a database without a specified timeout (prp_force_shutdown N).
Restore could hang if the database contained more than 4 billion records.
Validation could read after the end-of-file when operating on a multi-file database.
The BLOBVIEW command was causing isql to hang.
isql would leak memory when SHOW GRANTS was used on a new, empty database.
isql -[e]X[tract_metadata] output was omitting double quotes for the COLLATE clause of a CREATE DOMAIN statement when was for any non-ascii character set.
isql -[e]X[tract_metadata] was not exporting explicitly defined names for NOT NULL constraints for Dialect 3 databases.
isql -[e]X[tract_metadata] could crash while exporting an exception with message text length longer than 127 bytes.
isql -[e]X[tract_metadata] could generate invalid GRANT USAGE statements for domains.

Monitoring and Trace:

A string truncation error would occur while selecting from the MON$ tables if some user-defined context variable was longer than 255 bytes.
A trace session could fully utilize a single CPU core.

nBackup:

A database located on a raw device could not be unlocked from an nBackup-locked state.

Builds:

Databases created during the process of the Windows builds were owned by a Windows administrator, not SYSDBA.
Firebird failed to build with USE_VALGRIND

[close]

http://www.firebirdsql.org/

[SiLæncer]

Changelog

The main program update ( the Main ):

Add: Support Firebird 3+ show complete implementation plan ( the Execution Plan for 3 or later The Firebird ) (6118)
Fix: (Firebird) Correction (6109) result that has been set Embedded Server / Remote Type settings such useless questions (6118)
Upd: Improved Message dialog text display limitations (

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

# Major enhancements include:

* Parallel execution of sequential scans, joins and aggregates.
* Avoid scanning pages unnecessarily during vacuum freeze operations.
* Synchronous replication now allows multiple standby servers for increased reliability.
* Full-text search can now search for phrases (multiple adjacent words).
* postgres_fdw now supports remote joins, sorts, UPDATEs, and DELETEs.
* Substantial performance improvements, especially in the area of scalability on multi-CPU-socket servers.

[close]

http://www.postgresql.org/

[SiLæncer]

Changelog

- The main program update ( the Main ):
Add: Object Design Options (DESIGN) adding a new (CREATE) sub-options, easy to move without direct object the establishment belongs [female] node (6125)
Add: update insert text (Insert Text) project to increase the sub-option to copy text functions (Copy to Clipboard: Ctrl + C ) (6125)
Add: (PostgreSQL) incorrect information increases [details] display (Error detail message) (6125)
Upd: (PostgreSQL) to rewrite the Foreign Keys made way to solve possible problems (6125)
Upd: Improvement and correction Firebird overall connection settings related problems (6125)
Upd: Remove script to generate INSERTs Export INSERTs avoid confusion duplicated (6125)
Upd: Improved User Experience: UI update multiple amendments and simplify the processing (6125)
Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.5.0.0 (2016/10/05) (6125)
Upd: Cumulative contain other minor updates, fixes and optimization (6125)
- Delimited text file ( Delimited the Text ):
Add: Support custom delimited text file with the filename extension ( the Custom Delimited File Extensions ) (6125)

[close]

http://fishcodelib.com/Database.htm