Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Command Line Processing ( Command-line ):

Fix: Servo database direct connection processing: Fixed parameters [-e winauth] No effect of the problem (6544)
Upd: Servo Database Direct Connection Processing: Improved Defaults to [-e winauth] when no user and password are specified Login method can be omitted (6544)

Main program update ( Main ):

Fix: Fixed an issue where the update process was not working when the Teradata database password expired (6544)
Upd: Others Including Cumulative Minor Update, Correction and Optimization (6544)

Database Migration (Pro):

Upd: All Updates Same as dbMigration .NET Software (6544)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- Main program update ( Main ):

Fix: (Firebird) Fixed Remote Connection Problem (6547)
Fix: Problems Avoiding Illegal Characters in Path (Effects Contain Multiple Functions) (6547)
Upd: Multiple Controls Rewrite and Optimize (6547)
Fix: Fixed an issue where the update process was not working when the Teradata database password expired (6544)
Upd: Dramatically Boosts Processing of Last Query Tabs (6540)
Add: Add Shortcut Expand / Collapse a Node and Open a DB: Enter (6540)
Upd: HP Vertica Component Version Updated to Vertica.Data.dll 9.0.0.2 (2017/11/22) (6540)
Upd: Firebird Component Version Updated to FirebirdSql.Data.FirebirdClient.dll 5.12.0.0 (2017/11/15) (6540)
Upd: Others Including Cumulative Minor Update, Correction And Optimization (6547)

- Command Line Processing ( Command-line ):

Fix: Servo database direct connection processing: Fixed parameters [-e winauth] No effect of the problem (6544)
Upd: Servo Database Direct Connection Processing: Improved Defaults to [-e winauth] when no user and password are specified Login method can be omitted (6544)

- Data Export :

Upd: Update XML Export Format: Add XSD Schema Definition Display (6540)

- Database Migration (Pro):

Upd: All Updates Same as dbMigration .NET Software (6547)

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

Minor changes and bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

UI localizations (Chinese, Russian, German) were added back
Database navigator: new objects (tables, views, columns) create was fixed
SQL Editor: active query extraction/parse was fixed
SQL Editor: proposals auto-activation was fixed
SQL Editor: compact SQL formatter was added
Results viewer: data types coloring support was added
Results viewer: cell value editor
Results viewer: dictionary edit dialog was fixed (custom criteria)
Driver manager dialog was improved (driver copy, sorting)
Main toolbar was slightly redesigned
Support environment variables in connection properties
Navicat connections configuration import was added
Some icons were updated (application, SQL editor)
Find/replace dialog was added in text edit fields (from context menu)
PostgreSQL: basic partitions and inheritance support in database navigator
PostgreSQL: view edit/create was fixed
Vertica: 7.x-9.x driver configuration
Neo4j driver configuration was added

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Data Import :

Upd: Multiple Improvements and Optimizations to Improve Import Processing Speed ​​(6557)
Fix: the first importation of split documents without the name of the column records the problem (6557)

AutoComplete and IntelliSense :

Upd: Boost Auto-sensing Processing Speed ​​and Reduce Unnecessary Perceptual Processing (6557)

Text Execution Plan :

Upd: (SQLite) Support Comment Analysis Message Display (6557)

Connection Profile :

Upd: Enable to choose whether or not to overwrite the old settings when a new server version name already exists (6557)

Main program update ( Main ):

Upd: ICON Display Problems with Update Object Disabled (6557)
Upd: Improved Menu Items ToolTips Show Questions (6557)
Fix: Database Tools: Fixing the Problem of Deleting Fileshed Repositories (6557)
Upd: Others Including Cumulative Minor Update, Correction and Optimization (6557)

[close]

http://fishcodelib.com/Database.htm

