Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

Fix new crash in ConnectionInfo (mouse over server version status panel)

http://www.heidisql.com/

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

Fixed a bug that caused the creation of a delete script to generate syntactically incorrect SQL statements when a table without a primary key exists.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

            - Git integration:
                - Create projects in remote repositories
                - Pull/commit/push automation from the DBeaver perspective
                - Integrate existing projectys with Git repositories
            - Problem with SSH and SSL connections was solved
            - Problem with missing legacy character encoding was fixed
            - Data editor:
                - "Delete cascade" feature was added
                - Problem with column order was fixed (when result contains multiple columns with the same name)
                - Problem with duplicated values in column filters was fixed
                - "Default" values were added for numbers, strings and booleans
            - Data transfer:
                - Export to a single file was fixed
                - TXT format: extra options were added
                - CSV import: timestamp columns parser was fixed
            - PostgeSQL:
                - Extensions management was added
                - Partitions DDL was added
                - Partitions create/drop support was added
                - Object description reading was fixed (+ problem with duplicated objects was solved)
                - Complex data types rendering was fixed
                - float4 data type support was fixed (wrong value render)
            - Greenplum: ERD renderer was fixed
            - Orclele:
                - Problem with read-only tables was fixed (for some Oracle versions)
                - View management: problem with semicolons was fixed
            - DB2 for iSeries:
                - Procedures DDL was added
                - Problem with schema list reading  was fixed
            - Generic driver (SQLite and others): problem with view create command was fixed
            - Plenty of minor UI bugs were fixed

[close]

https://dbeaver.io/

