Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

- Quick Filtering Objects
Fix: Fixed an issue where switching the query page of different schemas caused the object list to be incorrect (6946)
- Main program update ( Main ):
Upd: (FoxPro) Simplified database open method *.dbc;*.dbf merge processing (6946)
Upd: Others include cumulative small updates, corrections and optimizations (6946)
- Table Designer :
Add: Supports Computed Column Expression definition processing (6946)
Support includes: Firebird/MySQL/SQL Server/SQL Azure/Sybase ASE and other databases
Additional support includes: Recreateing Tables and Duplicating Tables
- Data Editor :
Upd: Computed Columns is changed to uniquely, and simultaneous update display is supported (6946)
Support includes: Firebird/MySQL/SQL Server/SQL Azure/Sybase ASE and other databases
Upd: Improve the user experience: Clearly distinguish between the only fields (ReadOnly Columns) (6946)
- Object browsing ( Object Navigator
Add: Column Tips to increase the calculation data field display (6946)
- Generating Scripts :
Add: (IBM DB2) Support for Partitioned tables property generation display (6946)
Add: (Sybase ASE) Support Computed Columns calculation data field calculation field generation display (6946)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (6946)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Alternate Firebird Copy is an application that was created in order to help users handle tables that are contained in Firebird or Interbase databases. It will allow them to easily select the preferred databases and copy the required tables.

Freeware

Whats new:>>

Ported to Unicode

http://www.alternate-tools.com/pages/c_fireupdate.php?lang=ENG

[SiLæncer]

Whats new:>>

    Improved livelock prevention.
    [feature-requests:#61] "Information about exported rows"
    [bugs:#36] "Data Export Dialog: Some settings are 'lost' between Exports"
    Fixed NPE in "explain" feature.
    Minor bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

MiTeC SQLite Query allows you to manage any SQLite3 database completely. It also provides you with the option to either import data from a CSV or to export it to CSV and SQL formats.

Whats new:>>

 Visual enhancements, bug fixes.

Freeware

http://www.mitec.cz/sqliteq.html

[SiLæncer]

Whats new:>>

French translation updated

http://www.alternate-tools.com/pages/c_fireupdate.php?lang=ENG

[SiLæncer]

Changelog

Data Editor :

Add: Exclusive support Access (accdb/accde) Computed Columns Synchronized Update Display (6953)

Table Designer :

Add: (VistaDB) Support for Table and Column Comments (including other feature-related support) (6953)

Data Editor and Browser :

Upd: Filtering columns : Do not cancel the Non Null field and add Column Tips (6953)

Object Navigator :

Add: (SQL Server/SQL Azure) Support for Temporal Table data table deletion processing (6953)
Upd: (SQL Server/SQL Azure) Exclude Temporal Table System Auto Generate Data Table Display (6953)
Fix: Fixed title column (Title) sync update issue (6953)

Generating Scripts :

Add: (SQL Server/SQL Azure/SQLCe) Support for ROWGUIDCOL field attribute generation (6953)
Add: (SQL Server/SQL Azure) Support for Collation Name Property Generation (6953)
Upd: (SQL Server/SQL Azure) Exclude Temporal Table System Auto Generate Attributes (6953)

Binding SQL variables :

Fix: Corrects the process specified as NULL when there is no expression (6953)

Main program update ( Main ):

Upd: (Firebird) Complete update of built-in functions (Built-in Functions) and reserved words (Reserved Words) reference display (6953)
Upd: Others include cumulative small updates, corrections and optimizations (6953)

Database Migration (Pro):

Upd: All updates are the same as dbMigration .NET Software (6953)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- Main program update ( Main ):

Fix: Secure Shell Protocol ( SSH: Secure Shell ): Fixed an issue where remote SSH could not be handled (6959)
Upd: Others include cumulative small updates, corrections and optimizations (6959)

- Data Import :

Fix: Correct the data sheet data import source name designation problem, avoiding the change caused by other processing (6959)

- Table Designer :

Fix: (Oracle) Resolving issues that may cause ORA-01451 when modifying field types (6959)

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

Whats new: >>

Improvements in export field mappings interface.
Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Connection wizard was completely redesigned.
Database driver icons were updated.
“Tip of the day” dialog was redesigned, tips were added
SQL editor:

    Parameters binding was improved
    @set command now supports variables

Data transfer:

    Tables/columns mapping UI was enhanced
    Auto-mapping button was added
    Summary page was redesigned

ERD: attributes visibility configuration was fixed
SQL Server:

    Active directory and Kerberos authentication were added
    Server sessions/connections manager was added
    Error position highlighting was added
    Auto-completion and object search was fixed
    Schema list reading was fixed
    Views, triggers and stored procedures editor was added
    Foreign key navigation was fixed
    Metadata read was improved

Sybase: stored procedures reading was fixed
Greenplum:

    External tables browser was added
    Greenplum-specific tables DDL was added

PostgreSQL:

    Problem with RDS/SSL connections was resolved
    Data types reading was fixed
    Extra tables and indexes statistics was added
    Debugger break-point toggle command was fixed

Exasol: comments edit support was added
SQLite: metadata editor was fixed
MS Access: metadata reading was fixed
CSV: export/import settings save/load was fixed
SAP HANA: native table DDL reading was added
Dark theme: data editor colors were fixed
Windows installer now supports silent instalation (/S and /D flags
see WIKI)
Unexpected editors “modified” mark was removed (Linux Mint)
CSV: export/import settings save/load was fixed
Older Eclipse (Mars) now supported by plugin version
Object delete confirmation message was fixed
Dangerous confirmation popups were removed
Workspace switching (from menu) was fixed
Numerous localization bugs were fixed
Many minor UI bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Fixed "#37 PostreSQL: transactional execution"
Fixed "#36 Data Export Dialog: Some settings are 'lost' between Exports"
FR "#62 subsequent Analyze database, new links fate", only the new "parent-> detail" relationships will be disabled.
FR "#61 Information about exported rows"
Fixed issue 10, "Export to SQLite - Boolean values", #10

http://jailer.sourceforge.net/

[SiLæncer]

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface. Includes:

    MySQL Server user management
    Database management (modify databases, tables, fields, indexes)
    Data browsing and modification (including search filters, blob editing)
    MySQL session management (can kill queries)
    SQL query execution, including SQL batch scripting (and MySQL function list)
    Import/export of data

Functional in Linux via WINE.

License: GPL

Changelog

Most noticable new features and enhancements:

    Basic support for high DPI scaling on modern screens with 4K resolutions (work in progress)
    Theme support: many stylish themes selectable, dark and light ones, and even one user contributed dark Material theme
    Predefined color presets for data types and SQL code in preferences dialog
    Support for connecting to MySQL 8 servers, with the help of caching_sha2_password plugin from MariaDB
    Portable version downloads now have a portable.lock file, and do no longer overwrite your portable_settings.txt
    Auto uppercase writing of SQL keywords in editors
    Switch to Microsoft OLE DB driver for SQL Server connections, to support TLS 1.2 secured connections
    Data grids with highlighted cells in view port having the same content as the focused one
    No Direct2D overriding required anymore when running on Wine
    more solved issues

[close]

http://www.heidisql.com/

[SiLæncer]

Changelog

The security fixes involve:

Arbitrary file read vulnerability (https://www.phpmyadmin.net/security/PMASA-2019-1)
SQL injection in the Designer interface (https://www.phpmyadmin.net/security/PMASA-2019-2)The arbitrary file read vulnerability could also be exploited to delete arbitrary files on the server. This attack requires that phpMyAdmin be run with the $cfg[‘AllowArbitraryServer’] directive set to true, which is not the default. An attacker must run a malicious server process that will masquerade as a MySQL server. This exploit has been found and fixed recently in several other related projects and appears to be caused by a bug in PHP (https://bugs.php.net/bug.php?id=77496).

In addition to the security fixes, this release also includes these bug fixes and more as part of our regular release cycle:

Export to SQL format not available
QR code not shown when adding two-factor authentication to a user account
Issue with adding a new user in MySQL 8.0.11 and newer
Frozen interface relating to Text_Plain_Sql plugin
Table level Operations tab was missingAnd several more. Complete notes are in the ChangeLog file included with this release.

[close]

https://www.phpmyadmin.net/

[SiLæncer]

This is a new release which mainly fixes the installer, which named the executable in your program files folder "heidisql32.exe", not "heidisql.exe". Sounds minor, but I suppose there are quite a few links out there still pointing to heidisql.exe. The 10.1 installer now deletes that heidisql32.exe and installs the fresh heidisql.exe.

http://www.heidisql.com/

[SiLæncer]

Changelog

Connection List :
Add: Duplicating Connections (including: Connection Manager ) (6967)
Security Manager :
Add: (SQL Server) New Change SQL Server Authentication Mode (6967)
Add: (SQL Server/SQL Azure) User Password Modification (Password), Add Sub-option Enforce password policy setting (6967)
Add: (SQL Server/SQL Azure) Expiration of the user account (Expire), change to [Change settings only], [User must change password at next login) setting (6967)
Add: Object list right-click menu function is added to the work column (6967)
Add: (Firebird 4+) System privileges for Roles : Added Firebird 4.x latest permission settings (6967)
SQL Editor ( SQL Editor ):
Add: Add additional instruction processing ( SET SERVEROUTPUT ON ): Outputting from the DBMS_OUTPUT message for IBM DB2/Oracle (6967)
Secure Shell Agreement ( SSH: Secure Shell ):
Add: Support for private key with password (Private key with a password) (6960)
Fix: Fixed an issue where remote SSH could not be processed (6959)
Data Import :
Fix: Correct the data sheet data import source name designation problem, avoiding the change caused by other processing (6959)
Table Designer :
Fix: (Oracle) Resolving issues that may cause ORA-01451 when modifying field types (6959)
Main program update ( Main ):
Upd: compatible with Windows 10 Insider Preview 18305 and higher Latest version (6967)
Add: User Interface: The theme mode adds the Dark Mode sub-option, no need to be modified (6967)
Upd: User Interface: Simplify processing, re-select theme mode to reset ( Reset ) (6967)
Fix: (NuoDB) Fixed a problem with the format of the field length generated by DECLARED_TYPE (6967)
Upd: Others include cumulative small updates, corrections and optimizations (6967)
Misc: Compatible with Compatible with MySQL 8.0.14 / MySQL 5.7.25 / MySQL 5.6.43 (2019/01)
Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (6967)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

New "Model Migration Tool" allows you to easily find and edit the newly added associations if the data model has been extended after the last change to this extraction model.

http://jailer.sourceforge.net/