[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

New features:

    Expect regular expression in filter text on right panel, not a simple string. Keep searching case insensitive, as in prior logic. Add text hint to filter box so the user knows he can enter a regular expression here. Closes #45.
    Add new TAction for clearing query log, and assign it to the rightclick menu item of it. Give this new action the hotkey Ctrl+Q. Closes #25.
    Add custom setting for number of days to keep queries in the query history. See https://www.heidisql.com/forum.php?t=23530
    Use the grid export dialog for setting values for copy-to-clipboard clicks on grids. Adds a new button in the lower left on that dialog. See https://www.heidisql.com/forum.php?t=23190
    Support grouping by tree node type in "check xyz" menu items on table tools dialog. See https://www.heidisql.com/forum.php?t=23351
    Include ADO connection string in status bar connection details, shorten the lines reasonably and show the full lines in a message box when clicking on it. See http://www.heidisql.com/forum.php?t=23049
    Support SQL security setting in view editor via drop down menu. See http://www.heidisql.com/forum.php?t=21740
    Use the right SQL commands for killing a process on PostgreSQL. See http://www.heidisql.com/forum.php?t=21760

Bugfixes:

    Prevent accessing non existing string list item in TMainForm.ListDatabasesGetText, to fix a sporadic crash after dropping a database. Closes #33
    Temporarily disable local number formatting in data grid while the search dialog is open. Closes #30.
    Prevent TMainForm.DisplayRowCountStats from crashing due to no current table/view/...
    Don't export data for virtual columns. Fixes #5.
    Simplify regular expression for extracting column details in ParseTableStructure(), so it does not barf on huge length/set. Fixes issue #2.
    New attempt to fix menu and buttons flicker on Win10, this time by with the help of Delphi Detours library. See https://www.heidisql.com/forum.php?t=19141
    fix exception in early stage of table editor initialization
    Fix detection of column types with DEFAULT CURRENT_TIMESTAMP(123). See https://www.heidisql.com/forum.php?t=17585
    Reduce flicker on Windows 10. See https://www.heidisql.com/forum.php?t=19141
    Silence dumb exceptions from mysql_ping() call. See https://www.heidisql.com/forum.php?t=23483
    Fix typos in encoding of xml exports. See https://www.heidisql.com/forum.php?t=23421
    Prevent inserting cell text ellipsis in query tab. See https://www.heidisql.com/forum.php?t=23353
    Work around access violation in highlighter, which raises after a successful reconnect. See http://www.heidisql.com/forum.php?t=23009
    Fix sloppy regular expression in TDBConnection.DetectUSEQuery which removes too much of trailing quotes in a database name. See http://www.heidisql.com/forum.php?t=22743
    Escape quotes and stuff in JSON keys and values. See http://www.heidisql.com/forum.php?t=22747
    PostgreSQL: query timeout is set in milliseconds, not seconds. See http://www.heidisql.com/forum.php?t=22645
    Inject a line break after the data grid WHERE filter and before a potential ORDER BY and/or LIMIT clause. This way the filter may end with a comment without breaking the rest of it.
    Fix compiler warning
    Fix crash when taskbar button interface is not available for some reason. See http://www.heidisql.com/forum.php?t=22451

Enhancements:

    Support quote chars other than the relevant one within identifiers. For example "mycolumn" or "mycolumn" ... or even worse: "``mycolumn". Closes #44.
    Send donators’ e-mail addresses encrypted
    Update url to issue tracker and copyright year
    SynEdit's SQL highlighter provides a sample source text. Display that text in the preferences editor panel for SQL colors.
    Update gettext binaries, from http://svn.code.sf.net/p/dxgettext/code/trunk/buildtools . The old msgfmt.exe creates endless processes on Win10, not so this one.
    Remove debug code. See https://www.heidisql.com/forum.php?t=24400
    Extend TMySQLOption enumeration with newer items
    unify context menu of various sql editors, by supporting all contained editors instead of searching for one with the name "SynMemoBody"
    Trigger OnChange event on TSynMemo after toggling comment, so a save button gets enabled. See https://www.heidisql.com/forum.php?t=23834
    Save session tree color when creating a copy of a session. See https://www.heidisql.com/forum.php?t=23796
    Use new copy-columns icon in main image list
    Create a nicer icon for "Copy selected columns/rows"
    Create a new menu item for copying rows to clipboard, and assign Ctr+Shift+C to it. See https://www.heidisql.com/forum.php?t=23190#p23490
    Support auto_increment flag on indexes other than primary or unique, on copy table dialog. If that still fails, give the user a hint to select the right index. See https://www.heidisql.com/forum.php?t=23383
    Add "<server default>" to the engine drop down on the table editor, and make that the new default, so we leave the ENGINE=.. clause away. See https://www.heidisql.com/forum.php?t=23363
    Use HTTPS for all web requests on heidisql.com
    Update SynEdit component code to v2.0.9 beta from https://github.com/SynEdit/SynEdit/releases/tag/SynEdit-2.0.9-beta . Just a few additional highlighter keywords and one code change for background coloring included.
    Attempt to add an error string which Windows provides after a failed call to LoadLibrary. See http://www.heidisql.com/forum.php?t=22514
    Make Markdown export code compatible to the parser on gitlab.com, by using 3 dashes instead of 1, below header columns. See http://www.heidisql.com/forum.php?t=22991
    Increase width of "name" field on view editor to the same value as it's on the procedure editor.
    Reasonably increase and unify design time dimensions of object editors to 700x500 pixels
    Remove per-row comment in PHP array grid export, which blows up the result. See http://www.heidisql.com/forum.php?t=22749#p22798
    Don't encode html entities but escape quotes in JSON grid export. See http://www.heidisql.com/forum.php?t=22747#p22783
    Use double quotes for PHP values when exporting a PHP array from a grid. See http://www.heidisql.com/forum.php?t=22749
    Try to load libpq.dll with explicit file path if the path-less did not succeed. See http://www.heidisql.com/forum.php?t=22514
    Cast unknown data type columns as text when generating a multi column filter from user input. See http://www.heidisql.com/forum.php?t=22562
    Remove quirky logic from TMySQLQuery.Execute when distinguishing between text and binary data types. See http://www.heidisql.com/forum.php?t=22441

[close]

http://www.heidisql.com/

[SiLæncer]

Whats new:>>

Notable changes since 4.7.6:

    Fixed displaying of formatted numeric values for some locales
    Fixed PHP error when browsing certain results

There are several more improvements; please refer to the ChangeLog for full details.

https://www.phpmyadmin.net/

[SiLæncer]

Changelog

New custom DBeaver icon set was added.
×32 icons for HighDPI minotors
Entity editor UI was improved (properties panel)
Stored procedures execute console
Referencing tables navigation fix
Unique key create dialog was fixed
Quick filter for procedures
Object delete dialog was improved (CASCADE delete support)
Main menu localization was fixed
SQL Server/Sybase: schema list read was fixed
PostgreSQL: child tables navigation was fixed
PostgreSQL: money data type support
PostgreSQL: table DDL generate fix
Oracle: table DDL generate fix
Oracle: queues metadata (read-only)
Firebird: separate drivers for 2.x and 3.x
HANA: views/procedures DDL extraction
Generic: show all table triggers in catalog/schema
Main window title rendering was fixed (confiruable)
Minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

MDB Viewer Plus is a tabbed viewer/editor for Access MDB files. It provides a quick and easy way to create, view, edit and search/querry MDB files without having Microsoft Access installed. It is not a full database development solution but allows you to view/edit MDB files without an Access license.

Imports and exports to a variety of formats.

License: Freeware

http://www.alexnolan.net/software/mdb_viewer_plus.htm

[SiLæncer]

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Changelog

Update built-in DISQLite3 engine to SQLite 3.21.0.
Add the CSV extension.
Example: CREATE VIRTUAL TABLE t1 USING csv(filename='thefile.csv');
Add the DBPAGE extension.
Example: SELECT data FROM sqlite_dbpage('main');
Add the CHECKFREELIST SQL function.
Example: SELECT checkfreelist('main');
Add the SHA3 extension.
Example: SELECT sha3('abc', 256);
Add the SHA1 extension.
Example: SELECT sha1('abc');
New menu item and SHIFT+F9 shortcut for EXPLAIN QUERY PLAN SQL.
Improve updating the SQL status in case of errors.

[close]

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

Whats new: >>

Minor changes and bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Ermöglicht den modellbasierten Datenexport aus relationalen Datenbanken; extrahiert konsistente, referenziell intakte Daten aus produktiven Datenbanken und fügt sie in Testdatenbanken ein; entfernt zudem alte, nicht mehr benötigte Daten aus der Datenbank, ohne die Integrität der Datenbank zu verletzen; generiert DbUnit-Datasets, strukturiertes XML und sortierte SQL-DML-Statements.

Lizenz: Open Source

Changelog

data browser improvements:

Outline-view for SQL statements.
In-place editing of query results.
Column filtering in data browser.
Improved table search feature.
Ability to execute SQL fragments.
Constraint checking tool.
DDL view for tables.

[close]

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: (SQLite) Supports SQLite AES256 Encryption Database Management (Simultaneous AES256 / RC4 Encryption Database) (6578)
Upd: (Access / Excel / dBASE / Text) Supports Different Component Versions Provider Automatic Switchover Processing to Improve Compatibility and Connectivity (6578)
Upd: (Access) If the operating system itself has Access installed, it will be used instead of builtin to solve the problem that Japanese can not search normally (6578)
Fix: (Firebird) Bug Fix message still appears when the machine is not installed with FB (6578)
Fix: Fixed [Path] Abnormal display may exist if not present (6578)
Upd: Optimize WinXP Interface Display Problems (6578)
Upd: Firebird Symbol Version Updated to FirebirdSql.Data.FirebirdClient.dll 5.12.1.0 (2017/12/22) (6578)
Upd: IBM DB2 / Informix Element Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.2022) (2017/12/07) (6578)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 11.1 Fix Pack 2b (2017/12/07)
Upd: Other Inclusions Cumulative Minor Update, Correction and Optimization (6578)
Misc: Compatible with HP Vertica v9

