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.

Whats new:>>

    Added custom formulas validation in Expression Builder.
    Improvements in exporting data to SQL Server and SQLite databases. [Pro and Enterprise editions]

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    SQL editor: multiline code templates apply was fixed (thanks to @VASilaev)
    Number of bugs were fixed in the Simple navigator view
    Transaction management was improved (redundant transaction commit confirmations were removed)
    GIS viewer: many new (and cool) tiles were added (thanks to @mkgrgis)
    Active catalog/schema selector UI was improved
    Connection edit dialog was fixed (error during page switch)
    HANA: unique key creation was fixed
    Firebird: procedure metadata refresh was fixed
    Problems with remote RDP connections (app crash) were fixed
    Japanese localization was significantly improved (thanks to @ScratchBuild)
    We have migrated to Eclipse platform 2020-03
    Many other minor bug fixes and improvements

    Data viewer:

    Problem with unreachable last row/column was fixed
    “Open With” action now uses configuration from last data export
    Find/replace issues were fixed (scroll to found cell)
    Bug in reference panel was fixed (multiple value selection)
    Filter value auto-completion was fixed (popup close)
    Virtual unique keys management was improved

    Oracle:

    Connection settings (SID/Service) save was fixed
    Session terminate was fixed (for non-RAC databases)

    Exasol:

    Foreign key creation was fixed
    View DDL extraction was fixed (auto-format was disabled)

[close]

https://dbeaver.io/

[SiLæncer]

Thoroughly organize, analyze and share large datasets with the help of this open-source and quite good-looking piece of software.

License: GPLv3

