Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Pretty Database Explorer is a useful and easy-to use application designed to explore various databases. With its intuitive interface, it will remember your queries, your scripts and created tables. You have the possibility to connect to various databases such as Firebird, Interbase, MySQL or Oracle.

Freeware

Whats new: >>

Import wizard fixed.

http://www.pretty-software.com/prettydbexplorer.htm

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

Release Notes

- The main program update ( Main ):
 Add: Full support NuoDB database system  (A distributed cloud database management system) (5260)
 Add: full support for Teradata Database System  (5260)
 Upd: contains many other minor fixes and updates ... and so accumulate process optimization (5260)
- Auto-sensing processing ( AutoComplete * ):
 Add: increase the perception caching (IntelliSense Cache), when read from the cache can significantly improve reading speed, and when the field is updated automatically cached content transaction without any maintenance treatment (5260)
 Upd: Improved User Experience: When dealing with a field alias (Column Aliases) is not perceived as a field processing (eg colname AS xxx) (5260)
 Upd: Improved User Experience: After selecting the fields to solve multiple-choice, if the focus is not in the selected field can not be completed on the field into treatment (5260)
 Upd: optimization of field perception processing, eliminate many invalid action and improve processing speed (5260)
 Upd: insert the selected item to complete processing (Insert Selected Item), increase = shortcuts (Shortcut Key: Space, Enter, Tab, =) (5260)
 Fix: Improved and objects other than correction TABLES (VIEWS / SYSTABLES / SYSVIEWS) and other perceptual speed and processing power (5260)
- Code management ( Code Manager ):
 Fix: Fix problem if renaming a file or directory name changes only in case, you can not properly handle the (5260)
- Row editing and browsing ( Data Editor and Browser ):
 Upd: increase System.Object data type handling (with Byte ()) (5260)
- Database Backup and Restore ( Backup and Restore Database ):
 Upd: Updated SQL Server database restore process when the database already exist to cover the processing directly without first deleting or renaming (5260)
- SQL editor ( SQL Editor ):
 Fix: search and replace function ( Quick Find and Replace ):. 1 to maintain the position of the cursor remains in the final end, two after closing the dialog box controls the focus back to the original (5260).
- Batch script generation ( Generate Batch Scripts ):
 Add: increase Oracle Objects Packages batch script generation (5260)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Script table as Create bug fixed on MS SQL.

http://www.pretty-software.com/prettydbexplorer.htm

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

SQL statement execution starts from the current cursor position now
Corrected problem with cloning connections

http://www.etl-tools.com/database-editors/database-browser/overview.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: >>

Added 'Copy Sorted Column Data' option, which copies to the clipboard the text of all selected items, but only the column that is currently sorted.

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

[SiLæncer]

Release Notes