Table Designer:

Upd: Temporary Saving of Data When Reconstructing a Name with a Unique Naming Method to Avoid Duplication and Failure to Handle Correctly (6578)

Database Migration (Pro):

Upd: All Updates Same as dbMigration .NET Software (6578)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

UI language selector was added in preferences
Active schema selector UI was enhanced (filter)
Foreign/ref key navigation icon render was fixed
String cell value can be opened in a separate text editor
Plaintext rendering was enhanced (NULL values, delimiters)
Data export: export of selected columns/rows is now supported
SQL editor: support backslash escape in SQL strings/quoted identifiers
DB2: connection properties dialog was fixed (settings load)
SQL Server: Windows authentication option was added
Sybase/SQL Server: schema list read/filter was fixed
Sybase/SAP ASE: native jConnect driver configuration was added
MySQL/MariaDB: big query results fetching was fixed (for complex custom SQL)
PostgreSQL: procedure creation was fixed
PostgreSQL: role create/drop actions
PostgreSQL: permission management UI was added
PostgreSQL: table DDL generation was fixed (column comments)
Redis: connection properties dialog was fixed (settings load)
Extra CLI options for MySQL/PostgreSQL native export/import wizards
French localization was added (thanks to madcollector)
Chinese localization was updated
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Connection List :
Add: Add Description for connections for database connections, files and group folders ... (6585)
Upd: Interrupt the connection will be back to the connection list The original location (6585)
Upd: Add a new portable database If the existing settings, will clear the original settings and records (6585)
Transaction Mode Processing ( Transaction Mode ):
Add: (SQLite) Support AES256 Cryptographic Database Transaction Mode Processing (6585)
Fix: (SQLite) Fixed a problem with trading patterns that could not be handled properly after database password change (6585)
Upd: Trading mode will be canceled to prevent it from processing normally when database password protection or database compression is performed (6585)
Main program update ( Main ):
Add: (SQLite) Supports AES256 Post-Encryption and Decryption Processing (6585)
Add: (SQLite) Memory Library Support [Restore] AES256 Library Processing (6585)
Upd: (SQLite) Improving the AES256 Encryption Database [New] Handling (6585)
Fix: (Access 32bit) Fixed (6578) Can not Perform Encryption When Switching Office Access (6585)
Add: Add [Non .Net Built-in] Document Type Information Browse Show (6585)
Upd: All password input and settings, support for [front / back] processing with blank characters (6585)
Upd: Improved wait window manual close processing: Change to first interrupt processing and then close the window (6585)
Fix: Browse all [ Browsing all databases ]: Correct [Cross] database [Click to expand] Database Items (6585)
Upd: Others Including Cumulative Minor Update, Correction and Optimization (6585)

[close]

http://fishcodelib.com/Database.htm