Thema: Datenbanksoftware und Tools diverses ...

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

+ Query builder update
+ Added support for subqueries
+ Added incremental search to Query builder
+ Third party components update

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

[SiLæncer]

Changelog

- Master Program Update ( Main ):
 Fix: Bug Fixes (5491) version of the connection settings servo stalled (5492 = 5491.3)
 Add: Added support for Firebird 3.0 relational database systems (5491)
 BOOLEAN data type support and related processing (5491)
 Support IDENTITY (AutoIncrement) auto-increment field type and related processing (5491)
 Support PACKAGES object browsing and related processing (5491)
 Add: Implementation Plan ( Execution Plan ): Added support for DB2 / SybaseASE and other repositories (5491)
 Upd: Update the existing main program and add more different resolution icon (Icon: 16/32/48/64/128 pixels) (5491)
 Upd: NuoDB components updated to version 2.1.1.1 NuoDb.Data.Client.dll (2014/12/31) (5491)
 Upd: Accumulated other contains a small update, correction and optimization (5491)
- Data Definition Language ( Data Definition Language (DDL) ):
 Add: (Firebird) supports data sheet calculations generate row definition display (Computed Column Definition) (5491)
 Fix: (Firebird) correction data tables associated with grammar ON UPDATE / ON DELETE RESTRICT problem without displaying the preset time (5491)
 Fix: (Firebird) solve Scale> Percision error (5491) NUMERIC return value may appear
 Fix: (FoxPro) amendment (5226) led to the problem of generating AutoInc syntax errors (including information table editor ( Table Designer )) (5491)
- Object Browser ( Object Navigator ):
 Add: (Sybase ASE) increase (unsigned) bigint / int / smallint, (uni) char / text / varchar data types, such as data type and associated processing (5491)
 Add: Updates Data Sheet Statistics ( Update Table Statistics ): Added support for DB2 database (5491)
 Add: update index statistics (Update Index Statistics): Added support for DB2 / SQL Server / SQLAzure and other repositories (5491)
 Add: Reorganize Index (Reorganize Indexes): Added support for DB2 database (5491)
 Upd: Improved exception handling when no permission to view data table field when the (5491)
- Column editing and browsing data ( Data Editor and Browser ):
 Upd: Improved User Experience: When execution <0.5s when no longer wait for the window display and reduce the display is switched (5491)
 Fix: Data Export ( Data Export ): amended (53 ??) cause problems under non-edit mode some data types can not be handled correctly (5491)
 Fix: (Oracle) data type information to solve OracleDecimal System.Decimal itself beyond the length of the problem can not be displayed (5491)

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

Improvement of copy/paste functionality in database grid:
- Now, pasting cells from clipboard can be done in Update+Insert mode, i.e. updating existing cells and inserting new cells if cell range in clipboard beyonds last record in target table.
- Minor display errors fixed.

http://www.vlsoftware.net/

[SiLæncer]

DBeaver is a comprehensive and effective software solution geared towards developers and database administrators who need to manage and organize tables, triggers, views and stored procedures from multiple databases.

Freeware

Whats new:>>

Cassandra 2.1.x support was added
Apache Derby driver was updated
ResultSet scrolling bug was fixed
Data export wizard was fixed
DB2 execution plan was fixed
SQL editor execution log was fixed

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- bug #4694 js error on marking table as favorite in Safari (in private mode)
- bug #4695 Changing $cfg['DefaultTabTable'] doesn't update link and title
- bug       Undefined index menuswork
- bug       Undefined index navwork
- bug       Undefined index central_columnswork
- bug #4697 Server Status refresh not behaving as expected
- bug       Null argument in array_multisort()
- bug #4699 Navigation panel should not hide icons based on 'TableNavigationLinksMode'
- bug #4703 Unsaved schema page exported as pdf.pdf
- bug #4707 Call to undefined method PMA_Schema_PDF::dieSchema()
- bug #4702 URL is non RFC-2396 compatible in get_scripts.js.php

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Database File Explorer is a straightforward and simple-to-use software tool that allows you to explore database files and file groups, as well as to find out their location and space occupied on the disk. It does not comprise complex options or configuration parameters.

Freeware

Whats new:>>

Core engine updates
"Run As Administrator" notice is shown when user lacks relevant permissions (for local file creation, etc)

http://www.doccolabs.com/products_dbfileexplorer.html