# Functionality Added or Changed
* The obsolete and unmaintained charset2html utility has been removed from MySQL distributions.
* The mysqlbug, mysql_waitpid, and mysql_zap utilities have been deprecated and will be removed in MySQL 5.7.
# Bugs Fixed
* InnoDB: After upgrading from 5.6.10 to MySQL versions up to and including MySQL 5.6.18, InnoDB would attempt to rename obsolete full-text search auxiliary tables on server startup, resulting in an assertion failure.
* InnoDB: For each insert, memset would be called three times to allocate memory for system fields. To reduce CPU usage, the three memset calls are now combined into a single call.
* InnoDB: Enabling the InnoDB Table Monitor would result in a ib_table->stat_initialized assertion failure.
* InnoDB: Setting innodb_max_dirty_pages_pct=0 would leave 1% of dirty pages unflushed. Buffer pool flushing is initiated when the percentage of dirty pages is greater innodb_max_dirty_pages_pct. The internal variables that store the innodb_max_dirty_pages_pct value and the percentage of dirty pages (buf_get_modified_ratio_pct and srv_max_buf_pool_modified_pct) were defined as unsigned integer data types, which meant that a innodb_max_dirty_pages_pct value of 0 required a dirty pages percentage of 1 or greater to initiate buffer pool flushing. To address this problem, the buf_get_modified_ratio_pct and srv_max_buf_pool_modified_pct internal variables are redefined as double data types, which changes the range value for innodb_max_dirty_pages_pct and innodb_max_dirty_pages_pct_lwm from 0 .. 99 to 0 .. 99.99. Additionally, buffer pool flushing is now initiated when the percentage of dirty pages is “greater than or equal to” innodb_max_dirty_pages_pct.
* Replication: Log rotation events could cause group_relay_log_pos to be moved forward incorrectly within a group. This meant that, when the transaction was retried, or if the SQL thread was stopped in the middle of a transaction following one or more log rotations (such that the transaction or group spanned multiple relay log files), part or all of the group was silently skipped. This issue has been addressed by correcting a problem in the logic used to avoid touching the coordinates of the SQL thread when updating the log position as part of a relay log rotation whereby it was possible to update the SQL thread's coordinates when not using a multi-threaded slave, even in the middle of a group.
* Replication: When running the server with --gtid-mode=ON, STOP SLAVE followed by START SLAVE resulted in a mismatch between the information provided by INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO and the Slave_open_temp_tables status variable: the INNODB_TEMP_TABLE_INFO table showed that no temporary tables existed, but Slave_open_temp_tables had a nonzero value.
* Replication: In certain cases, the server mishandled triggers and stored procedures that tried to modify other tables when called by CREATE TABLE ... SELECT. This is now handled correctly as an error.
* Replication: When used on a table employing a transactional storage engine, a failed TRUNCATE TABLE was still written to the binary log and thus replayed on the slave. This could lead to inconsistency when the master retained data that was removed on the slave.
* Now in such cases TRUNCATE TABLE is logged only when it executes successfully.
* Replication: The server did not always handle the auto.cnf file correctly in cases where this file's permissions were incorrect.
* Replication: When the binary log was rotated due to receipt of a SIGHUP signal, the new binary log did not contain the Previous_gtid_event required for subsequent processing of that binary log's GTID events. Now when SIGHUP is received, steps are taken to insure that the server writes the necessary Previous_gtid_event to the new log before writing any GTID events to the new log.
* Replication: When gtid_mode=ON, and a transaction is filtered out on the slave, the GTID of the transaction is still logged on the slave as an “empty” transaction (consisting of a GTID followed immediately by BEGIN and then COMMIT). This is necessary to prevent the transaction from being retransmitted the next time the slave reconnects or is involved in a failover. The current fix addresses two issues relating to such “empty” transactions:
- No empty transaction was generated for CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements.
- If the slave used a database filter (--replicate-do-db or --replicate-ignore-db option), no empty transaction was generated.
* The server could fail to properly reprepare triggers that referred to another table after that table was truncated.
* Certain INFORMATION_SCHEMA queries could cause a server exit.
* For indexes on prefixes or character string columns, index corruption could occur for assignment of binary data to the column due to improper character counting.
* Solaris-specific scripts were included in and installed by non-Solaris packages.
* Concurrent execution of a FLUSH TABLE operation and a stored program that used a cursor could cause a server exit.
* The client library could cause clients to exit due to incorrectly mapping the client error number to the corresponding message, if reallocation of packet buffer memory occurred.
* Calling mysql_get_server_version() with an invalid connection handler argument caused the client to exit. Now it returns 0 and reports a CR_COMMANDS_OUT_OF_SYNC error.
* mysqldump could create table definitions in the dump file that resulted in Too many columns errors when reloading the dump file.
* On Windows, calling mysql_thread_init() call without mysql_init() caused the client to exit. windows. Now it returns a nonzero result because it is an error to call mysql_thread_init() before the client library is initialized with mysql_library_init().
* The optimizer trace could cause a server exit in cases where a subquery was transformed away.
* The Debug Sync facility could lose a signal, leading to a spurious ER_DEBUG_SYNC_TIMEOUT error.
* Compilation problems were fixed for errors reported by Clang and gcc when compiling in C++11 mode.
* CMake produced not-useful warnings about INTERFACE_LINK_LIBRARIES policy.
* LOAD DATA LOCAL INFILE could use all CPU if import errors occurred when there were no line delimiters.
* On Windows, REPAIR TABLE and OPTIMIZE TABLE failed for MyISAM tables with .MYD files larger than 4GB.
* A statement of the following form broke row-based replication because it created a table having a field of data type BIGINT with a display width of 3000, which is beyond the maximum acceptable value of 255: CREATE TABLE t1 AS SELECT REPEAT('A',1000) DIV 1 AS a;
* Updates could fail to update all applicable rows in cases where multiple key values were identical except for trailing spaces.

[close]

http://www.mysql.com/

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

Release Notes

