Thema: Datenbanksoftware und Tools diverses ...

[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: >>

Improvements in GUI.

http://www.vlsoftware.net/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Changelog

- Column editing and browsing data ( Data Editor and Browser ):
 Add: Added Quick Filter field names processing ( Filter columns ) (5798)
 Add: Change the name of the field through the menu display order ( Reordering columns by menu ) (5798)
 Add: Allows field names and drop to change the display order ( Reordering columns by dragging ) (5798)
- SQL editor ( SQL Editor ):
 Upd: SQL format (SQL Formatting): When set uppercaseKeywords = false when will retain the original case, do not make [lowercase] conversion process (5798)
 Upd: SQL format (SQL Formatting): 1. Improved keyword limit n, n formatting, 2. Remove the keyword name of Processing (5798)
 Error Correction (5784) led to 'Besides all off' (Tab-> Close All But This) function affected (5798): Fix
- Object Browser ( Object Navigator ):
 Fix: Fixed (5695) cause problems SQLServer / SQLAzure / SybaseASE executed when the object was renamed, not the normal process of (5798)
 Upd: (SQLite) to exclude unnecessary built automatically generate an index display (5798)
- Data definition language ( Data Definition Language (DDL) ):
 Upd: (SQLite) support WITHOUT ROWID table script generation and related process (5798)
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
 Add: (PostgreSQL 9.2 ~ 9.5) join JSON functions automate the processing (including object reference list display) (5798)
 Upd: Optimization list window automatically zoom the display (5798)
- Implementation Plan ( Execution Plan ):
 Upd: (PostgreSQL) EXPLAIN ANALYZE changed to provide a more detailed analysis of the contents (5798)
- Database migration ( Database Migration ) (Pro):
 Upd: Improved automatic matching field data types ( Automatically match columns ):
 Support PostgreSQL / Informix Auto Increment field serial / smallserial / bigserial automatic matching process (5798)
 Fix: Fixed servo version repository source and purpose [of the same type] database when generating data sheet syntax more unnecessary source structure descriptive name (SCHEMA) Issues (5798)
- Main Program Update ( Main ):
 Upd: Updated x64Pro icon (ICON), to facilitate the difference between x86 and x64Pro (5798)
 Upd: original \ app.exe.sandbox scratch directory to the \ temp \ after app.exe.sandbox program closed automatically deleted (5798)
 Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.7 (2015/11/10) (5798)
 Upd: Accumulated other contains minor updates, correction and optimization (5798)
 Misc: Compatible with PostgreSQL 9.5b2 or ENGINEERING (2015/11/12)
 Misc: Compatible with Teradata 15.10 (2015/11/04)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

New objects creation was fixed
Foreign key navigation (back/forward) was fixed
Paste in property editor (inline) was fixed
MySQL: connection dialog fixed
DB2: MQT indexes support was added
PostgreSQL: date time support was fixed
Firebird: procedures/views DDL was fixed
Oracle: block statements (begin .. end) execute was fixed
CLOB/text columns edit was fixed
Query manager: queries now formatted with parameter values
RPM package fixed (Fedora 20+ format)
Editors UI was improved (icons)
Keyboard shortcuts fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Bug fixes:

IMPROVEMENT: Improve validation and fixup of lost data pages
Casting DATE to string would break in Dialect 1 in the presence a domain with a CHECK constraint
A view or subquery with UNION would not use a computed index
IIF function was preventing the condition from being pushed into the union for better optimization
Predicate IS [NOT] DISTINCT FROM was not being pushed into unions/aggregates, resulting in sub-optimal plans
ALTER DOMAIN ... TO would allows the to be specified in the same pattern as domains generated by the system, i.e., matching to 'RDB$[[:DIGIT:]]*'
MERGE / HASH JOINs would produce incorrect results when VARCHAR join keys differed only by trailing spaces
The server could hang on simultaneous connection to the Services API and a database
An invalid internal BLR filter conversion was detected
Index corruption could occur while inserting data into a long-key-indexed field
Preparing a query with a PLAN clause in a CTE could crash the server
A memory leak was detected in Superserver
MERGE JOIN could be used for expressions involving RDB$DB_KEY
MERGE JOIN was not being used for more than two streams if they were joined via USING/NATURAL clauses
Timestamps could be cast to strings that were beyond the valid range for VARCHAR
The full text of the problem value was not being returned in the message “Problematic key value (attempting to insert duplicate in PK/UK)” when the length of the offending key was 127 characters or longer
ON CONNECT triggers would sometimes fail to execute
A request synchronization error could occur while building an expression index
Bugcheck 167 (invalid SEND request) could occur while working with a GTT from several attachments, using EXECUTE STATEMENT ... ON EXTERNAL and different roles
EXECUTE STATEMENT using BLOB parameters could result in an “Invalid BLOB ID” error
The error “invalid BLOB ID” could occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using EXECUTE STATEMENT against an EXTERNAL DATA SOURCE and the argument db_connect was not specified
Deadlock could occur during attachment
The server could hang while chasing dead record versions.
CREATE TABLE would throw an error if a column was being defined with the character set DOS775
COUNT(DISTINCT ...) was too slow

Windows-Specific:

Online validation on Windows would fail if the dbname argument contained forward slash ('/') and a concurrent attachment existed that also used '/'
Embedded server on Windows could hang due to a synchronization problem involving artifact child processes that were not detectable by Firebird
The Control Panel applet Firebird2Control.cpl would crash in Windows 8

[close]

http://www.firebirdsql.org/

[SiLæncer]

Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

What's new: >>

+ Third party components update
+ Improved support for DB2 database

http://www.dbsoftlab.com/database-editors/database-browser/overview.html

[SiLæncer]

Changelog

- issue #11589 Incorrect parameter in mysqli_fetch_fields()
- issue #11592 Missing headers in zipped export
- issue #11590 Parser: Array to string conversion
- issue #11597 Huge binary log growth on 4.5.x
- issue #11594 'only_db' config option bug when db names contain underscore and are grouped
- issue #11607 Unable to change password from Login information tab
- issue #11610 Undefined variable: res_rel
- issue #11611 Warning while exporting schema to PDF
- issue #11612 Undefined index: new_row_format
- issue #11605 Changing hostname kills password
- issue #11614 Undefined variable: db
- issue #11627 CREATE TABLE/INSERT INTO executed twice (ctrl+enter)
- issue #11630 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given
- issue #11632 Exporting GIS visualization ignores start and row count
- issue #11476 Errors instead of git info when PHP has no gzip support
- issue #11633 CodeMirror tooltip shows below modal window
- issue #11639 Bug with the MainBackground Color
- issue        Profiling checkbox is missing
- issue #11642 Properly handle session expiry after POST requests
- issue #11648 Notice in ./export.php#214 Undefined index: quick_or_custom
- issue #11646 Unrecognized keywords
- issue #11635 Sql not executed properly
- issue #11631 Linter warnings when creating new user
- issue #11626 wrong row count for query results
- issue #11608 Analyzer doesn't recognize GRANT statements
- issue #11602 Parser warnings (subqueries)
- issue #11658 Collation column is empty in table Structure
- issue #11661 Error changing table's column encoding

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Main Program Update (Main):

Fix: (Pro) Correction (57 ??) causes can not be opened or export data source for Excel files
Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.9.0.0 (2015/11/15)
Upd: Accumulated other contains minor updates, correction and optimization
Misc: Compatible with SQL Server 2012 SP3 / SQL Server 2012 SP3 Express and LocalDB (2015/11/21)
Misc: Compatible with Firebird 2.5.5 (2015/11/18)

Data Export (Data Export):

Fix: Improved [part] repository while exporting Excel data, field names contain unnecessary problems Quoted Strings

Form editor and browser (Form Editor and Viewer):

Upd: When displaying the content beyond the current window, the window will be automatically adjusted to avoid exceeding the maximum display
Column editing and browsing data (Data Editor and Browser):

Upd: quick filter field name ( Filter columns ): input controls to move to the top, to facilitate the importation avoid excessive field project

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- Implementation Plan ( Execution Plan ):
 Add: (Pro) Added visual execution plan ( Visual Execution Plan ): provides an image with a more complete analysis of the message display (5812)
 Support contains SQL Server / SQLCe and other repositories
 Upd: (SQL Server) to change the form of the original tree in tabular form (Tabular Execution Plan): easier to understand when analyzing (5812)
 Upd: (SybaseASE) improved display problems, eliminate the unnecessary display (5812)
 Upd: (MySQL) updated version detection processing to support JSON (> = 5.6) format (5812)
 Upd: Improved processing contents will not be set up in the content length limit (5812)
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
 Add: join JSON functions automate the processing (including object reference list display) (5812)
 For more information on library support contains MySQL 5.7 + / SQL Server 2016 + / Oracle 12g + / SQLite / PostgreSQL 9.2+ etc.
- Data Export ( Data Export ):
 Fix: Fixed [part] repository while exporting Excel data, field names contain unnecessary problems Quoted Strings (5806)
- Form editor and browser ( Form Editor and Viewer * ):
 Upd: When displaying the content beyond the current window, the window will be automatically adjusted to avoid exceeding the maximum display (5806)
- Column editing and browsing data ( Data Editor and Browser ):
 Upd: quick filter field name ( Filter columns ): input controls to move to the top, to facilitate the importation avoid excessive field project (5806)
- Main Program Update ( Main ):
 Fix: (Pro) Correction (57 ??) causes can not be opened or export data source for Excel files (5806)
 Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.9.0.0 (2015/11/15) (5806)
 Upd: Accumulated other contains minor updates, correction and optimization (5812)
 Misc: Compatible with SQL Server 2012 SP3 / SQL Server 2012 SP3 Express and LocalDB (2015/11/21)
 Misc: Compatible with Firebird 2.5.5 (2015/11/18)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Grid control was redesigned (filters, navigation, inline editors)
Triggers support was added for PostgreSQL, SQL Server, Sybase, Firebird, Informix
Processing of SQL blocks (begin/end) was fixed
Save of metadata changes was fixed
SQL editor connection selector was fixed
Data search (full-text) was fixed
Invalidate (reconnect) behavior was fixed
Persistent query filters history (EE version)
Metadata editor (views, tables, etc) refresh was fixed
PostgreSQL: text (clob) columns handle fixed
MySQL: “enum” and “set” data types support fixed
MySQL: partitions information reading was fixed
Firebird: views and procedures source code generation was fixed
Oracle: use DBA_* views when possible
Oracle: read new ROWID for inserted rows
Sybase: views, procedures and triggers source code
SQL Server/Sybase: hyperlinks detection fixed
UI freeze was fixed (metadata changes save)
Some standard Icons was changed
Minor UI fixes

[close]

http://dbeaver.jkiss.org/

[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: >>

When 'Auto Detect 64-bit Date/Time Value' option is turned on, ESEDatabaseView now detects the Modified field of tbFiles table inside DataStore.edb
The properties window is now resizable.

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

[SiLæncer]

Release Notes

Functionality Added or Changed

    MySQL Server RPM packages now contain a conflict indicator for MySQL Connector C, such that an error occurs when installing MySQL Server if MySQL Connector C is also installed. To install MySQL Server, remove any MySQL Connector C packages first. (Bug #21900800)

    mysql_upgrade now attempts to print more informative errors than FATAL ERROR: Upgrade failed. (Bug #21489398)

    These client programs now support the --enable-cleartext-plugin option: mysqlcheck, mysqldump, mysqlimport, mysqlshow. This option enables the mysql_clear_password cleartext authentication plugin. (See The Cleartext Client-Side Authentication Plugin.) (Bug #21235226)

    Support for building with Solaris Studio 5.13 was added. (Bug #21185883)

    Performance Schema digests in DIGEST_TEXT columns have ... appended to the end to indicate when statements exceed the maximum statement size and were truncated. This is also now done for statement text values in SQL_TEXT columns. (Bug #75861, Bug #20519832)

Bugs Fixed

    InnoDB: InnoDB returned an invalid corruption-related error message during an IMPORT TABLESPACE operation. (Bug #21838158, Bug #77321)

    InnoDB: An old version of numactl headers on the build host caused a compilation error when building a MySQL version that includes NUMA memory policy support. (Bug #21785074)

    InnoDB: An online ALTER TABLE operation caused a server exit. (Bug #21640679)

    InnoDB: A schema mismatch error occurred when importing a tablespace that was altered by DROP INDEX operation on the source server. (Bug #21514135, Bug #77659)

    InnoDB: A duplicate key error that occurred during an online DDL operation reported an incorrect key name. (Bug #21364096, Bug #77572)

    InnoDB: An ALTER TABLE operation caused the server to exit on disk full. (Bug #21326304, Bug #77497)

    InnoDB: The system tablespace data file did not extend automatically when reaching the file size limit, causing startup to fail with a size mismatch error and preventing the addition of another system tablespace data file. (Bug #21287796, Bug #77128)

    InnoDB: Altering the letter case of a column introduced an inconsistency between the frm file and data dictionary resulting in a failed CREATE INDEX operation on the altered column. (Bug #20755615)

    InnoDB: An ALTER TABLE operation that converted a table to an InnoDB file-per-table tablespace did not check for unknown files with the same name as the destination .idb file, permitting an unknown file of the same name to be overwritten. (Bug #19218794, Bug #73225)

    Replication: As binlog_error_action=ABORT_SERVER is the default in MySQL 5.7.7 and later it is being used for more error situations. The behavior has been adjusted to generate a core dump to improve troubleshooting possibilities. (Bug #21486161, Bug #77738)

    Replication: On a multi-threaded slave configured with master_info_repository=TABLE and relay_log_info_repository=TABLE which had previously been run with autocommit=1, if the slave was stopped and autocommit changed to 0, executing START SLAVE caused the session to appear to hang. After the lock wait timeout, when START SLAVE proceeded the server would stop unexpectedly. The fix ensures that when master_info_repository=TABLE, relay_log_info_repository=TABLE, and autocommit=0 a new transaction is generated for start and commit to avoid deadlocks. (Bug #21440793)

    Replication: Fatal errors encountered during flushing or synchronizing the binary log were being ignored. Such errors are now caught and handled depending on the setting of binlog_error_action. (Bug #76795, Bug #68953, Bug #20938915, Bug #16666407)

    Internal buffer sizes in resolve_stack_dump were increased to accommodate larger symbol space requirements for C++ code. (Bug #22071592)

    MySQL development RPM packages could fail to install if MySQL Connector/C development RPM packages were installed. (Bug #22005375)

    Possible buffer overflow from incorrect use of strcpy() and sprintf() was corrected. (Bug #21973610)

    MySQL RPM packages for RHEL5 failed to create the mysql system user. (Bug #21950975)

    For Debian package control files, libnuma-dev was added to Build-Depends to enable NUMA support. (Bug #21822631)

    Selecting DECIMAL values into user-defined variables could cause a server exit. (Bug #21819304)

    Concurrent FLUSH PRIVILEGES and REVOKE or GRANT statements could produce a small time window during which invalid memory access to proxy user information could occur, leading to a server exit. (Bug #21602056)

    Starting the server with the query_alloc_block_size system variable set to certain negative values on a machine without enough memory could result in out-of-memory errors. (Bug #21503595)

    Using UNINSTALL PLUGIN to uninstall the daemon_example plugin could cause a server exit. (Bug #21467458)

    FLUSH DES_KEY_FILE failed to reload the DES key file. (Bug #21370329)

    If an error occurred during the setup phase of subquery materialization used to compute an IN predicate, cleanup of the temporary table did not happen, leading to Valgrind errors. (Bug #21346081)

    Queries rejected by MySQL Enterprise Firewall were truncated to 512 characters when written to the error log. (Bug #20948270)

    A server exit could occur for the second execution of a prepared statement for which an ORDER BY clause referred to a column position. (Bug #20755389)

    Repeated execution of a prepared statement could cause a server exit if the default database was changed. (Bug #20447262)

    Outer references do not work as arguments to MATCH(), but the server did not properly detect them. Now it does and raises an error. (Bug #20007383)

    References: See also Bug #21140088.

    Valgrind errors were produced during row comparator setup. (Bug #19929406)

    After failure to create a temporary table during join processing and releasing the table descriptor, an attempt to access the now-invalid descriptor could cause a server exit. (Bug #19918299)

    Type conversion failure for DECIMAL values could cause a server exit. (Bug #19912326, Bug #20013538)

    INSERT DELAYED could cause a server exit for tables partitioned with a character column as the key and for which the expression required a character set conversion. (Bug #19894161)

    During a filesort for an UPDATE statement, the optimizer could access a stale pointer, resulting in a server exit. (Bug #19893908)

    A server exit could occur when updating a view using an ALL comparison operator on a subquery that selects from an indexed column in the main table. (Bug #19434916)

    Some stress test files in the mysql-test/suite/innodb_stress directory had the executable file mode set although they were not script files. (Bug #78403, Bug #21822413)

    The server initialization script used for the service mysql status command on Linux sometimes incorrectly reported that the server was stopped. (Bug #77696, Bug #21768876)

[close]

http://www.mysql.com/

[SiLæncer]

Changelog

The visual implementation plan ( Visual Execution Plan ): (Oracle / PostgreSQL / MySQL / HP Vertica / SQL Server / SQL Azure / SQLCE )
Add: (Pro) supports the Oracle database (5822)
Add: (Pro) supports PostgreSQL 9.0 or higher Library (5822)
Add: (Pro) supports MySQL 5.6 or higher Library (5822)
Add: (Pro) supports the HP Vertica Database (5822)
Upd: (Oracle / HP Vertica / Teradata) change to the text display the results (Results to Text) display, easy to browse the entire contents of the complete (5822)
Upd: (HP Vertica) VERBOSE parameter was added to provide a more complete analysis of content (5822)
AutoComplete and perception ( AutoComplete and IntelliSense * ):
Upd: Right menu sub-option to increase IntelliSense switch ( Toggle IntelliSense On or Off ) (5822)
Upd: Change the shortcut key settings: AutoComplete switch (Toggle AutoComplete On or Off): Ctrl + I (5822)
Upd: Change shortcut set: IntelliSense switch (Toggle IntelliSense On or Off): Ctrl Shift + I (5822)
SQL editor ( SQL Editor ):
Upd: New capitalize selected text shortcuts (Make Uppercase): Ctrl + U (5822)
Upd: Add the selected text to lowercase shortcuts (Make Lowercase): Ctrl + L (5822)
Upd: Improved brackets highlighted when containing single or double quotes
Problem (5822)
Information column editing ( Data Editor ):
Fix: (Oracle) Correction (5658) without a primary key (PK) Update and Delete to ROWID as conditions of handling, when SELECT FROM syntax contains more than one keyword (5822)
Upd: Add Tags SQL prompt message, convenient discriminating edit mode ( Tooltip on the Edit tab ) (5822)
Main Program Update ( Main ):
Add: Added Click Browse and Edit shortcut keys ( Single Click for Browsing and Editing ) (5822)
Upd: Improved When the [Cancel] Object Name recognition quotes Item Processing ( Uncheck Using Quoted identifiers ): Reserved Words added processing (5822)
Upd: (Oracle) Improvement (5658) article processing establishment and when newer and more detailed error and warning message is displayed: 1. sensitive dissimilar problem, 2. more than one error message (5822)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.99.0 (3.9.2) (2015/12/10) (5822)
Upd: HP Vertica element updated to Vertica.Data.dll 7.2.1 (2015/11/16) (5822)
Upd: Accumulated other contains minor updates, correction and optimization (5822)
Misc: Compatible with MySQL 5.7.10 (2015/12/05) / MySQL 5.6.28 (2015/12/05) / MySQL 5.5.47 (2015/12/05)
Misc: Compatible with SQL Server 2016 CTP 3.1 (2015/12/01

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Foreign key edit in value view panel
Editor refresh (f5) was fixed
Driver editor UI improved
Standard SQL keywords added
MySQL: events support was added
MySQL: indexes metadata was improved
PostgreSQL: OID and HSTORE columns handle was fixed
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new: >>

Minor bug fixes in export routines.

http://www.vlsoftware.net/

[SiLæncer]

Database program with 27.800 recipes. It implements search functions and calories calculation (43.336 ingredients aready defined). Possibility to add pictures of the courses and your own recipes (using the dbrice13agg.exe utility).

License: Creative Commons License

http://www.dbricette.it/