[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

Changelog

    Changes for RecordEditor version 0.99 include:

    2 new Open file dialogs
    Clasic option which is an enhanced version of the current

    File Descriptions can be retrieved from:

    RecordEditor Databases
    Derived from Csv / Xml files
    Cobol Copybook / Xml Schema
    New enhanced File fields.

    New Open File Dialog:

    There are 2 new open file dialogs both support recent files and favourite files.
    Both open file dialogs support reading File descriptions from
    Classic Recordeditor Open with file field, RecordLayout selection on the left and a preview on the right hand

    ClassicOpen:

    File List Open

    ClassicOpen:

    File Preview:

    A file preview is displayed on the right hand side of File Open panel
    There are 2 option for File fields
    Bread crumb folder style
    Bread_Crumb_File_Field
    Text field (optionally with file completion

    Text:

    Cobol:

    For single files, you can edit with a Cobol Copybook using the schema tag.
    There is a file preview on the right side of the screen

[close]

Download hier : https://sourceforge.net/projects/record-editor/files/Test/

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

[SiLæncer]

Changelog

    Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option.
    DSQLITE_DQS=0 is now a recommended compile-time option.

    Improvements to the query planner:

    Improved optimization of AND and OR operators when one or the other operand is a constant.
    Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity.
    Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt.

    Enhancements to the CLI:

    Add the ".recover" command which tries to recover as much content as possible from a corrupt database file.
    Add the ".filectrl" command useful for testing.
    Add the long-standing ".testctrl" command to the ".help" menu.
    Added the ".dbconfig" command

    Hashes:

    SQLITE_SOURCE_ID: 2019-07-10 17:32:03 fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6
    SHA3-256 for sqlite3.c: d9a5daf7697a827f4b2638276ce639fa04e8e8bb5fd3a6b683cfad10f1c81b12

[close]

https://www.sqlite.org/index.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 to display GUID columns. (In previous versions, the code to display GUID columns was missing and the GUID columns remained empty)

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

[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

    Main program update ( Main ):

    Add: Added Dutch language interface display (7139)
    Fix: Improve browsing display efficiency, when the AllowDBNull field is returned to DBNull (7139)
    Upd: (Firebird) Optimize database restore processing (Restore DB): Inherit the current connection settings to save the reset processing (7139)
    Fix: (Firebird) Fixed a problem where the Decimal data type could not be displayed properly under SQL dialect 1 (7139)
    Fix: Fixed the problem that the main window may be closed directly after the auto-complete list is turned on (7139)
    Upd: Optimize ODBC Dialog Display Processing (7139)
    Upd: [Secondary] Solving the problem that PostgreSQL may cause Unsupported startup parameter: extra_float_digits when connecting through a mediation program (7139)
    Upd: (32bit) Target .NET Framework (Target .NET Framework) upgrade from 4.0 to 4.5.2 (same as 64bit version) (7139)
    Upd: Others include cumulative small updates, corrections and optimizations (7139)

    Script Generator :

    Fix: Keep GO split command processing (and remove settings), avoid problems that cannot be handled properly when generating a single command file (7139)

    Generating Scripts :

    Fix: When the data table instruction code is generated, different object creation is processed by GO split command (7139)

    Multiple selections :

    Fix: Fixed related problem handling after Ctrl cancels the current node (7139)
    Fix: Fixed related problem processing after node re-brushing (7139)

    Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
    A warning message appears if the number of collected rows differs from the number of exported ones.
    The performance of the preparation for the subsetting-process has been improved.
    Extraction models can now be loaded from the "Data Model Manager" dialog.
    It was not possible to pass user / password via cli when it starts with '-'
    Updated local database to H2 1.4.199.
    The fonts selection in the GUI has been standardized.
    Improved error handling in the data browser.
    If the same error occurs multiple times because it affects multiple table browsers,
    it will be displayed only once.

[close]

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

            New project configuration format was implemented. Main advantages:
                - Better security (now we keep user credentials separately)
                - Better support for version control systems (e.g. Git)
                - Now we use standard (OS-specific) directories for configuration location
            Major features:
                - Logical foreign keys
                - Data viewer: "References" panel was added (browse values by foreign and reference keys)
                - Network profiles support was added: you may configure SSH/Proxy settings once and reuse them for any number of connections
            Other:
                - Connection page was redesigned
                - Data viewer filter panel UI was improved
                - Snowflake: procedures DDL, connection page fix
                - Google Spanned database support was added
                - PostgreSQL: struct/array data types support was fixed
                - MySQL: privileges viewer was fixed (global privileges grant/revoke)
                - DB2 i: procedure list and DDL reading was fixed
                - Many minor UI bugs were fixed

[close]

https://dbeaver.io/

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

Changelog

    Minor interface changes and bugfixes.
    Minor changes in command line processing.

[close]

http://www.vlsoftware.net/

[SiLæncer]

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

License: Open Source

Changelog

    Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable.
    Add EXPLAIN options for SETTINGS and SUMMARY.
    Set the mouse cursor appropriately based on the layout lock state.
    Prevent flickering of large tooltips on the Graphical EXPLAIN canvas.
    Fix an error while retrieving json data from the table.
    Fix 'malformed array literal' error when updating a pgAgent job.
    Fix an error that could be seen when editing column privileges.
    Fix an error seen when updating a connection string in a pgAgent job step.
    EXPLAIN options should be Query Tool instance-specific.
    Allow keyboard navigation of all controls on subnode grids.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Data Browser and Editor :
    Add: Supports virtual mode display processing: Display the [required part] in the Just-In-Time mode instead of the original [one load all] process (7156)
    Can greatly increase the display speed of a large number of data columns, while also greatly reducing the memory footprint
    Main program update ( Main ):
    Add: Support for Oracle 19c database system (7156)
    Add: Support for NuoDB 4.0 database system (7156)
    Add: (NuoDB/PostgreSQL/HP Vertica/IBM DB2/Oracle) Specify Current Structure (Current Schema) Processing (7156)
    Fix: (NuoDB) Fixed an issue where the connection error message could not be correctly obtained (7156)
    Upd: MySQL component version updated to MySql.Data.dll 6.10.9 (2019/07/29) ( ) (7156)
    Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 6.7.0.0 (2019/07/25) ) (7156)
    Upd: Teradata component version updated to Teradata.Client.Provider.dll 16.20.7.0 (2019/07/10) ) (7156)
    Upd: Others include cumulative small updates, corrections and optimizations (7156)
    Visual Execution Plan :
    Upd: Optimize content display, distinguish between text and digital colors to make content reading more intuitive (7156)
    Generating Scripts :
    Add: (NuoDB 4.0+) Supports Expression Indexes script generation processing (7156)
    Data Browser :
    Fix: Fix the results to text field with a minimum width of 4, avoiding NULL beyond the display range (7156)
    Data Export :
    Fix: Correct the export Markdown (*.md) data format field minimum width is 4, avoid NULL beyond the display range (7156)
    Fix: Fixed (7044) when the field type is Decimal and is Null, the case is treated differently (7156)
    Data Editor :
    Fix: Fixed (7044) Undoing the problem after the field type was Decimal (7156)
    Object Authorization Management ( Grant Manager ):
    Fix: (MySQL/MariaDB) Fixed an issue where user syntax changes could not be opened (7156)
    Security Manager :
    Fix: (MariaDB) Fixed an issue where user syntax changes could not be opened (7156)
    SQL Performance Analyzer ( SQL Profiler ):
    Fix: (MySQL/MariaDB) Fixed an issue where Global Mode initialization sometimes failed to handle properly (7156)
    Database Migration (Pro):
    Upd: All updates are the same as dbMigration .NET Software (7156)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Many problems with workspace migration were fixed
    Entiy diagrams: logical foreign keys can be created/deleted right in the diagram editor
    Data transfer: auto-generated (identity) columns handler was added
    DDL generation: now we generate tables DDL according to their foreign keys order
    Geometry viewer: simple (flat) geometry support was added
    Execution log: reading of row count for DML statements was fixed
    Apache Hive: many bugfixes related to complex (struct/array) data types handling
    Apache Drill: driver was fixed (missing JDK modules were added)
    Many other minor UI bugs were fixed
    Data viewer:
    UI look and feel was significantly improved
    New interface for rows/columns coloring
    Logical foreign key creation was simplified
    Many bugs were fixed in References panel rendering
    Column filters UI was fixed (dups, dictionary reading errors)
    Unique key detection was fixed (use indexes with nullable columns if no other identifiers found)
    SQL Editor:
    SQL formatter was fixed (DECLARE statements)
    Copy SQL to Java code was improved (thanks to loro2)
    PostgreSQL:
    Array data type handler was fixed
    Indexes metadata reading was fixed
    Execution plan visualization was fixed for CTE nodes
    SQL Server:
    Support of identity columns creation was added
    Session manager was fixed
    Oracle:
    Scheduled jobs metadata reading was fixed
    Session management was fixed for RAC mode
    Firebird: views and indexes metadata reading was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Minor bugfixes in export field mappings interface.
    Better building the field type mappings in database-to-database exporting.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    The layout optimizer of the export progress dialog has been improved.
    The tutorial has been improved.
    Minor fixes and improvements.

http://jailer.sourceforge.net/