The main program update ( Main ):
Upd: support the specified Teradata database browsing, connection settings, or choose not to specify the database specified way to browse if you do not specify all databases (5266)
Upd: Object filter settings ( Filter Settings ): added support for Packages, Macros and other objects filtration treatment (5266)
Upd: Updated Spanish interface language Spanish language (by David Hernandez) (5266)
Upd: Search table data ( Search Table Data ):. 1 supports numeric types (Numeric Types) search field, two field names containing type display (5266).
Upd: (NuoDB) component version updated to NuoDb.Data.Client.dll 2.0.4 (2014/05/27) (5266)
Upd: contains many other minor fixes and updates ... and so accumulate process optimization (5266)
Misc: Compatible with MySQL 5.6.19 (2014/05/30) / MySQL 5.5.38 (2014/05/30)
Object Browser ( Object Navigator ):
Fix: (Oracle) Correction Browse INDEXES / TRIGGERS OWNER change TABLE_OWNER original object does not display properly to avoid problems (including script generation) (5266)
Upd: Table title display row number ( RowCount ): support more databases (SybaseASE / SQL Server / SQLCe / PostgreSQL / MySQL / Informix / NuoDB) (5266)
Upd: Table title update table statistics ( Update Table Statistics ): support more databases (SybaseASE / SQL Server / SQLCe / PostgreSQL / MySQL / Informix / NuoDB) (5266)
Upd: (NuoDB) with the Object Browser automatically switch current position (USE SCHEMA), can be omitted to specify (5266) where the object is located when processing time under SCHEMA
Auto-sensing processing ( AutoComplete * ):
Upd: If the current table does not exist or can not be perceived, would be automatically excluded avoid subsequent retry affect processing speed (5266)
Fix: Object filter settings (corrected via Filter Settings icon (Icon) objects) are not displayed correctly after the corresponding question (5266)
- Script generation ( Data Definition Language ):
Upd: (Teradata / MySQL / Oracle) to rewrite the script to generate TABLES way to provide a more complete attribute display (5266)
Upd: (IBM DB2) support EXTERNAL PROCEDURE, EXTERNAL FUNCTION script generation (5266)
Upd: (SQL Server) to update FileTables script generation, including complete property displays (5266)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Release Notes

Query Builder ( Query Builder * ):
Upd: significant improvements to the selected Query Builder query processing ( Selected Text to Query Builder ): initially completed all selected automatically generated syntax processing (5273)
Add: supports full link type ( Full Support for JOIN types : INNER / OUTER LEFT / RIGHT OUTER / FULL OUTER JOIN) (5273)
Upd: Alias ​​exclude the use of quoted identifiers (Quoted Identifiers) (5273)
Upd: increase (NuoDB: FETCH FIRST and Teradata: TOP) and other grammar generation process database (5273)
Fix: fix the list of fields not Move Up Move the pen position to the first issue (5273)
The main program update ( Main ):
Add: increases start to open the final check labels ( Options-> Open Last Query tabs on startup ) (5273)
Upd: Connection Manager ( Connection Manager ): Additional connection string settings (Additional) integrated into the Open (with connection set) (5273) [?]
Upd: (Firebird) component version updated to FirebirdSql.Data.FirebirdClient.dll 4.2.0 ( ) (2014/06/05) (5273)
Upd: (Teradata) component version updated to Teradata.Client.Provider.dll 15.0.0 ( ) (2014/05/13) (5273)
Upd: contains many other minor fixes and updates ... and so accumulate process optimization (5273)
Data Export ( Data Export ):
Add: increase TEXT / CSV export format option to specify the output value NULLs ( (* txt; * csv) Export NULLs As String Empty or NULL.. ) (5273)
Upd: turn blank (Blank) processing format XLSX / XLS Export NULL (5273)
- Row editing and browsing ( Data Editor and Browser ):
Add: increase the entire column is selected function ( Select the entire column ) (5273)
SQL editor ( SQL Editor ):
Upd: search and replace function ( Quick Find and Replace ): Search results are displayed in a different background color (5273)
Auto-sensing processing ( AutoComplete * ):
Upd: Table Alias ​​solve if adding extra quotes identifiers (Quoted Identifiers), the field is not aware of the problems caused by anti-(5273)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