[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 failed to remember the last size/position of the main window if it was not located in the primary monitor.

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

[SiLæncer]

Changelog

- bug       Undefined constant PMA_DRIZZLE
- bug #4712 Wrongly positioned date-picker while Grid-Editing
- bug #4714 Forced ORDER BY for own sql statements
- bug #4721 Undefined property: stdClass::$version
- bug #4719 'only_db' not working
- bug #4700 Error text: Internal Server Error
- bug #4722 Incorrect width table summary when favorite tables is disabled
- bug #4716 Collapse all in navigation panel is sometimes broken
- bug #4724 Cannot navigate in filtered table list
- bug #4717 Database navigation menu broken when resolution/screen is changing
- bug #4727 Collation column missing in database list when DisableIS is true
- bug       Undefined index central_columnswork
- bug       Undefined index favorite_tables

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

RecordEditor is a datafile editor, similar to File-Aid or Net-Cobols Cobol-Editor. It uses a record layout to format the data in the file in to a human readable format. Because it knows the format of fields, it can format binary fields as normal numbers rather than displaying hex equivalent as most hex editors do. The file can be editted in a table (spreadsheet-like format) or in a single record format with fields going down the page.

Freeware

Release Notes

- Fixes for Java 8 + linux/Open-Jdk
- Updated Csv parser (Extended Basic is now the default Csv parser). The new standard Parser follows Csv standard more closely
- Updated Main screen with:
- Options to list Drives (Windows) and Recent Directories
- Option to display hidden files (Right Click Menu)
- Updated File-Chooser screen with Recent directory options

[close]

http://record-editor.sourceforge.net/

[SiLæncer]

What's new: >>

+ Added Vertical Grid

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

[SiLæncer]

Changelog

- Master Program Update ( Main ):
 Upd: upgrade compatibility problems handling, temporary storage location directory with executable files (automatically deleted after the program shut down), easy to perform properly in a high security environment with restricted privileges (5510)
 Upd: Updated JSON file format browse, add different formats deal with issues related to the update (5510)
 Upd: Updated Italian interface language Italian language (by Paolo Saudin) (5510)
 Upd: Teradata component version update to Teradata.Client.Provider.dll 15.1.0.0 (2015/01/26) (5510)
 Upd: Firebird components updated to version 4.6.1.0 FirebirdSql.Data.FirebirdClient.dll (2015/01/23) (5510)
 Upd: NuoDB components updated to version 2.1.1.2 NuoDb.Data.Client.dll (2015/01/18) (5510)
 Upd: Accumulated other contains a small update, correction and optimization (5510)
- SQL Editor ( SQL Editor ):
 Add: Right Menu [perform] function increased [into the execution of the current statement] sub-options [C] - Execute current statement (Ctrl + Enter) (5510)
 Add: right-click menu [Search] function increased [replace] sub-options [R] - Replace (Ctrl + H) (5510)
 Add: Right menu [insert code] function increased [code management] sub-options [M] - Code Snippets Manager (5510)
 Fix: corrected perform batch processing of native (non-GO), a successful return content but with an error, an error message is not included in the question (5510)
- Data Import and Export ( Data Import and Export ):
 Fix: Improved data import and export separate characters exception handling (5510)
 Upd: optimization of import and export processing speed and reduce the memory footprint (5510)
- Object Browser ( Object Navigator ):
 Upd: Improved when no permission to view or can not find the object, no longer displays an error message (5510)
- Column editing and browsing data ( Data Editor and Browser ):
 Add: Right Menu [copy] functional integration of the original [header along with copy] sub-options [H] - Copy with Headers (5510)
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
 Add: Support expressions UNION, EXCEPT, INTERSECT, MINUS and other related processing (5510)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Minor changes in exporting to SQL Script.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

# Functionality Added or Changed
- Support for the SSL 2.0 and SSL 3.0 protocols has been disabled because they provide weak encryption. Support was added for the TLS 1.1 and TLS 1.2 protocols.
- yaSSL was upgraded to version 2.3.7.
- The valid date range of the SSL certificates in mysql-test/std_data has been extended to the year 2029.
# Bugs Fixed
- InnoDB: A tablespace export operation set the purge state to PURGE_STATE_STOP but the purge thread did not check the purge state until the current purge operation was completed. In the case of a large history list, the tablespace export operation was delayed, waiting for the current purge operation to finish. The purge state is now checked with every purge batch.
- InnoDB: An ALTER TABLE ... ADD INDEX operation raised an assertion due to assertion code that did not allow an online index status of ONLINE_INDEX_ABORTED_DROPPED. The assertion code has been relaxed.
- InnoDB: An error occurred when the push_warning_printf function was invoked during server recovery. This function was previously used to print a warning message to the client. Also, current_thd was NULL when the server was restarted.
- InnoDB: An ALTER TABLE operation that changed the name of a foreign key column resulted in a failure when reloading the foreign key constraint. The previous column name remained in the data dictionary cache instead of being evicted.
- InnoDB: Error messages regarding a size limitation on BLOB or TEXT data inserted in a single transaction have been revised.
- InnoDB: DML operations on a table with full-text search indexes raised an invalid assertion.
- InnoDB: A multiple-table delete operation caused the server to halt.
- InnoDB: A FLUSH TABLES operation raised an assertion.
- InnoDB: With change buffering enabled, a buffered sequence of operations that should not have been buffered resulted in an Unable to purge a record error.
- InnoDB: On non-Windows platforms, os-file_pread and os_file_pwrite functions return -1 when an error occurs. This value was printed in an error message as the number of bytes read or written. Instead of printing the -1 value in the error message, a separate error message indicating a system call failure is now printed. Thanks to David Bennett for the patch.
- InnoDB: A slow shutdown (innodb_fast_shutdown=0) after crash recovery raised an assertion. Slow shutdown did not wait for background rollback operations to finish before proceeding.
- InnoDB: The integer column value was handled incorrectly for the memcached incr and decr commands.
- Partitioning: A failed ALTER TABLE ... TRUNCATE PARTITION statement or a failed TRUNCATE TABLE statement against a partitioned table sometimes left inconsistent metadata in the table cache; subsequent SQL statements reusing this metadata failed, and could in some cases also lead to a failure of the server.
- Replication: If a client thread on a slave executed FLUSH TABLES WITH READ LOCK while the master executed a DML, executing SHOW SLAVE STATUS in the same client became blocked, causing a deadlock. The fix ensures that the read lock is only held during the period that the relay log is being updated and the deadlock is avoided.
- Replication: When an XA transaction was active, executing an internal rollback, for example using the BINLOG statement, resulted in an assertion. The fix ensures that a rollback happens only for a slave when a transaction spans multiple binary log files. Rollback does not happen now if the Format_description comes from the BINLOG statement being executed in the MySQL client.
- Replication: In normal usage, it is not possible for a slave to have more GTIDs than the master. But in certain situations, such as after a hardware failure or incorrectly cleared gtid_purged, the master's binary log could be truncated. This fix ensures that in such a situation, the master now detects that the slave has transactions with GTIDs which are not on the master. An error is now generated on the slave and the I/O thread is stopped with an error. The master's dump thread is also stopped. This prevents data inconsistencies during replication.
- Replication: When using SHOW SLAVE STATUS to monitor replication performance, Seconds_Behind_Master sometimes displayed unexpected lag behind the master. This was caused by Previous_gtids_log_events being written to the slave's relay log with a timestamp behind the master, and then being used to calculate the Seconds_Behind_Master. This fix ensures that events generated on the slave that are added to the relay log and are not used when calculating Seconds_Behind_Master.
- On Ubuntu 14.10, MySQL install operations could fail to reload AppArmor.
- EXPLAIN within an XA transaction could raise an assertion.
- Binary log files created by streaming the binary log from a remote server with mysqlbinlog were given an access mode more permissive than the original files.
- If the audit_log plugin encountered a disk-full error, the server would exit.
- Now, if the file system to which the audit log is being written fills up, a “disk full” error is written to the error log. Audit logging continues until the audit log buffer is full. If free disk space has not been made available by the time the buffer fills, client sessions will hang, and stopping the server at the time of client sessions hanging will result in audit log corruption. To avoid this if client sessions are hung, ensure that free space is available on the audit logging file system before stopping the server.
- For failure to create a temporary table due to being out of file descriptors, the server exited rather than returning an error.
- For some queries that contained a derived table (subquery in the FROM clause), delay of materialization resulted in a suboptimal execution plan due to a less accurate row-count estimate.
- For UPDATE and DELETE statements, the server could exit after attempting to access an uninitialized data structure.
- Starting the server with start service or mysqld_safe could result in failure to use the correct plugin directory.
- FLUSH TABLES on a FEDERATED table failed if the table had been idle longer than the wait_timeout time plus the TCP keepalive time.
- Selecting all columns from INFORMATION_SCHEMA.TABLES did not reopen tables if they were in the table cache, but selecting a subset of those columns under the same conditions did reopen tables.
- If my_write() encountered a disk-full condition, it could return an incorrect error value.
- InnoDB boolean full-text searches incorrectly handled + combined with parentheses; for example, +word1 +(>word2 <word3).
- MySQL failed to compile with GCC 4.9.1 in debug mode.
- For debug builds, the server could exit due to an optimizer failure to allocate enough memory for group references.
- The server no longer logs the following warnings because they are uninformative: Client failed to provide its character set. 'charset' will be used as client character set.
- A file created for an internal temporary table could cause problems if the file was orphaned for some reason and the file name was reused for later queries.

[close]

www.mysql.com

[SiLæncer]

Changelog

- bug #4728 Incorrect headings in routine editor
- bug #4730 Notice while browsing tables when phpmyadmin pma database exists, but not all the tables
- bug #4729 Display original field when using "Relational display column" option and display column is empty
- bug #4734 Default values for binary fields do not support binary values
- bug #4736 Changing display options breaks query highlighting
- bug       Undefined index submit_type
- bug #4738 Header lose align when scrolling in Firefox
- bug #4741 in ./libraries/Advisor.class.php#184 vsprintf(): Too few arguments
- bug #4743 Unable to move cursor with keyboard in filter rows box
- bug       Incorrect link in doc
- bug #4745 Tracking does not handle views properly
- bug #4706 Schema export doesn't handle dots in db/table name
- bug #3935 Table Header not displayed correct (Safari 5.0.5 Mac)

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands.

Changelog

Bug fixes:

Default Location field can't be changed in v3.5.0 on OSX - #197
Crash when a table name is empty - #194
CSV Import bug - final row being missed - #193
Attach database when main is encrypted - #174
Failure to delete some SQLite entries (.s3db) - #172

[close]

http://sqlitebrowser.org/