Changelog

    Enhancements:

    Improved error log messages on async responses (#12233)

    Bug fixes:

    Fixed a bug where homepage is missing sections (X-rays and Our data) on login with Google Signin (#12359)
    Fixed an issue where it was not possible to view or restore a table after setting Visibility to "Hidden" in Data Model (#12344)
    Corrected replace function name (#12306)
    Fixed an issue where saving native queries failed due to incomplete results_metadata (#12265)
    Fixed an issue where a query with the same column names didn't display properly (#12252)
    Fixed query failing on "Error reducing result rows" (#12251)
    Fixed regression with column not found error after adding a custom column (#12243)
    Fixed MBQL normalization bug (#11897)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Improvements in export logging of higher level: more events are registered; minor changes in format.
    Improvements and bugfixes in export UI.
    Improvements in custom formulas validation.

http://www.vlsoftware.net/

[SiLæncer]

A powerful and practical software utility specifically built to extract data from databases and improve performance by removing obsolete entries.

Apache License 2.0

Whats new:>>

    "#66 Avoid plain text passwords on the command line"
    Minor improvements to GUI of the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

Relational data browsing application that allows you to gain valuable insight into both the table and the interrelation of the rows.

Apache License 2.0

Whats new:>>

    "#66 Avoid plain text passwords on the command line"
    Minor improvements to GUI of the data browser.

https://sourceforge.net/projects/dbeauty/

[SiLæncer]

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Changelog

    Added LDAP authentication support.
    Added search object functionality.
    Added support of Foreign Tables, Packages, Sequences and Synonyms to the Schema Diff.
    Warn the user if an unsupported, deprecated or unknown browser is detected.
    Added multiple drop/delete functionality for the table constraints.
    Fixed copy-paste row issues in View/Edit Data.
    Added dark mode support for the configuration dialog on Windows/macOS runtime.
    Added alert message to Reset Layout if any of the panels from Query Tool failed to load.
    Fixed an issue when the user performs refresh on a large size materialized view.
    Ensure that default sort order should be using the primary key in View/Edit data.
    Fixed an issue where changing the values of columns with JSONB or JSON types to NULL
    Ensure that if the delimiter is set other than comma then download the file as '.txt' file.

[close]

https://www.pgadmin.org/

[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

-SQL Editor ( SQL Editor ):

   Add: Support automatically jump to the error line (or position) (Automatically jump to the error line or position) (7428)
   Support including SQL Server / SQL Azure / SQLCe / Firebird / PostgreSQL / MySQL / VistaDB / NuoDB and other database
   Upd: improved RegEx search and replace process ( Finding and Replacing ): avoid the import process generates an exception message (7428)
   Upd: all matching word under the cursor is highlighted ( highlighting All matching words an under the cursor): Exclude the currently selected word processing (7428)-Code

Manager ( Code Manager ):

   Add: File sorting support by name or by date (Sort files by Name or Modified) (7428)-Add
vertical label mode ( Vertical Mode Tabs ) (64bit):

   Fix: corrected [cancel] to close the locking tab and re-selected questions will be asked in case the label (7428)

- automatically and perception ( autoComplete and IntelliSense ):

   the Add: support from the brackets (sELECT. ..) AS alias subquery's field-aware processing (7428)
   Upd: Optimized bracketing (SELECT cols ...) subquery's field-aware processing (7428) -Generating scripts

( Generating Scripts ):

   Fix: (NuoDB ) revised composite index (composite index) field scheduling problem (7428)
- query design tools ( query Builder )
   Upd: improved user experience with windows display problems (7428)

- the main program update ( main):

   Upd: (SQL Server / SQL Azure / Sybase ASE) Modify the object rename processing method, retain the original clipboard content for easy paste processing (7428)
   Upd: (SQL Server / SQL Azure / Sybase ASE) Object prefix is ​​structure The description is changed to the default (schema.object), and the original change settings are canceled (7428)
   Fix: Fix the problem that the object rename cannot contain . Characters, if the database itself supports (7428)
   Fix: Fix delete the server version database (Drop Database) and structure description (Drop Schema) related issues processing (7428)
   Upd: a large number of reference links update and correction (7428)
   Upd: update Database.NET Additional Files ( 32bit / 64bit ) (2020/05/03) (7428 )
      Add: Support MySQL 8.0.20 and PostgreSQL 12.2 latest version database backup and restore (7428)
   Upd: Others include cumulative minor updates, corrections and optimizations (7428)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    SQL editor:

    Format now formats active query by default
    Matching brackets highlighting was improved

    Data viewer:

    Find/replace highlighting and scrolling was fixed
    Data filter save was fixed (problem with quoted column names)
    Auto-completion in data filter now can be disabled
    Object editor: refresh button in bottom toolbar was unified for all pages
    Dark theme support improved (connection type colors)
    New connection wizard was fixed (problem with quick driver selector)

    Driver editor dialog was improved:

    Extra properties save was fixed
    Legacy drivers support was added
    Git extension packaging was fixed (older Eclipse versions support)
    Derby: new database create was fixed
    Firebird: system objects hide/show was fixed (determine system flag from fro meta table)

    MySQL:

    Read-only connections support was fixed (SQL editors)
    Query execution plan explain was fixed

    Oracle:

    Driver configuration was fixed (typo in Maven artifact name)
    Java classes source viewer was added
    Materialized view DDL read was fixed
    PL/SQL parser was fixed (CASE/WHEN/END)

    PostgreSQL:

    search_path update was fixed
    Numeric values rendering was fixed
    Redshift: SOCKS proxy support was fixed
    SQL Server: table DDL generation was fixed (column type names)
    SQLite: foreign key metadata read was fixed (FKs with no name)
    Portuguese (BR) localization was added (thanks to @wellesximenes)
    Many minor bug fixes and improvements

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

The new "Degree view" allows quick and easy editing of the associations of tables with the highest connectivity.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

The new "Degree view" allows quick and easy editing of the associations of tables with the highest connectivity.

https://sourceforge.net/projects/dbeauty/

[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

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

[SiLæncer]

Changelog

    Data viewer:

    Pin (aka “freeze”) column feature was added
    Float (32bit) data type render was fixed (MySQL)
    Plaintext renderer was fixed (binary values representation)
    Filter value auto-complete was fixed (clipboard paste support)
    Issue with “order by table column + column alias” was fixed

    SQL editor:

    Script close prompt was fixed
    Hyperlinks now contain procedure parameters
    Script selector panel positioning was fixed
    Execute in new tab: new tabs opening was fixed
    SQL format preferences page was improved
    SQL formatting was fixed (line feeds after brackets)
    SQL console title was fixed (source object name was added)
    Non-https Maven repositories and driver links were removed

    PostgreSQL:

    Added parameters to the SQL execution plan explain (ANALYSE is optional)
    Database backup was fixed on Linux/MacOS (proper table names quoting)
    Table DDL was fixed (show table comment)
    Sequence DDL was fixed (START parameter)
    Object dependencies now contain links on dependent/depending object
    Permission/role editors were fixed (roles are sorted by name now)
    SQL auto-completion fixed for older PG (<= 8.4)
    Oracle: unique key detection was fixed

    DB2:

    FOR BIT DATA columns support was fixed (show value as binary)
    Native SQL dialect support was improved (BEGIN/END)
    SQLite: ROWID pseudo-column support was added (as unique key)
    Many other minor bug fixes and improvements

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Automatic completion and perception ( AutoComplete and IntelliSense ):

    Add: Support SYNONYMS synonymous data table [field] perception processing (7445)
    Support database including SQL Server / SQL Azure / Oracle / IBM DB2 / Informix
    Add: Cross database (Cross-database) and cross schema (Cross-schema): Added support VIEWS objects (7445)
    Upd: update selected and inserted into the table sYNONYMS synonymous object-related processing (7445)

    rows browsing and editing (the data browser and editor ):

    Upd:Optimized code to enhance the results column shows the rate (7445)
    data import ( the Data Import ) / export data ( the Data Export ):
    Upd: optimizing code to improve data import / export processing speed (7445)

    data exchange ( Data Export ):

    Upd: Optimize and improve the export format processing (including XLSX / XLS / HTM / MD / JSON / XML and other formats) (7445)-Connection
    Manager ( Connection Manager )
    Add: add connection name Search function (Search connection names) (7445)
    Add: support to remove connection and delete database multi-select processing (7445)-Connection Process Manager

    ( Connection Process Manager ):

    Add: support filter condition expression processing (Filter Expression) (7445)
    Fix: Fix the problem of refreshing when switching between different databases or structure descriptions (7445)-SQL

    Editor ( SQL Editor ):

    Add:Automatically jump to the error bar (or location) When an error occurs: Add Oracle database support (7445)-Main

    program update ( Main ):

    Add: Support HP Vertica 10 latest database system (7445) to
    solve the bug of ver 10 itself , When reading DataTypes, the problem of StackOverflowException is
    Upd: to avoid interruption of the processing of some database types, which may lead to exceptions (7445)
    Fix: improved Quick Filtering Objects synchronous input search processing problem (7445)
    Upd: other minor updates include the cumulative correction and optimization (7445)

    database migration ( database migration ) (Pro):

    Upd: all updates with dbMigration .NET software (7445)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Improved database metadata management.
    Increased initial responsiveness of the Data Browser.

http://jailer.sourceforge.net/