- bug #4423 Moving fields not working
- bug #4424 Table indexes disappear after altering field
- bug #4432 Error while displaying chart at server level
- bug #4405 Cannot import (open_basedir)
- bug #4396 Problem copying constraints (such as Sakila)
- bug #4433 Missing privileges submenu
- bug #4394 Drop db confirmation message when dropping a user
- bug #4436 Insert form numeric field with function drop-down list
- bug #4437 Problems due to missing enforcement of the minimum supported MySQL version
+ Add enforcement of the minimum supported PHP version (5.3.0)
- bug       Query error on submitting a column change form containing a disabled input field
- bug       Incorrect menu tab generation from usergroups
- bug       Missing space in index creation/edit generated query
- bug #4434 Unchecking 'Show SQL queries' results NaN

Download : Klick

http://www.phpmyadmin.net/

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

List of connections is sorted alphabetically now

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

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

Release Notes

Row editing and browsing ( Data Editor and Browser ):

Add: Added display the results in a text function ( Results to Text ) (5282)
Add: Added automatic filtering feature ( AutoFilter ): Fast and simplify query data content (using Ctrl + Click to multi-select) (5282)
Add: Added field data browsing ( Browsing Column Data ): Quick View field data, more convenient analytical processing (5282)
Upd: When returns no rows at the same time [None Field], show only return status message handling to avoid displays an empty list (5282)
Upd: Cell background color consistency of the selected display after treatment (5282)
Fix: fix batch SQL command processing: the resulting output to a file (Results to File) field type handling problems (5282)

SQL editor ( SQL Editor ):

Upd: Updated syntax highlighting significant (Syntax Highlighting): richer colors, displaying different databases and more consistent (5282)
Upd: more intelligently handle SQL editing area and data display zone automatic scaling issues (5282)

Table Editor ( Table Designer ):

Upd: Updated and corrected to delete the field with index (Column + Index) of treatment (5282)

SQL History ( SQL History ):

Upd: When SQL history database turned over> 3s, the processing will be performed automatically halved Clear (5282)

The main program update ( Main ):

Add: increase SQLite function REGEXP support treatment (5282)
Upd: (NuoDB) component version updated to NuoDb.Data.Client.dll 2.0.4.1 (2014/06/17) (5282)
Upd: other contains the cumulative minor updates, fixes and optimization (5282)
Misc: Compatible with SQL Server 2012 SP2 / SQL Server 2012 SP2 Express and LocalDB (2014/06/10)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

- bug #4449 Mediawiki export does not produce table header row; also fix related PHP warnings
- bug #4442 New lines are added to query every time
- bug #4445 Fatal error on SQL Export of join query
- bug #4448 Dump binary columns in hexadecimal notation not working
- Regenerate cookie encryption IV for every session
- bug #4405 Cannot import (open_basedir): fix another case
- bug #4457 SQL tab - Insert queries not showing affected row count
- bug       Missing warning about existing account, on multi-server config
- bug #4435 WHERE clause can be undefined
- bug       SQL export views as tables option getting ignored
- bug #4464 [security] XSS injection due to unescaped db/table name in navigation hiding
- bug #4465 [security] XSS injection due to unescaped db/table name in recent/favorite tables

Download : Klick

http://www.phpmyadmin.net/

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

You can now specify an empty string ("") in order to send the data to stdout, for example:
ESEDatabaseView.exe /table "c:\temp\contacts.edb" "SimpleContact-v081111-0122-1303" /scomma ""

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

[SiLæncer]

Whats new: >>

Release Notes

Row editing and browsing ( Data Editor and Browser ):

Fix: Automatic filtering ( AutoFilter ): solve SQLAzure / SQLServer / SQLCe / Sybase environment under Win 8 types of text fields can not filter problems (5287)
Fix: fix batch SQL command processing: For data visualization ( Data Visualization ) and separated mode ( Splitter mode ) related processing issues (5287)
Issue (5287) (OData) Correction (5282) may lead to non-text field to Null data type and can not handle: Fix

Table Editor ( Table Designer ):

Upd: (PostgreSQL) table field displays the type of case is more consistent (including script generation and fields displayed) (5287)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Pretty Database Explorer is a useful and easy-to use application designed to explore various databases. With its intuitive interface, it will remember your queries, your scripts and created tables. You have the possibility to connect to various databases such as Firebird, Interbase, MySQL or Oracle.

Freeware

Whats new: >>

Block select option in the query editor.
You can paste Delphi code with SQL and it will be converted to SQL.
You can copy SQL to Delphi code.
Prepare app to run as portable in options

http://www.pretty-software.com/prettydbexplorer.htm