Softpedia >Windows >Internet >Servers >Database Utils >Database .NET Professional >  Changelog

Database .NET Professional Changelog

What's new in Database .NET Professional 35.9.8816.1

Feb 20, 2024
  • Data Import:
  • Add: Allow BLOB data type import processing
  • Fix: Fix the problem of Keep Identity losing its function (SQL Server/SQL Azure/SQLCe/Sybase ASE/VistaDB)
  • Connection Manager:
  • Fix: Fixed the problem that the related functions of the right-click menu of the project after copying the connection are not updated simultaneously
  • Update: Improved object deletion and removal enabled status processing (including online browsing)
  • Object Explorer:
  • Fix: (Firebird) Remove generated() null characters when executing stored procedures without parameters
  • Index Designer:
  • Fix: (PostgreSQL) Fixed multi-field check display problem
  • SQL Editor:
  • Update: Single-line batch SQL statement processing adds EXECUTE syntax parsing
  • Update: Improve batch SQL statement custom delimiter (DELIMITER, SET TERM) parsing capabilities
  • Main program update (Main):
  • Add: Support Firebird 5 database system
  • Contains support for partial indices, reserved words...etc.
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.5 (2024/01/27)()
  • Update: Others include cumulative minor updates, corrections and optimizations
  • Database Migration (Pro):
  • Update: All updates are the same as dbMigration .NET software

New in Database .NET Professional 35.8.8767.1 (Jan 2, 2024)

  • Data Import:
  • Add: Support UDDT custom type field import processing
  • Add: Add functions such as selecting all fields, deselecting all, and clicking continuously...
  • Data Editor:
  • Fix: Fixed the problem that the edit field data type cannot be updated when it is a Boolean value and NULL
  • Fix: Fixed the problem of displaying the default content of the newly added column
  • Upd: Improve [Add Column] processing: enter the editing process after completing the addition (including repeating this column/form editor/date picker/GUID generator) (8767)
  • Data Browser and Editor:
  • Update: Optimize and correct multiple display issues
  • Form Editor:
  • Add: Add right-click menu function (Cut/Copy/Paste/Set As NULL/Set As Empty)
  • Form Viewer/Form Editor:
  • Upd: The background color of the field value is displayed consistent with the DataGridView
  • Main program update (Main):
  • Upd: Multiple optimization interfaces and HiDPI high scaling display issues
  • Upd: Quickly Filtering Objects: Improve schema.object object type search character prompt display
  • Upd: Secure Shell (SSH: Secure Shell) component updated to Renci.SshNet.dll 2023.0.1 (2023/12/29)
  • Upd: Support and solve more encryption problems()
  • Update: Others include cumulative minor updates, corrections and optimizations
  • Database Migration (Pro):
  • Update: All updates are the same as dbMigration .NET software

New in Database .NET Professional 35.7.8735.1 (Dec 1, 2023)

  • Updatable query results:
  • Upd: Add Oracle/SybaseASE/SQLCe/FoxPro database, etc., support for non-AutoInc primary keys (8735)
  • Upd: Support update processing when field name is different from actual field name (8735)
  • Update: Support multi-result tab editing processing executed with GO (8735)
  • Fix: Row Headers shortcut key: Solve the problem that the current data row needs to be selected before editing (8735)
  • Fix: Exclude duplicate fields and virtual fields (8735)
  • Fix: Fixed issues related to sharing processing with Data Editor (8735)
  • Data Import:
  • Upd: No need to click to refresh when switching between hiding and displaying data table fields (8735)
  • Upd: When the imported data does not contain fields, a prompt message will be displayed if it is inconsistent with the number of fields in the data table (8735)
  • And Data Browser: Editor:
  • Fix: Filtering and Sorting Columns : Fixed the problem that duplicate fields cannot be switched to show/hide (8735)
  • Update: Improve the processing of related functions under the multi-results page (8735)
  • Code Snippets:
  • Fix: Fixed the problem of code snippet management: deletion after adding but not saving before causing exception (8735)
  • Main program update ( Main ):
  • Fix: (SQLite) The PK cannot be obtained when the field data type is NON-INTEGER and WITHOUT ROWID (8735)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 10.0.0.0 (2023/11/13)( )(8735)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.9000.4) (2023/11/15)(8735)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.9 FP0 (2023/11/15)
  • Update: Others include cumulative minor updates, corrections and optimizations (8735)

New in Database .NET Professional 35.6.8703.2 (Oct 30, 2023)

  • Fix: Fix (8701) the problem of missing dependent version numbers and not updating (8703)

New in Database .NET Professional 35.6.8701.1 (Oct 29, 2023)

  • Updatable query results :
  • Fix: Fixed the problem of losing effect due to reflashing or re-executing (8701)
  • Object Explorer :
  • Add: Advanced browsing (Open->[ADV]) and advanced editing (Edit->[ADV]) of data tables: Support canceling DESC field sorting (8701)
  • Search Table Data :
  • Fix: Fixed (8656) a problem that caused advanced search exceptions (8701)
  • Timer for Automatic Execution :
  • Upd: Keep original search keyword highlighting when reloading (8701)
  • Data Export :
  • Upd: The exported field name will replace the actual field name BaseColumnName with the displayed field name ColumnName (8689)
  • Connection Profile :
  • Fix: (Firebird) Fixed the problem that the No Triggers setting has no effect (8689)
  • Main program update ( Main ):
  • Upd: Improve the control item display problem in Windows 7 operating environment (8701)
  • Upd: Improve COMPUTED COLUMN syntax parsing capabilities (8689)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.2 (2023/10/27)( )(8701)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.12.0 (2023/10/10)( )(8689)
  • Update: PostgreSQL component version updated to Npgsql 7.0.6 (2023/09/15)( )(8701)
  • Update: Others include cumulative minor updates, corrections and optimizations (8701)
  • Database Migration ( Pro):
  • Upd: All updates are the same as dbMigration .NET Software(8701)

New in Database .NET Professional 35.5.8689.2 (Oct 16, 2023)

  • Data Export:
  • Upd: The exported field name will replace the actual field name BaseColumnName with the displayed field name ColumnName (8689)
  • Connection Profile:
  • Fix: (Firebird) Fixed the problem that the No Triggers setting has no effect (8689)
  • Main program update (Main):
  • Upd: Improve COMPUTED COLUMN syntax parsing capabilities (8689)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.12.0 (2023/10/10)( )(8689)
  • Update: PostgreSQL component version updated to Npgsql 7.0.5 (2023/09/15)( )(8689)
  • Update: Others include cumulative minor updates, corrections and optimizations (8689)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software(8689)

New in Database .NET Professional 35.5.8662.2 (Sep 19, 2023)

  • Update: Others include cumulative minor updates, corrections and optimizations (8662)
  • Update: All updates are the same as dbMigration .NET software (8662)

New in Database .NET Professional 35.5.8656.1 (Sep 13, 2023)

  • Updatable query results:
  • Add: Support PrimaryKey Selector processing (8656)
  • Fix: Fixed the problem that the sub-option [E] of Edit this table (Edit this table) cannot obtain node information (8656)
  • Object Explorer:
  • Add: Advanced browsing (Open->[ADV]) and advanced editing (Edit->[ADV]) of data tables: Support SQL statement preview display (8656)
  • Add: Advanced browsing (Open->[ADV]) and advanced editing (Edit->[ADV]) of data tables: Support primary key descending sort (ORDER BY PKs DESC) (8656)
  • Database Diagram:
  • Upd: Support cross-schema data table processing and improve processing speed (8656)
  • Update: Object name adds structure description name display (Schema Name) (8656)
  • Security Manager:
  • Upd: (SQL Server) Add support for legacy databases (<10) Server Roles (8656)
  • Generating Scripts:
  • Upd: Foreign Keys support cross-schema definition (8656)
  • Connection Profile:
  • Fix: Fixed drop-down browsing SCHEMAS/DATABASES control item not supporting SSH enable processing (8656)
  • Main program update (Main):
  • Upd: Others include cumulative minor updates, corrections and optimizations (8656)
  • Database Migration (Pro):
  • Update: All updates are the same as dbMigration .NET software (8656)

New in Database .NET Professional 35.4.8613.3 (Aug 1, 2023)

  • Data Editor (Data Editor ):
  • Fix: Fixed (8609) update causing some functions to lose their function (8613)
  • Add: (Firebird) support uuid and CHAR(16) CHARACTER SET OCTETS field data type editing and updating processing (8609)
  • Add: Editor Form : Support primary key selector ( PrimaryKey Selector ) processing (8609)
  • Main program update ( Main ):
  • Upd: Automatically obtain ROWS COUNT and manually click {*} to improve the processing efficiency of the overall and related functions (8609)
  • Fix: (Pro 64bit) Fixed the issue of related shared variables when used together with the database migration tool (8609)
  • Fix: (PostgreSQL) Fixed the problem that the associated field of GetForeignKeys cannot be displayed when it is unique (8609)
  • Fix: (PostgreSQL) Correct the related issue that GetForeignKeys affects when different Schema names have the same Table name (8609)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.11.0 (2023/07/26)( )(8609)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.118.0 (3.42.0) (2023/06/10)(8609)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8613)
  • Object filtering ( Filtering Objects ):
  • Add: Added option to skip loading all objects (Skip loading all objects): Do not load any related objects after database connection (8609)
  • Upd: Object filtering added to the Database Tools menu (Database Tools) (8609)
  • Updatable query results ( Updatable query results ):
  • Add: Add Edit this table sub-option [E] (8609)
  • Add: Add shortcut keys to Row Headers (8609)
  • Upd: Update the status of the menu function in database only mode (8609)
  • Data Export ( Data Export ):
  • Add: (Firebird) Support uuid and CHAR(16) CHARACTER SET OCTETS field data type SQL format export processing (8609)
  • Filtering and Sorting columns name ( Filtering and Sorting columns ):
  • Upd: Add pk/not null and other information to field attributes (8609)
  • Upd: The not null field can also be hidden in edit mode (8609)
  • Viewer - Form /Form Editor :
  • Fix: If the first field is an invisible field, the exception that causes no response when clicking (8609)
  • Conditional constraint design ( Constraint Designer ):
  • Fix: When the object name is lowercase, the automatic naming has no effect (8609)
  • Database Migration ( Pro):
  • Upd: All updates same as dbMigration .NET Software(8610)

New in Database .NET Professional 35.4.8609.1 (Jul 28, 2023)

  • Main Program Update ( Main ):
  • Upd: ROWS COUNT Manually click {*} instead of automatic acquisition to improve the processing efficiency of the overall and related functions (8609)
  • Fix: (Pro 64bit) Correct the problem of related shared variables when used with the database migration tool at the same time (8609)
  • Fix: (PostgreSQL) Fixed the problem that GetForeignKeys cannot be displayed when the related field is unique (8609)
  • Fix: (PostgreSQL) Fixed the related problem that GetForeignKeys affects when different Schema names have the same Table name (8609)
  • Upd: The Oracle component version is updated to Oracle.ManagedDataAccess.dll 21.11. 0(2023/07/26)( )(8609)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.118.0 (3.42.0) (2023/06/10)(8609)
  • Upd: Others include cumulative small Updates, fixes and optimizations (8609)
  • Filtering Objects :
  • Add: Added option to skip loading all objects (Skip loading all objects): Do not load any related objects after database connection (8609)
  • Upd : Object filtering added to the database tool menu (Database Tools) (8609)
  • Updatable query results ( Updatable query results ):
  • Add: Add Edit this table sub-option [E] (8609)
  • Add: Data Added shortcut keys for Row Headers (8609)
  • Upd: Updated menu function status in database only mode (8609)
  • Data Editor):
  • Add: (Firebird) support uuid and CHAR(16) CHARACTER SET OCTETS field data type editing and update processing (8609) Add
  • Form Editor ( Form Editor ): support primary key selector ( PrimaryKey Selector ) processing (8609 )
  • Data Export ( Data Export ):
  • Add: (Firebird) Support uuid and CHAR(16) CHARACTER SET OCTETS column data type SQL format export processing (8609)
  • Filtering and Sorting column names ( Filtering and Sorting columns ):
  • Upd: Add pk/not null and other information to the field attribute (8609)
  • Upd: The not null field can also be hidden in edit mode (8609)
  • Form Viewer ( Form Viewer ) / Form Editor ( Form Editor ):
  • Fix:Correct the exception that the click does not respond when the first field is an invisible field (8609)
  • Constraint Designer : Fix
  • Fix the problem that the automatic naming has no effect when the object name is lowercase (8609)
  • Database Migration ( Pro):
  • Upd: All updates are the same as dbMigration .NET software (8609)

New in Database .NET Professional 35.3.8558.1 (Jun 7, 2023)

  • Data Browser (Data Browser ):
  • Add: Add updatable query results ( Updatable query results ): You can directly edit and update the content of SQL query results (8558)
  • Add: Support shortcut key settings ( Shortcut Keys ): Edit the current row: Alt + E (8558)
  • Data Editor (Data Editor ):
  • Upd: (Firebird) Allow blob sub_type 1 data type content to be edited directly (8558)
  • Main program update ( Main ):
  • Add: Support the latest version of Oracle 23c database system (8558)
  • Add: Support the latest version of Teradata 17 database system (8558)
  • Add: Support PostgreSQL 16 beta 1 latest database system (8558)
  • Add: (Oracle 21c/23c) support new data types such as JSON/BOOLEAN (8558)
  • Add: (Oracle 23c) Support DOMAIN object related processing (8558)
  • Add: (PostgreSQL 16) Support database backup and restore processing: Update Database .NET Additional Files ( 64bit ) (2023/05/28)(8558)
  • Upd: (PostgreSQL) Solve the problem that the driver default does not support the interval data type with year and month (8558)
  • Upd: (PostgreSQL/MySQL) Improve backup and restore message output processing (8558)
  • Upd: PostgreSQL component version updated to Npgsql 7.0.4 (2023/04/24)( )(8558)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.10.0 (2023/03/30)( )(8558)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.6.0 (2023/03/21)( )(8558)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8558)
  • AutoComplete and IntelliSense ( AutoComplete and IntelliSense ):
  • Add: Add auto-complete window delay display settings (Options->Autocomplete delay (100~1000ms))(8558)
  • Query Design Tool ( Query Builder )
  • Upd: When creating a new query, it will be processed as a new tab page (8558)
  • Generating Scripts :
  • Fix: Correct the abnormal name generated by TYPE objects (8558)
  • Database Migration ( Pro):
  • Upd: All updates same as dbMigration .NET Software(8558)

New in Database .NET Professional 35.2.8495.1 (Apr 6, 2023)

  • main program update ( Main ):
  • Add: (VistaDB ) Supports AES256 encrypted database processing (8495)
  • Fix: Fixed (8447) related functions restarted after executing the database shutdown, resulting in the problem that the connection status is still closed (8495) Upd
  • : (Excel/Text) Solve the problem of large data tables Obtaining ROWS COUNT when content is too slow (8495)
  • Upd: (Text) Add a prompt message if the file length exceeds 64 characters, so it cannot be processed normally (8495)
  • Upd: (Text) Exclude obtaining ROWS COUNT when loading objects ( 8495)
  • Upd: SQL Server/SQL Azure component version updated toMicrosoft.Data.SqlClient 5.1.0 (2023/03/28)( )(8495)
  • Upd: PostgreSQL component version updated to Npgsql 7.0.2 (2023/02/15)( )(8495)
  • Upd: VistaDB component version updated to VistaDB.6.dll 6.4.2 (2022/06/08)(8495)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8495) - Database Migration
  • ( Pro): Upd: All updates same dbMigration .NET software (8495) Ver 35.1 (2023/02/16) stable version - main program update ( Main ): Upd: support MariaDB 10.10+ latest version database: solve compatibility problems caused by new codes (8447) Upd :

New in Database .NET Professional 35.1.8447.1 (Feb 16, 2023)

  • Main program update (Main):
  • Upd: Support the latest version of MariaDB 10.10+ Database: Solve the compatibility problem caused by the new code (8447)
  • Upd: If the Server Compatibility Mode=Redshift attribute is not specified when connecting to Redshift, it will automatically add processing (8447)
  • Fix: Fix the problem that if the loading of objects fails after the connection is successful, the processing cannot continue (8447)
  • Upd: Improve database message content display (8447)
  • Upd: Improve error message content display (8447)
  • Upd: SSH: Secure Shell component updated to Renci.SshNet.dll 2020.0.2 (2022/05/29)(8447)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.0 (2023/01/20)()(8447)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.1.1.0 (2023/01/17)()(8447)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.9.0 (2023/01/11)()(8447)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8447)
  • - Data Editor:
  • Fix: After manually clearing the content of the data grid, the error that the display is still NULL (8447)
  • Fix: Solve the problem that the content of ENUM data type may not be updated (8447)
  • - Database Migration (Pro):
  • Upd: All updates same as dbMigration .NET software (8447)

New in Database .NET Professional 35.0.8401.1 (Jan 1, 2023)

  • Data Browser and Editor:
  • Add: Highlighting Groups of Cells: Support color customization (User Interface->Results Tab->Group Color)(8401)
  • Object Explorer:
  • Upd: (PostgreSQL) Add public global custom data type (UDDT) to all Schemas (affects multiple places)(8401)
  • Upd: (PostgreSQL) Improve when the user does not have permission to access information_schema and change to alternative processing (8401)
  • Upd: Improve the processing ability to get the field data type (DataTypeName) (8401)
  • Data Import:
  • Upd: Display interface optimization and improvement (8401)
  • SQL Editor:
  • Upd: Automatically jump to the wrong column (or position): Add support for SQLite (8401)
  • Main program update (Main):
  • Fix: (PostgreSQL) Solve the problem that if Generated Columns contains data type definition, PG itself misses () when returning (8401)
  • Fix: (PostgreSQL/MySQL) Correct the related issue that GetForeignKeys affects when different Schema names have the same Table name (8401)
  • Upd: PostgreSQL component version updated to Npgsql 7.0.1 (2022/12/17)()(8401)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.117.0 (3.40.0) (2022/11/27)(8401)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.5.0 (2022/11/23)()(8401)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8401)
  • Database Migration (Pro):

New in Database .NET Professional 34.9.8360.1 (Nov 21, 2022)

  • Data Browser and Editor:
  • Fix: (MySQL) Fix (8166) the problem that the Decimal data type cannot be handled normally (8360)
  • Upd: (SQLite) When the field has no data type, the output is processed as blob type (8360)
  • SQL Editor:
  • Upd: Added shortcut key setting (Shortcut Keys): Save As: Ctrl+Shift+S(8360)
  • Main program update (Main):
  • Add: Support PostgreSQL 15.1 latest database system (8360)
  • Upd: Update Database .NET Additional Files (64bit) (2022/11/10)(8360)
  • Upd: PostgreSQL component version updated to Npgsql 7.0.0 (2022/11/10)()(8360)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.1.0.0 (2022/11/08)()(8360)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.0.1 (2022/10/07)()(8360)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.8000.4) (2022/10/20)(8360)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.8 FP0 (2022/10/20)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.8.0 (2022/10/11)()(8360)
  • Upd: MySQL component version updated to MySql.Data.dll 8.0.31 (2022/10/11)()(8360)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.3.0 (2022/08/19)()(8360)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8360)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (8360)

New in Database .NET Professional 34.8.8318.1 (Oct 10, 2022)

  • Main program update (Main):
  • Add: (SQLite) Support SQLCipher v4 encryption database processing, currently supports encryption processing including (RC4/AES256 v3/v4) (8318)
  • Upd: (SQLite) Solve the problem that when the data table exceeds one million transactions, obtaining ROWS COUNT may lead to insufficient memory (8318)
  • Fix: (SQLite) Fixed memory database (Memory Database) restore from AES256 encrypted database processing (8318)
  • Upd: Prevent related function windows from exceeding the display range in full screen (8318)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8318)
  • SQL Editor:
  • Add: Additional Commands: Support custom result tab name :tab 'results tab name'(8318)
  • Connection Explorer:
  • Add: Support to modify user and password in ODBC Connection Profile (8318)
  • Data Editor (Data Editor):
  • Upd: Update the length judgment of processing Text to Blob to solve possible exceptions (8318)
  • Upd: When performing related editing processing, avoid the problem of the position of the horizontal column changing (8318)
  • Data Import:
  • Fix: Fix the related processing including whether the auto-increment field is hidden or not (8318)
  • Fix: Fixed the problem that the display is repeatedly refreshed when importing the specified field (8318)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET software (8318)

New in Database .NET Professional 34.7.8300.1 (Sep 22, 2022)

  • Connection Profile:
  • Upd: (SQL Server/SQL Azure) Added Encryption connection encryption option (Optional/Mandatory/Strict)
  • SQL Editor:
  • Upd: Move line up/down: Alt + Up/Down: Support multi-selection move processing
  • AutoComplete and IntelliSense:
  • Upd: Optimize and improve the table hint parsing ability
  • Upd: Optimization improvements, eliminate unnecessary perceptual processing
  • SQL Profiler:
  • Fix: Fixed the event setting window, in some states, when double-clicking to expand or add, it may cause blank or exceptions
  • Object Explorer:
  • Fix: (Firebird) Fixed and improved Reversed Words display and syntax highlighting
  • Main program update (Main):
  • Upd: Improve the processing speed of GetForeignKeys, affecting multiple functions
  • Upd: (PostgreSQL) Inherit from the initial value of search_path in database (or connection) settings
  • Upd: PostgreSQL component version updated to Npgsql 6.0.7
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.0.0
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.7.0
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in Database .NET Professional 34.6.8249.1 (Aug 2, 2022)

  • Main Program Update ( Main ):
  • Upd: Update Office Access compatibility detection, support ClickToRun Installation version:
  • Affects include: (Access) text execution plan, (Text) delimited text file custom extension file name...etc.
  • Upd: (MySQL) SSL Mode added to VerifyCA/VerifyFull Support (8249)
  • Upd: (MySQL) Automatically configure max_allowed_packet with a minimum size of 16M (8249)
  • Upd: (MySQL) Backup and restore default default-character-set taken from the server side utf8 (mb3/mb4) encoding (8249)
  • Upd: Update MySQL component version to MySql.Data.dll 8.0.30 (2022/07/26)( )(8249)
  • Upd: Update Firebird component version to FirebirdSql.Data.FirebirdClient 9.0.2.0 (2022/07/12)( )(8249)
  • Upd: Update the PostgreSQL component version to Npgsql.dll 6.0.5 (2022/06/19)( )(8249)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8249)
  • Query Design Tool ( Query Builder )
  • Fix: Fixed and improved Query Reverse Engineering (8249)
  • Plain Execution Plan :
  • Fix:(Access) Fixed the initial problem that the ACE/OLEDB Provider could not be executed normally (8249)
  • Visual Execution Plan :
  • Fix: Fixed the syntax highlighting problem of Plain Execution Plan in Professional Edition (8249)
  • Generated Generating Scripts :
  • Fix: (MySQL 8/MariaDB) Generate CHECK CONSTRAINTS object syntax definition separately, remove exception characters (8249) -
  • Connection Profile :
  • Upd: Clear dozens of multiple databases Useless connection properties to simplify setup (8249)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (8249)

New in Database .NET Professional 34.4.8227.1 (Jul 11, 2022)

  • Main program update (Main):
  • Upd: Support more complete file encoding detection processing (UTF(8/16/32)/BigEndianUTF(16/32)/ANSI) (including BOM/NOBOM)
  • Including: Data Import, Cell Editor, Code Manager... and other related functions
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.6.1 (2022/04/16)
  • Upd: Others include cumulative minor updates, corrections and optimizations
  • Object Explorer:
  • Upd: (Oracle/IBM DB2) Added the display of index objects automatically generated by the system, which is consistent with the display method of other databases
  • Upd: (Text) xSV delimited archive file browsing supports more encoding processing (including BOM/NOBOM)
  • Upd: (PostgreSQL/MySQL/SQLite) Support associated data table clearing
  • Upd: (Firebird) SQL References adds more complete function display and syntax highlighting
  • Data Import:
  • Upd: Clipboard source content changed to support Unicode instead of ANSI encoding
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET software

New in Database .NET Professional 34.4.8220.1 (Jul 4, 2022)

  • Query Builder:
  • Upd: Allow selection Query Syntax [Validation and Execution](8220)
  • Upd: Rewrite the query syntax validation function to make it more intuitive and faster to use (8220)
  • Upd: Added TABLE/VIEW object to support multi-selection processing, while improving the speed of secondary opening (8220)
  • Fix: Query Reverse Engineering : Multiple fixes and improvements (8220)
  • Object Explorer :
  • Upd:The data table KEYS object is added to the cache to improve the processing efficiency of related functions (8220)
  • Add: increase the display of the Collations object (SQL Tab->Collations) (8220)
  • Upd: improve the status synchronization update processing after the data table object is deleted (8220 ) )
  • Main program update ( Main ):
  • Upd: Improve the processing efficiency of obtaining ROWS COUNT and display the problem when clicking/expanding the title (8220)
  • Fix: Fixed the problem of automatically adding a query tab when the query tab does not exist (8220)
  • Fix: Fixed the problem that ROWS COUNT was incorrectly obtained when preloading non-current data tables (8220)
  • Upd: Updated Czech language interface language (Updated by Ladislav Karda) (8220)
  • Upd: PostgreSQL component version updated to Npgsql.dll 5.0 .14 ​​(2022/06/19)( )(8220)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.2.0 (2022/05/23)( )(8220)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8220)

New in Database .NET Professional 34.3.8202 (Jun 16, 2022)

  • Main Program Update ( Main ):
  • Fix: Fix Windows 11 Build 25136+ latest version compatibility issue (8202)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.116.0 (3.38.5) (2022/06/01)(8202)
  • Upd: Others include cumulative Minor updates, fixes and optimizations (8202)
  • Query Builder ( Query Builder )
  • Add: add SQL Formatting formatting options (8202)
  • Upd: Support Sort Type/Sort Order/Group By clear setting processing (8202)
  • Upd: Improve the problem of displaying multiple links in the right-click menu of the data table at the same time (8202)
  • Fix: Fix and improve the ability of Query Reverse Engineering : None OUTER keyword processing (8202)
  • Code Manager :
  • Upd: Automatically preserve the original file encoding format (UTF8 with BOM/UTF8 without BOM/Unicode) (8202)
  • SQL Editor ( SQL Editor ):
  • Add: File Add UTF8 with BOM/UTF8 without BOM option (Save As...) (8202)
  • IntelliSense Parameter Info :
  • Fix: (64bit) Fix and improve the perception ability with structure description name (8202) )
  • autocomplete and sense ( AutoComplete and IntelliSense ):
  • Fix: Fix and improve the perception ability with structure description names (8202)
  • Grant Manager :
  • Add: (SQL Server/SQL Azure) Support SYNONYMS object grant processing (8202)
  • Documentation Table Designer :
  • Upd: (Firebird) Excludes database versions that do not support COLLATE (8202)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (8202)

New in Database .NET Professional 34.2.8186.2 (Jun 1, 2022)

  • Main program update (Main):
  • Fix: (IBM DB2/Informix) Fixed (8166) the problem that the quoted identifiers could not be obtained (8186)
  • Add: Support PostgreSQL 15 latest database system(8186)
  • Upd: Update Database .NET Additional Files (64bit) (2022/05/30)(8186)
  • Upd: Optimization and improvement of database access speed in related functions (8184)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8186)
  • Generating Scripts:
  • Add: (PostgreSQL 15+) support Script AS MERGE to generate content (8186)
  • Transaction Mode:
  • Fix: (IBM DB2/Oracle) Fixed the problem that DBMS_OUTPUT output display is not supported in transaction mode (8186)
  • Data Browser:
  • Upd: Optimize field data access processing, take up less resources and process faster (8184)
  • Object Explorer:
  • Fix: (SybaseASE) Fixed the problem of resetting the auto-increment column value when clearing the data table (8184)
  • Add: (ODBC-Informix) Added support for SYNONYMS object display (8184)
  • Upd: (ODBC/OleDB) Structure description name of PROCEDURES/FUNCTIONS added recognition of PROCEDURE_OWNER (8184)
  • Fix: (ODBC/OleDB) Fixed the problem that the FUNCTIONS object click to reshape has no effect (8184)
  • Fix: Fix the database object display support and database migration (Database Migration) division, to avoid being affected (8184)
  • Filtering Objects:
  • Fix: Fixed an issue that may cause exceptions to occur when clicking the shift key while typing (8184)
  • Data Import:
  • Add: (SQL Server/SQL Azure/Sybase ASE/VistaDB/SQLCe) Support Preserve identity values ??option (8184)
  • Upd: (SQL Server/SQL Azure/PostgreSQL/MySQL/SQLite) Import process unconstrained processing (8184)
  • Data Export:
  • Fix: Fix related processing when Preserve identity values ??is enabled (8184)
  • SQL Profiler:
  • Upd: Change to Asynchronous Processing (8184)
  • Upd: Automatically exclude content with no return value SQL Text (8184)
  • Query Builder
  • Fix: Fixed and improved Query Reverse Engineering capability (8184)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET software (8186)

New in Database .NET Professional 34.2.8184.1 (May 29, 2022)

  • Data Browser :
  • Upd: Optimized Field data access processing, taking up less resources and faster processing (8184)
  • Object Explorer :
  • Fix: (SybaseASE) Fix the problem that the data table clearing process resets the auto-increment field value (8184)
  • Add: ( ODBC-Informix) Added support for SYNONYMS object display (8184)
  • Upd: (ODBC/OleDB) Structure description name of PROCEDURES/FUNCTIONS added recognition of PROCEDURE_OWNER (8184)
  • Fix:(ODBC/OleDB) Fix the problem that the FUNCTIONS object click to reorganize has no effect (8184)
  • Fix: Fix the database object display support and database migration ( Database Migration ) division, to avoid the impact (8184)
  • Object Filtering ( Filtering Objects ) ):
  • Fix: Fixed a problem that may cause exceptions to occur when clicking the shift key during input (8184)
  • Data Import :
  • Add: (SQL Server/SQL Azure/Sybase ASE/VistaDB/SQLCe) Support to keep the increment field Preserve identity values ??option (8184)
  • Upd: (SQL Server/SQL Azure/PostgreSQL/MySQL/SQLite) import process is not restricted (8184)
  • Data Export ( Data Export ):
  • Fix: Fix enable preserve increment Related processing when Preserve identity values ??(8184)
  • SQL Profiler :
  • Upd: Change to Asynchronous Processing (8184)
  • Upd: Automatically exclude the content of SQL Text with no return value (8184) -
  • Query Builder
  • Fix: Fix And improved Query Reverse Engineering (8184)
  • Main program update ( Main ):
  • Upd: Optimization and improvement of database access speed in related functions (8184)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (8184)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (8184)

New in Database .NET Professional 34.1.8166.1 (May 11, 2022)

  • Main program update (Main):
  • Fix: (ODBC/OleDB) Allow database drivers to handle Quoted identifiers without quotes
  • Fix: Connection provider (Provider) version detection, add password discrimination processing
  • Fix: (MySQL) Fixed the problem that when the ROWS COUNT timed out, it could not continue processing
  • Upd: (MySQL) Improve password expiration handling to simplify processing
  • Upd: Execute an SQL script file: Added batch execution of Single INSERTs
  • Upd: MySQL component version updated to MySql.Data.dll 8.0.29 (2022/04)()
  • Upd: PostgreSQL component version updated to Npgsql.dll 5.0.13 (2022/04/27)()
  • Upd: Others include cumulative minor updates, corrections and optimizations
  • Object Explorer:
  • Add: (PostgreSQL 14+) Support PROCRDURES 14 object parameter OUT related processing
  • Upd: (PostgreSQL) Improve PROCRDURES/FUNCTIONS object parameters including IN/OUT/INOUT display
  • Generating Scripts:
  • Fix: (PostgreSQL) Fixed Script AS EXECUTE generated content
  • SQL Profiler:
  • Add: Session Mode adds support for MySQL 5.0 database
  • Grant Manager and Security Manager:
  • Add: (PostgreSQL 11+) support PROCRDURES object authorization processing
  • Security Manager:
  • Upd: (MySQL 5.7+) Improve user-defined syntax generation content
  • SQL Editor:
  • Add: Added shortcut keys to move line up/down (Move line up/down): Alt + Up/Down
  • Command-line processing:
  • Add: Support only connection parameters (Read-Only Mode: [-readonly])
  • Filtering data of a column:
  • Upd: resolve exception handling when field (or alias) does not exist
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET software

New in Database .NET Professional 34.0.8148.1 (Apr 25, 2022)

  • Main program update (Main):
  • Add: Support Firebird Read-Only Mode
  • Upd: Improve object parsing when quote identifiers contain . exception characters
  • Upd: If the position of the window exceeds the current screen after startup, it will be automatically corrected to avoid the same setting in different display environments.
  • Upd: Transaction Mode: Fixed and improved initial command handling
  • Upd: Others include cumulative minor updates, corrections and optimizations
  • SQL Editor:
  • Upd: (SQL Server/SQL Azure) Automatically jump to wrong column (or position): Added Microsoft.Data.SqlClient support
  • Form Editor:
  • Upd: Added column comment display
  • Table Designer:
  • Add: DragDrop Support
  • Fix: Fixed the problem that the cache is not updated synchronously after the field is changed (including the object browsing delete and renaming fields)
  • Index Designer:
  • Add: DragDrop Support
  • Upd: Added processing default index name will automatically include the selected field name
  • Object Explorer:
  • Upd: (ODBC/OleDB) Object names are displayed and sorted according to SCHEMA.OBJECT
  • Filtering Objects:
  • Upd: (ODBC/OleDB) Object filter will include structure description name (SCHEMA.OBJECT)
  • Database Tools:
  • Upd: (Firebird) Update backup and restore processing, and support interrupt processing
  • Upd: (Firebird 3+) Rewrite database compression processing, support remote database, support interruption and improve processing speed
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET software

New in Database .NET Professional 33.9.8121.1 (Mar 27, 2022)

  • SQL Editor ( SQL Editor ):
  • Fix: Excluded Single quote '' content batch command GO and / parsing processing, to avoid causing exceptions (8121)
  • Query Builder ( Query Builder )
  • Add: Support to select multiple check boxes using shortcut keys Shift or Ctrl + Click (8121)
  • Add: Right-click menu items support Select All and Invert selection (8121)
  • Database Chart ( Database Diagram ):
  • Upd: Complete display of reference/referenced/self-reference icons (8121)
  • Fix: Fix connection/syntax/deletion issues when the data table is associated more than once (8121)
  • Query Tabs ):
  • Fix: Avoid the abnormal problem caused by continuously clicking the middle mouse button to close the query tab (8121)
  • Fix: Fix the abnormal display of the control part when dragging and zooming the horizontal/vertical [multi] tabs (8121)
  • Script generation Generator ( Script Generator ):
  • Upd: Automatic processing of data table creation sequence: In addition to processing [referenced], complete processing such as [reference] is added (8121)
  • Filtering Objects :
  • Upd: (SQL Server/ SQLAzure/SybaseASE) object filter will include structure description name (SCHEMA.OBJECT) (8121)
  • Index Designer ( Index Designer ):
  • Upd: Added processing to add default index name (8121)
  • Main program update ( Main ):
  • Fix: (Teradata) Corrected the problem that the password expired [prompt] and [update] functions do not work (8121)
  • Fix: fixed (8075) A low-level error that the data table field cache cannot be retrieved twice (affects multiple places) (8089)
  • Upd: Connection Explorer : When the [Last Access Time] does not exist, it will be automatically created (8089)
  • Upd: (ODBC) Allow update of connection dialog settings after connection failure (8089)
  • Add: Support YugabyteDB database (PostgreSQL compatible) (8121)
  • Upd: Others include cumulative minor updates, fixes and optimizations (8121)

New in Database .NET Professional 33.8.8089.1 (Feb 23, 2022)

  • Fix: low-level error that the data table field cache could not be obtained twice (the effect includes multiple places)
  • Upd: Connection Explorer: Automatically created when [Last Access Time] does not exist
  • Upd: (ODBC) Allow update of connection dialog settings after connection failure
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in Database .NET Professional 33.8.8075.1 (Feb 9, 2022)

  • Data Export :
  • Add: Support Converting SQL INSERTs to different database types (8075)
  • Data Import :
  • Upd: Significantly improve the processing speed of Excel Workbook (*.xlsx) import (8075)
  • Upd: "Whether the first column is a column header" automatic detection process: Exclude virtual column detection (8075)
  • Query tab ( Query Tabs ):
  • Add: Support Tile Horizontally/Vertically (8075)
  • SQL Editor ( SQL Editor ):
  • Upd: Update FUNCTIONS syntax highlighting color display is consistent, while removing presets does not support and Duplicate part (8075)
  • Main program update ( Main ):
  • Upd: The display interface and user experience have been improved in many places (8075)
  • Upd: The speed of obtaining data table fields has been improved to avoid repeated processing (affects include multiple places) (8075)
  • Upd : Improve the memory release processing immediately after the SQL History declarative record, to avoid the problem of accumulating continuous occupancy (8075)
  • Add: (SQLite) Increase the database connection memory release processing to avoid the problem of insufficient resources (influenced in many places) (8075)
  • Add: (Oracle) Support User-defined types custom type data display (including related functions) (8075)
  • Add:(Oracle) Data table objects are added to Object tables display (8075)
  • Upd: (PostgreSQL) Array Types are improved to obtain processing speed (8075)
  • Upd: PostgreSQL component version is updated to Npgsql 5.0.12 (2022/02/01)( )(8075)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 4.1.0 (2022/01/31)( )(8075)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.5.0 (2021/12) /23)(8075)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8075)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NETSoftware (8075)

New in Database .NET Professional 33.7.8038.1 (Jan 3, 2022)

  • Object Explorer:
  • Add: Add to get the [Data table and view table] data row count (Getting table/view rows count: {*}) (8038)
  • Add: Table and View objects list: Add sub-option [GET] to get all objects Rows Count message (8038)
  • Upd: Table and View objects list: Rewrite to greatly improve processing efficiency (8038)
  • Add: Connection Explorer: Added Last Accessed Time display to connection items (8038)
  • Add: Code Manager: Add Last Modified Time display to document items (8038)
  • Upd: RowCount/Comment and other information in the title bar of the table object, support cache processing (8038)
  • Main program update (Main):
  • Add: (SQL Server/SQL Azure) Supports Microsoft.Data.SqlClient/System.Data.SqlClient dual data provider processing at the same time (8038)
  • Fix: (SQL Server/SQL Azure) Fix InfoMessage event removal problem (8038)
  • Upd: Solve the problem that MariaDB 10.6+ default utf8mb3 can not connect normally (8038)
  • Add: Support MariaDB 10.7+ to add UUID data type (8038)
  • Fix: Fix (7943) the problem that caused the original connection [last access time] settings to lose update (8038)
  • Upd: Improve the opening speed between different versions of the file type database (8038)
  • Upd: Improve the processing of the single browse field of the right-click menu, automatically exclude data types that cannot be GROUP BY (8038)
  • Fix: (IBM DB2) Fix the version display problem (8038)
  • Upd: Multiple improvements in the display interface and user experience (8038)
  • Upd: Transaction Mode: Update the initial command processing method (8038)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.7000.4) (2021/12/08)(8038)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.7 FP0 (2021/12/08)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (8038)
  • Query Tabs:
  • Upd: Optimize the processing speed of opening and closing tabs (8038)
  • Fix: Fix the problem of title name change (8038)
  • AutoComplete and IntelliSense:
  • Upd: Optimized completion mode (Completion Mode) processing method (8038)
  • PrimaryKey Selector:
  • Fix: (SQLCe 3.1/OleDB/ODBC) Fix the database type without the top n keyword processing (including related functions) (8038)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (8038)

New in Database .NET Professional 33.6.8007.1 (Dec 3, 2021)

  • AutoComplete and IntelliSense:
  • Add: Add object alias (Alias) to auto-complete item (8007)
  • Upd: Optimized completion mode (Completion Mode) processing method (8007)
  • Upd: Optimize perception processing, when the object contains and does not contain quoted identifiers (Quoted identifiers) (8007)
  • Main program update (Main):
  • Upd: Support exception characters & display and related processing (including files/objects/titles... etc.)(8007)
  • Fix: Solve the problem that Firebird 1.5 loses support (8007)
  • Upd: (SQL Server/SQL Azure) Prevent users from not shutting down normally after executing FMTONLY/NO_BROWSETABLE, resulting in abnormal handling of subsequent programs (8007)
  • Fix: (SQL Server/SQL Azure) Fix (7989) the problem that the DOMAIN object is not displayed (7996)
  • Fix: (SQL Server/SQL Azure) Fix (7989) Rewrite the effect of GetSchemaTable processing (7990)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 4.0.0 (2021/11/19)()(7996)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (8007)
  • Code Manager:
  • Fix: Double-click to open the file in the [Group], fix the label name display problem (8007)
  • SQL Editor:
  • Upd: Update the default display size and font Cascadia Mono (when the system is installed) (7996)
  • Generating Scripts:
  • Upd: (SQL Server/PostgreSQL) Improve VIEW object generation script processing speed (7996)
  • Displaying Data Types on the column header:
  • Upd: Improve ODBC/OleDB data type display (7996)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (8007)

New in Database .NET Professional 33.5.7996.3 (Nov 22, 2021)

  • Main program update:
  • Fix: (SQL Server/SQL Azure) Fix (7989) the problem that the DOMAIN object is not displayed.
  • Fix: (SQL Server/SQL Azure) Fix (7989) Rewrite the impact of GetSchemaTable processing.
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 4.0.0.
  • Upd: Others include cumulative minor updates, corrections and optimization processing.
  • SQL Editor:
  • Upd: Update the default display size and font Cascadia Mono (when the system is installed).
  • Generating Scripts:
  • Upd: (SQL Server/PostgreSQL) Improve VIEW object generation script processing speed.
  • Displaying Data Types on the column header:
  • Upd: Improve ODBC/OleDB data type display
  • Database Migration:
  • Upd: All updates are the same as dbMigration .NET software

New in Database .NET Professional 33.5.7990.2 (Nov 16, 2021)

  • Data Browser and Editor:
  • Upd: Rewrite GetSchemaTable related code to improve overall processing efficiency (7989)
  • Fix: Fix the impact of (7989) changes on SQL Server/SQL Azure processing (7990)
  • Main program update (Main):
  • Upd: Related optimization and update processing under Windows 11 operating environment (7989)
  • Upd: Improve related issues such as command interruption and memory release (7989)
  • Upd: (PostgreSQL) Optimize the processing efficiency of the overall SQL query statement execution (7989)
  • Add: (Firebird) Added support for Srp256 authentication login method (7989)
  • Upd: PostgreSQL component version updated to Npgsql 5.0.11 (2021/11/12)()(7989)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 8.5.4.0 (2021/11/11)()(7989)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.115.5 (3.37.0) (2021/11/02)(7989)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.13.0 (2021/10/03)(7989)
  • Upd: VistaDB component version updated to VistaDB.6.dll 6.2.3 (2021/09/10)(7989)
  • Fix: (PostgreSQL) Solve the problem that npgsql does not automatically update the version number when switching between different database versions on the same source host (7943.2)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7989)
  • Displaying Data Types on the column header:
  • Fix: (Firebird) Fix and update v4 data type display (7989)
  • Fix: (SybaseASE) Fix data type display processing method (7989)
  • Fix: (MySQL/HP Vertica) Solve the problem that the starting value of ColumnOrdinal is non-zero and the related function is abnormal (different from other database bugs?) (7989)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (7989)

New in Database .NET Professional 33.5.7989.1 (Nov 15, 2021)

  • Data Browser and Editor:
  • Upd: Rewrite GetSchemaTable related code to improve overall processing efficiency
  • Main program update (Main):
  • Upd: Related optimization and update processing under Windows 11 operating environment
  • Upd: Improve related issues such as command interruption and memory release
  • Upd: (PostgreSQL) Optimize the processing efficiency of the overall SQL query statement execution
  • Add: (Firebird) Added support for Srp256 authentication login method
  • Upd: PostgreSQL component version updated to Npgsql 5.0.11
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 8.5.4.0
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.115.5 (3.37.0)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.13.0
  • Upd: VistaDB component version updated to VistaDB.6.dll 6.2.3
  • Fix: (PostgreSQL) Solve the problem that npgsql does not automatically update the version number when switching between different database versions on the same source host
  • Upd: Others include cumulative minor updates, corrections and optimization processing
  • Displaying Data Types on the column header:
  • Fix: (Firebird) Fix and update v4 data type display
  • Fix: (SybaseASE) Fix data type display processing method
  • Fix: (MySQL/HP Vertica) Solve the problem that the starting value of ColumnOrdinal is non-zero and the related function is abnormal (different from other database bugs?)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software

New in Database .NET Professional 33.4.7943.1 (Sep 30, 2021)

  • Main program update (Main):
  • Upd: Upgrade .NET Framework to version 4.7.2, performance and related functions are optimized and improved at the same time (7943)
  • Add: Filtering Objects (Filtering Objects): Supports [all] database types, which can eliminate unnecessary object display, and improve processing speed at the same time (7943)
  • Add: Multiple selections: Supports clicking Escape during processing to interrupt processing (7943)
  • Add: (SQL Server/SQL Azure) Azure Active Directory authentication login method: Add Active Directory Default(7943)
  • Add: (Teradata) Added support for External Browser and Transport Layer Security (TLS) authentication login methods (7943)
  • Upd: Allow connection to the database type of SQL Server but the connection source is the connection setting of SQL Azure (to prevent users from selecting the wrong database type) (7943)
  • Fix: Fix Parse Query processing method (7943)
  • Upd: (SQLite) Improve the processing speed of opening AES256 encrypted database (7943)
  • Fix: (Oracle) Remove all blank characters at the beginning and end of the SQL statement during execution to avoid errors such as (ORA-00911/ORA-00900) (7943)
  • Upd: (Firebird) Update asynchronous processing and execution plan processing (7943)
  • Add: Support manually click the lower right corner of the label status bar to change the database type (7943)
  • Upd: Continuously optimize the interface and HiDPI high zoom ratio display problem (7943)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 3.0.1 (2021/09/24)()(7943)
  • Upd: PostgreSQL component version updated to Npgsql 5.0.10 (2021/09/15)()(7943)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.10.2.0 (2021/05/11)()(7943)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 8.0.1.0 (2021/04/07)()(7943)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7943)
  • Data Export:
  • Upd: Export of Single INSERTs is changed to batch processing to avoid exceptions such as the limit on the number of entries in the database and the length of the text (7943)
  • Generating Scripts:
  • Upd: (Oracle) Optimized using quoted identifiers for objects = False to generate processing when canceling the setting (7943)
  • Fix: (SQL Server/SQL Azure) Fix the issue of Included Columns generation (7943)
  • Table Designer:
  • Upd: If the new field has been assigned a name, avoid clicking Escape to delete it (7943)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET software (7943)

New in Database .NET Professional 33.3.7919.1 (Sep 6, 2021)

  • Browse and Edit Data Bar (Data Browser and Editor ):
  • Add: Optimize the edit display, the new row contains auto-increment fields/default values/calculated data fields... and other prompt displays (7919)
  • Add: Edit field prompt messages, add Field attributes/default values/calculated data fields... and other content display (7919)
  • Add: Edit the background color of the field, the default value and calculated data fields are displayed in different background colors (7919)
  • Add:Right-click menu save function (Save): Add sub-function to add new row ([ADD] Add a new row) (7919)
  • Add: Right-click menu search function (Find): Add sub-function to move to row ([G] Go To Row) (7919)
  • Add: Move to Row (Go To Row: Ctrl + G ): Added Move to Top and End shortcut keys (7919)
  • Fix: Fix (7890) the field is IS NULL+DEFAULT VALUE and COMPUTED COLUMN cannot be automatically issue (7908) update
  • SQL editor ( SQL editor ):
  • the Add: right menu search function, increased sub-function moved to the line ([G] the To Go line) (7919)
  • the Add: move line (the To Go line: Ctrl + G ): Added Move to Top and End shortcut button (7919)
  • Upd: Right-click menu to reposition multiple sub-function keys (7919)
  • Upd:Update the display of the input method window, the window moves with the cursor to replace the floating display (7919)
  • Upd: Improve the exclusion of exceptions when parsing single-line comments in the statement (7908)
  • Fix: Fix the problem that the exception message pops up after the save as file format is .htm ( 7919) -AutoComplete and IntelliSense
  • ( AutoComplete and IntelliSense ):
  • Upd: Improve when the input method is turned on, do not do any automatic completion and perception processing (7919) -Main
  • program update ( Main ):
  • Fix: (PostgreSQL) Resolve 25P02 Exception handling, and provide more detailed error reason display (7908)
  • Upd: Optimized interface and HiDPI high zoom ratio display problem (7919)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.115.0 (3.36.0) ( 2021/08/25) (7919)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7908) -Backup
  • and restore ( And Restore Backup ):
  • Fix: After (SQL Server) a revised version of the update causes problems related controls can not be changed manually enter (7908)
  • Database Migration ( Database Migration ) (Pro):
  • Upd: all updates with dbMigration .NET software ( 7908)

New in Database .NET Professional 33.2.7898.1 (Aug 16, 2021)

  • Automatic completion and perception ( AutoComplete and IntelliSense ):
  • Upd: Improve the processing speed of auto-sensing lists, reduce unnecessary processing and avoid rearrangement problems (7898)
  • Upd: Solve the problem of delayed processing of PageUp , PageDown , Home , and End buttons (7898)
  • Fix: Fix Ctrl+ J When opening List Members, the highlighted text is not fully synchronized (7898)
  • Fix: Fix (7890) the problem that other related objects in the table cannot be loaded after executing the preloaded table field (7898)-Object
  • browsing ( Object Explorer)
  • Fix : Fix the problem that the horizontal scrolling [Object function key] cannot be displayed normally (7898)
  • Upd: Optimize the display of node prompt messages and solve the problem of excessively long and overlapping display content (7898)
  • Fix: (SQL Server/SQL Azure) Fix the problem of abnormal display when browsing DBTRIGGERS objects (7898)-Main
  • program update ( Main ):
  • Upd: (64bit) Support the latest PostgreSQL 14.0 beta3 database backup/restore processing (7898)
  • Fix: Fix (7890) cause the object to be expanded The problem that the parameters will still be reorganized (including multiple impacts) (7898)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7898)-Database
  • object search ( Search Database Objects ):
  • Fix : Fix the problem that when the search object itself does not contain sub-objects, the object cannot be found when the Sub-Objects is turned on (7898)
  • Fix: Fix the problem that the window is forced to close during the search process (7898) )
  • Generate scripts ( generating scripts ):
  • the Add: (SQL Server / SQL Azure / PostgreSQL) supports the generation of single DEFAULT CONSTRAINTS object syntax defined (7898)
  • the Add: (VistaDB) supports the generation CHECK CONSTRAINTS object syntax definition (7898) alone
  • Profile column viewing and editing (the data browser and editor):
  • Upd: (SQLite) data type time display and output in the same way datetime to meet the official definition of the way (7898)

New in Database .NET Professional 33.1.7894.2 (Aug 12, 2021)

  • Data Import ( Data Import ):
  • Fix : Fix the low-level error that can not be used normally when the import function is converted to [Official Version] (affects including table editing) (7894)-SQL
  • Editor ( SQL Editor ):
  • Upd: (64bit) IntelliSense Parameter Info ( IntelliSense Parameter Info ): Right-click the mouse to close the prompt to avoid affecting the menu display (7894)-Main
  • program update ( Main):
  • Upd: Others include cumulative minor updates, corrections and optimizations (7894)

New in Database .NET Professional 33.1.7890.1 (Aug 8, 2021)

  • Data Import ( Data Import ):
  • Add: Support Bulk Insert mode ( Bulk Insert mode ): Significantly improve the import processing speed (7890)
  • Currently supports SQL Server/SQL Azure/NuoDB/IBM DB2/SQLite/PostgreSQL/MySQL/Firebird and other databases
  • Upd : Optimize the processing speed of Batch Insert mode (7890)
  • Fix: Improve the judgment of the end character (NullChar) to avoid generating empty columns (7890)
  • Object Explorer ( Object Explorer ):
  • Add: Support source table size information ( Table Size Information ) display (7890)
  • Support SQL Server/Sybase ASE/PostgreSQL/MySQL/Oracle and other databases
  • Main program update ( Main ):
  • Add: The ROWS COUNT message display (7890) is added to the data table property page.
  • Upd: Click to reset the data table to [automatically run] statistical data update processing (Table Statistics) (7890)
  • Upd: Optimize the interface and HiDPI high zoom ratio display problem (7890)
  • Add : Support MariaDB database backup and restore processing (7890)
  • Fix: (MySQL/PostgreSQL) Fix exception processing when additional files are not installed or executable files are not found when performing database backup (7890)
  • Upd: Oracle component version updated to Oracle .ManagedDataAccess.dll 19.12.0(2021/08/05) (7890)
  • Upd: Update the .NET Additional Files Database ( 32bit / 64bit ) (2021/08/06) (7890)
  • Upd: Other includes the cumulative minor updates, fixes and optimization (7890)
  • data Export ( Data Export ):
  • Add: (Oracle) .sql export format, support INSERT ALL to generate content (7890) -SQL History
  • ( SQL History ):
  • Upd: The same SQL statement will only be retained when the same SQL statement is executed continuously and repeatedly pen, to reduce unnecessary treatment record (7890)
  • database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7890)

New in Database .NET Professional 33.0.7874.1 (Jul 23, 2021)

  • Main program update ( Main ):
  • Upd: Improve and fi issues related to Asynchronous Processing (7874)
  • Upd: Optimize the interface and HiDPI high zoom ratio display issues (7874)
  • Fi: (Access) Fi that the database cannot be [re]opened under Windows 7 (7874)
  • Fi: (Access) Fi the password protection (MDB) database cannot be opened normally without ACE Provider (7874)
  • Upd: MySQL component version updated to 8.0.26 MySql.Data.dll (2021/07) ( ) (7874)
  • Upd: Other includes the cumulative minor updates, fies and optimization (7874)
  • row editing (the Data Browser and Editor ):
  • Upd: Advanced Editing [ ADV] when the same table is not repeated open a new tab (7874)
  • Import data ( the data Import ):
  • Upd: optimization importing process, while supporting the processed per second column shows the average (Avg rows / s.) ( 7874 ) -SQL
  • Performance Analyzer ( SQL Profiler ):
  • Upd: (SQLite) Improve the official Trace event output processing, automatically eclude a large number of repeated statement display (7874)
  • Upd: a large number of code optimization processing (7874)-Database
  • Migration ( Database Migration) )(Pro):
  • Upd:All updates are the same as dbMigration .NET software (7874)

New in Database .NET Professional 32.9.7866.1 (Jul 15, 2021)

  • Script Generator ( Script Generator ):
  • Upd: Generate UNIQUE index method and process it in CREATE mode (7866)
  • Upd: (SQLite/SQL Server/SQL Azure/Firebird) Omit the default data row ordering to simplify the generated content (7866)
  • Fix: (Informix ) Fix the problem of automatically created index generation (7866)
  • Fix: (Firebird) Avoid repeated generation of UNIQUE index (7866)
  • Fix:(VistaDB/MySQL) Fix the problem that the field comment contains the exception character (') (7866)
  • Upd: Whether to include the conditional constraint name, add PK processing (default PK/FK not included) (7866)-Main
  • Program update ( Main ) :
  • Upd: (Firebird) Optimize and unify the data type output processing of all objects (7866)
  • Upd: (SQL Server/SQL Azure) Add a prompt message when the Azure Active Directory authentication item is selected (7866)
  • Upd: Improve user experience: Click no longer contains a child node (7866) of the node collapsing
  • Upd: other minor updates contain accumulated, correction and optimization (7866)
  • Design table ( the table Designer ):
  • Fix: (Firebird) corresponding to the correction is not included when setting COLLATE CHARACTER SET NAME question (7866)
  • Rows browsing and editing (the data browser and editor):
  • Upd: Support (>2D) Multidimensional Arrays related processing (7866) -SQL Editor
  • ( SQL Editor ):
  • Upd: Improve statement parsing and multi-line annotation processing to avoid freezing (7866)-Data
  • Import( Data Import ):
  • Fix: Fix and improve the copy and paste (Copy and Paste) preset encoding processing problem (7866) -Connection Process Manager
  • ( Connection Process Manager ):
  • Upd: Automatically close after execution when the permission cannot be opened (7866) )
  • Database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7866)

New in Database .NET Professional 32.8.7857 (Jul 6, 2021)

  • Query Tabs:
  • Add: Support Custom Database Type Tab Colors
  • User Interface->Query Tabs->Database Types
  • Main Program Update (Main):
  • Upd: Compatible with Microsoft Windows 11
  • (SQLite) Add LOCALIZED custom collation
  • Add: (SQLite) Add AES256 encryption database REGEX function support
  • Upd: (PostgreSQL 14) Update multirange data types output problem
  • Upd: Run query To text display (Execute query to text): restore the original output mode after completion (to Grid/File/Text)
  • Upd: unified sort processing of all database name example items
  • Upd: optimized interface and HiDPI high zoom Scale display problem
  • Upd: Others include cumulative minor updates, corrections and optimization processing
  • -Filtering and Sorting columns
  • Filtering and Sorting columns:
  • Add: The column type is displayed directly to the right of the column name
  • Upd: default click copy to copy the whole election process field
  • SQL editor (SQL editor):
  • the Add:When the database file Drag & Drop to the editor will automatically detect the type and open to the database form
  • Code Management (Code Manager):
  • Upd: Search List height allows the scaling process
  • Database Migration (Database Migration)(Pro):
  • Upd: All updates are the same as dbMigration .NET software

New in Database .NET Professional 32.7.7848.1 (Jun 27, 2021)

  • Code Management (Code Manager):
  • Add: Support separate processing of re-flashing the home directory, when the designated home directory contains sub-directories [Re-flash the home directory], specify the root directory [Re-flash all directories] (7848)
  • Add: Support automatic sorting processing after adding files or directories (7848)
  • Fix: Fix the problem of handling new blank documents through the right-click menu (7848)
  • Fix: Fix and improve many problems such as New, Open and Save (7848)-Main
  • Program update (Main) :
  • Upd: (Sybase ASE/MySQL) Improve the speed of obtaining DEFAULT VALUES (impacts include multiple points) (7848)
  • Add: (OData) Support collection data type and content display (7848)
  • Fix: (SQL Azure) Fix (7825) cause it to be abnormal The problem of loading objects (7837)
  • Fix: (SQL Server/SQL Azure/Sybase ASE) Fix the problem that a small part of EXEC/SELECT input parameters does not contain the N'' identifier (7848)
  • Add: The tree node display item exceeds When bordering, it will be displayed in full with a tooltip (7837)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.6000.4) (2021/06/21) (7848)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.6 FP0 (2021/06/21)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7848) -Script
  • Generator (Script Generator):
  • Fix: Fix (7788) the problem of ALTER script generation error (7848)
  • Upd: More optimization of script generation speed and reduction of memory usage processing (7848)
  • Query Tabs:
  • Fix: when the label name contains parentheses, issues related to improvement and correction (7848)
  • Mains connection (Connection Explorer):
  • The Add: right-click menu to increase the connection comment (comment) option (7848)

New in Database .NET Professional 32.6.7837.2 (Jun 16, 2021)

  • Main program update ( Main ):
  • Fix: (SQL Azure) Fix (7825) the problem that causes the object not to be loaded normally (7837)
  • Add: When the tree node display item exceeds the boundary, it will be displayed in full with a tooltip (7837)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7837)

New in Database .NET Professional 32.6.7825.1 (Jun 4, 2021)

  • Add: Support the latest Firebird 4.0 RTM database system (2021/06/01)
  • Add: (Firebird 4) Support int128, decfloat, timetz, timestamptz and other data types related function processing
  • Upd: (Firebird) Update time time data type microsecond length display and output problem
  • Add:(Firebird) Rewrite database backup and restore, and support remote (Remote) and local (Local) processing
  • Add: (All) Support BigInteger data type related processing
  • Add: (Oracle) Support BFILE, XMLTYPE and other data type related function processing
  • Upd: (Oracle) Support and correction of INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH and other data type related function processing
  • Add: (SybaseASE) Add date, time, bigdatetime, bigtime Waiting for the data type
  • Upd: (SQLite/SybaseASE/HP Vertica) Update time The time data type only displays the part of the output time
  • Fix: (NuoDB) Fix the problem that the time data type cannot be processed
  • Upd: Initial Check the existence of the selected (database or structure description)
  • Upd: Improve and modify the data [Edit and Import] field type (including length) recognition processing
  • Upd: Others include cumulative minor updates, corrections and Optimization processing
  • rows browsing and editing (the Data Browser and Editor ):
  • Upd: to enhance the ability to obtain information on the type of display
  • Upd: field background color recognition AllowDBNull Browse mode or not
  • Data Grid Editor ( the Cell Editor )/ Cell Viewer :
  • Add: Support code editor (Code Editor) and text editor (Text Editor) to switch display -SQL Editor
  • ( SQL Editor ):
  • Upd: (IBM DB2/ Oracle) after the completion of the implementation of the SQL DBMS_OUTPUT close processing
  • database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NETSoftware

New in Database .NET Professional 32.5.7818.2 (May 28, 2021)

  • Main program update ( Main ):
  • Fix: Fix (7814) the problem that the judgment of ignoring case difference is not working (affects multiple functions)
  • Upd:Other minor updates include the cumulative correction and optimization
  • connection settings ( Connection Profile ):
  • new Directory contains the Active Interactive / Service Authentication methods such as Principal/Device Code Flow/Managed Identity
  • Editor ( SQL Editor ):
  • the instruction code generator ( Script generator)
  • Database Migration ( Database Migration ) (Pro)
  • Upd : All updates are the same as dbMigration .NET software

New in Database .NET Professional 32.5.7814.1 (May 24, 2021)

  • Connection Setting ( Connection Profile ):
  • Add: (SQL Server / SQL Azure) support for the latest Azure Active Directory authentication Login methods (7814)
  • new Directory contains the Active Interactive / Service Principal / Flow Device Code / Managed the Identity and other authentication
  • Add:(SQL Server/SQL Azure) Add Active Directory Authentication drop-down option in the main interface (7814)-Main
  • program update ( Main ):
  • Add: (SQLite) Additional Commands ( Additional Commands ): Support loading application extension modules SELECT LOAD_EXTENSION(' filename ')(7814)
  • Add: (SQLite) database tool supports loading application extension modules (Mainmenu -> Database Tools -> Extensions )(7814)
  • Add: supports the latest PostgreSQL 14.0 beta1 database system (2021/05/20 )(7814) The
  • update includes: (64bit) database backup/restore/object authorization management ( Grant Manager )... and other functions (7814)
  • Upd: Update Database .NET Additional Files 64bit(2021/05/20)(7814)
  • Update PostgreSQL 14.0 related components
  • Add: (PostgreSQL) Added support for hstore and ghstore extended data types (7814)
  • Upd: (PostgreSQL) Fixed structure description PUBLIC is the default search path (search_path)( 7814)
  • Upd: (Firebird) Reserved Words (ReservedWords) are loaded according to different database versions (7814)
  • Fix: Improve the processing when the last selected (database or structure description) of the load no longer exists (7814)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7814)-SQL
  • Editor ( SQL Editor ):
  • Add: Code Folding: Add SELECT...FROM processing (7814)
  • Add: Automatically summarize the same data of INSERT INTO table record processing, display and reduce unnecessary records (7814)
  • - the script generator ( Script generator ):
  • Fix:Generation (SQL INSERTs) multiple choice items into a single file related bug fixes (7814)
  • Upd: optimized instruction code generation processing speed and reduce the memory footprint (7814)
  • - Database Migration ( Database Migration ) (Pro):
  • Upd: All Updates with dbMigration .NET software (7814)

New in Database .NET Professional 32.4.7804.1 (May 14, 2021)

  • Main program update ( Main ):
  • Add: Object [ Quick Filter / Auto-Complete ]: Contains DATABASE TRIGGERS object (7804)
  • Upd: Improve the processing speed of obtaining the total number of table data rows (affects multiple functions) (7804)
  • Upd: Servo version connection editor Number limit, increased to 512 characters (7804)
  • Upd: Asynchronous Processing:
  • Add:Support for asynchronous processing such as [Backup/Restore/Compression/Encryption] (7804)
  • Upd: (SQLite) Improve the processing efficiency of file-related functions (7804)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 ( 3.35.5) (2021/05/02) (7804)
  • Upd: other minor updates contain accumulated, correction and optimization (7804)
  • Comparative query ( comparison query ):
  • Upd: Add the main label [repeat / compare / substituted] related function processing (7804)
  • the script generator ( Script generator ):
  • Upd: (the SQLite) supported omitted gENERATED ALWAYS calculated data fields generating process (7804) keyword
  • Upd: (the SQLite) improved detection CHECK Constraints generation processing ( 7804)
  • Upd: (SQLite) Remove the HIDDEN keyword when the data type is displayed (7804)
  • Database Migration ( Database Migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7804)

New in Database .NET Professional 32.3.7788.1 (Apr 28, 2021)

  • Main program update ( Main ):
  • Upd: Asynchronous Processing (7774)
  • Add: Support Asynchronous [Interrupt] Processing (7788)
  • Add: Support Database [Connect] Asynchronous Processing (7788)
  • Add: Support [ Intelligent Sensing Parameter Message ] Asynchronous processing (7788)
  • Upd: Optimization and support for more [Query] and [Browse] Asynchronous processing (7788)
  • Upd:Optimize and improve ODBC asynchronous processing (7788)
  • Fix: (MySQL/Informix) Fix the problem of trying to switch connection after clicking to cancel the connection test (7788)
  • Upd: Improve the display of different themes (Themes) HiDPI high zoom ratio (7788) )
  • Upd: MySQL component version updated to MySql.Data.dll 8.0.24 (2021/03/25) ( )(7788)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7788) -Data
  • Column browsing and editing ( Data Browser and Editor ):
  • Upd: (Oracle) Solve the problem that the timestampltz read speed is too slow (7788) -SQL Editor
  • ( SQL Editor ):
  • Upd: Automatically jump to the error column (or position): Contains annotations and variable processing issue (7788)
  • Data import ( the data Import ):
  • Upd: Modify seconds batch processing (Batch Seconds:> 2s to> 3s), automatic batch approval (7788) is exceeded
  • Screening of field data ( Filtering Data of column A ):
  • the Add: Support type field value IS [ NOT] NULL data screening process (7788)
  • Upd: improved search input processing, while reducing the delay search problem (7788)
  • Database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7788)

New in Database .NET Professional 32.2.7774.1 (Apr 14, 2021)

  • Add: Support Asynchronous Processing:
  • Misc: Initially search and browse the database in advance of [Native] and [Non-Native] Asynchronous Processing
  • Add: Main Menu Tab Name (Tab Name): Support Click Swipe Middle mouse button to close the tab
  • Upd: (MySQL) Remove the wrong connection attribute Allow Load Data Local Infile, and change it to the default enable processing
  • Fix:Fix the problem that the current [database or structure description] is not restored after reconnecting without interrupting the connection
  • Fix: (32bit) Fix (7761) the problem that the taskbar is displayed abnormally when the window is maximized
  • Upd: PostgreSQL component version updated to Npgsql.dll 4.1.9 (2021/04/06)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 (3.35.4) (2021/04/ 02)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.5010.4) (2021/04/01)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5 FP1 (2021/04/01)
  • Upd: Others include cumulative minor updates, corrections and optimization processing -Data Browser
  • Viewing and Editing (Data Browserand Editor ):
  • the Add: upper left corner column shows the total number of fields (Total Columns count) and the total number of data (Total Rows count) column
  • Upd: field tips ( Column Tips ) and the Field Properties ( Column the Properties ): Support Display of the same field name in different tables
  • Upd: The data collection label of high memory consumption will be automatically closed after disconnection
  • Fix: (PostgreSQL) Fix (7592) cause the object to return to the data collection display ( Displaying RefCursor) results ) function does not work-Data
  • Editor (Data Editor):
  • Add: filter expression (Filter Expression) adds a key to clear (Clear) button processing-Search Table Data
  • Search Table Data:
  • Add:Add one-click Clear button processing to search conditions-Search Database Objects
  • Search Database Objects:
  • Upd: Improve the efficiency of script content search, cancel processing through the clipboard-Script Generator
  • Script Generator:
  • Upd: Improve the efficiency of generating script processing, cancel processing through the clipboard-Visual Execution Plan
  • Visual Execution Plan:
  • Fix: (HP Vertica 9.x+) Solve problems caused by the difference in the output format of the database version issue of the normal display
  • Vertical label mode ( vertical Number of Tabs mode ) (64bit):
  • Fix: corrected (7761) cause problems label search stalled

New in Database .NET Professional 32.1.7761.1 (Apr 1, 2021)

  • Main program update (Main):
  • Fix:
  • Fix (7716) In a specific database, if the last line of the statement is a one-line comment (--), an exception may occur (.NET's bug??) (7761)
  • Fix (7744) causes Jet< ->The problem that the automatic switching ability of the ACE driver does not work (7761)
  • Fix the problem that the data bar is edited and minimized and then restored, which causes the task bar to display abnormally (7761)
  • Add:
  • Add the display or hide the explorer panel button to the task bar ( 7761)
  • Add: Added toggle folding function (Format->[T]Toggle All Foldings: Alt + T, Toggle Folding: Alt + F ) (7761)
  • Upd:
  • Upd: Optimize HiDPI high zoom ratio display(7761)
  • Upd: (SQLite 3.35+) SQL References and Reserved Words add support for Math functions (7761)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 (3.35.3) (2021/03/30)( 7761)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.11.0 (2021/03/05)(7761)
  • Upd: VistaDB component version updated to VistaDB.6.dll 6.1.2 (2021/02/28)( 7761)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7761) -SQL Editor
  • ( SQL Editor ):

New in Database .NET Professional 32.0.7744.1 (Mar 15, 2021)

  • Main program update ( Main ):
  • Add: Main menu integrates functions such as Tab Name and Context Menu (7744)
  • Add: Main taskbar integrates close and tab switching (Close/Previous/Next Tab) functions (7744)
  • Upd: The Recent connections menu supports scrolling processing to avoid excessively long display (7744)
  • Upd: The query tab menu is moved to the sub-option (Window->Tabs), and scrolling processing is supported at the same time to avoid excessively long display ( 7744)
  • Upd:The recently closed tabs drop-down menu supports scrolling to avoid excessive display (7744)
  • Fix: Fix the problem that the Tooltips cannot be redisplayed after executing the menu sub-functions (7744)
  • Upd: Others cumulative contains minor updates, correction and optimization (7744)
  • vertical tag mode ( vertical Tabs mode ) (64bit):
  • the Add: redesigned vertical mode label ( redesign vertical Tabs mode ): displays more intuitive, more convenient operation (7744)
  • Add: Support label placement and movement processing ( ALT must be pressed) (7744)
  • Add: Support label index number (IndexNumber) display (7744)
  • Upd: Completely replace no longer display horizontal labels at the same time (7744)
  • Upd: Update and optimize label color , Text style and prompt display (7744)-Query
  • Tabs:
  • Add:Increase the label auto-scaling setting option (Rename->Enable AutoResize Tabs: On/Off) (7744)
  • Fix: Fix (7716) the problem that may cause the index label data type and name sort processing to be invalid (7744)
  • Fix: The title name length is 1 when issues related amendments (7744)
  • Compare query ( comparison query ):
  • Upd: allows segmentation query mode with the float query mode back and forth to switch directly (7744)
  • row editing (the data editor ):
  • the Add: In addition to the original GUID type, increase Character type [VAR]CHAR(36) Support ( GUID Generator )(7744)

New in Database .NET Professional 31.9.7734.1 (Mar 5, 2021)

  • Upd: Significantly rewrite and optimize the processing efficiency of the transaction mode, affecting multiple related functions (7734)
  • Upd: Allow editing data ( Editing Data ) and search ( Search Table Data ) processing in the transaction mode (7734)
  • Upd: Non-query tab Mode (Non-Query Tabs) are processed in non-transaction mode (7734)
  • Upd:Enhance the interrupt handling, with non-transaction mode (7734)
  • Upd: data import ( the Data Import ) and script file execution ( Script File Execution ) is added to close the transaction mode prompt treatment (7734)
  • Fix: (Access) Provider amended version compatibility Sexual issues (7734)
  • Fix: (Firebird ) Fix the problem that the execution plan (Execution Plan) cannot be displayed completely (7734)
  • Fix: (PostgreSQL/SQL Server/SQL Azure) Fix the exception handling problem when the transaction mode executes the wrong syntax (7734)
  • Fix: Fix the SessionID acquisition problem, affecting related functions (7734)
  • Fix: Fix the problem that may cause abnormal exit when establishing a connection failure (7734)-Main
  • Program update ( Main ):
  • Upd: Improve analysis SQL and binding variables (Parsing SQL and Binding Variables) Test processing speed (7734)
  • Upd: Avoid the problem of abnormalities caused by repeated clicks on the connection during the connection process (7734)
  • Upd: Secure Shell protocol ( SSH: Secure Shell ) components to update Renci.SshNet.dll 2020.0.1 (2021/01/24) (7734)
  • Upd: filtering and servo version of the database schema ( Filtering Databases and Schemas ): Automatic processing added over detection avoid having to wait too long (7734)
  • Upd: improved relative path (relative path) processing mode (7734)
  • Upd: other comprising accumulated small update, modification and optimization (7734)
  • To generate script ( generating the scripts ):
  • Upd: (PostgreSQL) Add REFERENCING and WHEN condition generation display (7734)
  • Fix: (SQL Server/SQL Azure) Fix the problem that the field Nullable status cannot be obtained correctly when the table name starts with _ (7734)-Database
  • Migration ( Database Migration )(Pro):
  • Upd:All updates are the same as dbMigration .NET software (7734)

New in Database .NET Professional 31.8.7716.1 (Feb 15, 2021)

  • Query Tab (Query Tabs):
  • Add: Support title auto-scaling (AutoResize) processing (7716)
  • Add: Support title index number (IndexNumber) display (7716)
  • Add: Tab Tips (TabTips) increase database type display display (7716)
  • Upd: Tab page The icons (Icons) update the display with the connection status (7716)
  • Fix: Fix the problem that the title will not be displayed when the width exceeds the display (7716)
  • Main program update ( Main ):
  • Add: New Query in the taskbar adds a drop-down menu of Recently closed tabs (7716)
  • Add: (SQLite) Memory Database supports encryption database (RC4/AES256) restore processing (7716) )
  • Upd: (SQLite) Keep the encrypted (password protected) status of the encrypted database (RC4/AES256) backed up (7716)
  • Fix: (SQLite) Fix to open the RC4 encrypted database, if the password is entered incorrectly for the first time, it can no longer Open problem (7716)
  • Upd: (Firebird 4) Support Decimal/Numeric 19-38 accuracy (7716)
  • Upd: Avoid the problem that may cause Access violation when the database is closed and reopened immediately (7716)
  • Upd: Optimize HiDPI high zoom ratio Under, the display problem of larger fonts and sub-controls (7716)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7716)
  • Data Browser and Editor:
  • Upd:(64bit) On a 64-bit platform, support for accessing objects larger than 2GB (7716)
  • Upd: Optimize the display efficiency of Virtual Mode (7716)
  • Upd: Improve the display of tooltips (7716) and automatically sensing ( the autoComplete and IntelliSense )
  • Upd: table alias automatic generation process (AutoAliases): eliminating unnecessary generation processing (7716) to generate script ( generating the scripts )
  • Fix: (Firebird) and the correction CHARACTER SET COLLATE generation display problems (7716) database migration ( database migration ) (Pro)
  • Upd: all updates with dbMigration .NET software (7716)

New in Database .NET Professional 31.7.7695.1 (Jan 25, 2021)

  • Main program update ( Main ):
  • Add: The waiting window supports Countdown time display (7695)
  • Fix: Fix the interrupt processing on some databases, which may cause the problem of waiting too long (7695)
  • Fix: (PostgreSQL) Fix (7592) There is a problem that some data types cannot be read (7695)
  • Upd: (PostgreSQL) When connecting to Amazone Redshift, the compatibility mode is automatically set to avoid the Host can't be null error (7695)
  • Upd:Optimized display and control issues under HiDPI high zoom ratio >150 (7695)
  • Upd: PostgreSQL component version updated to Npgsql.dll 4.1.8 (2021/01/21)(7695)
  • Upd: MySQL component version updated to MySql.Data. dll 8.0.23 (2021/01/18)( )(7695)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.10.1 (2021/01/13)(7695)
  • Upd: Secure Shell Protocol ( SSH: Secure Shell ) component updated to Renci.SshNet.dll 2020.0.0 (2020/12/31)(7695)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7695) -Custom
  • SQL file location ( Specifying the location of SQL files ):
  • Add:Add settings to the main settings option (Options->Custom SQL files location)(7695)
  • Upd: Support resetting to the preset location when re-modifying (7695)
  • Upd: Add interruption to restore the preset path processing to avoid incorrect assignment long waits (7695)
  • SQL editor ( SQL editor ):
  • The Add: keep the original formatting ( Keeping original formatting ): support Compact process ()
  • Database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET Software (7695)

New in Database .NET Professional 31.6.7681.1 (Jan 11, 2021)

  • Main program update ( Main ):
  • Add: Support Firebird 4.0 new data type processing (int128, decfloat(16/34), time with time zone, timestamp with time zone)(7681)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.10 .1.0 (2020/12/05) ( ) (7681)
  • Upd: the PostgreSQL version update to the member Npgsql.dll 4.1.7 (2020/12/12)(7681)
  • Upd: Secure Shell Protocol ( SSH: Secure Shell ): PrivateKey supports both absolute and relative position saving (7681)
  • Add: (MariaDB) supports System-Versioned Tables (Temporal Tables) Object-related processing (7681)
  • Upd: Optimize the display and control of HiDPI high zoom ratio >150 (7681)
  • Fix: Solve the problem of continuous flashing when the status bar prompts overlap with the mouse cursor (7681)
  • Upd : Update Italian language (by Paolo Saudin) (7681)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7681) -Server
  • Version database and structure description filtering ( Filtering Databases and Schemas ):
  • Add: Data Filter processing of library and structure description, add to the root node right-click menu (7681)
  • Add:(SQL Server) increased automatically excluded functions (7681) when no permission to access the database
  • Generated scripts ( Generating Scripts ):
  • Fix: fixes and improvements related fields pre-processing IS NULL the DEFAULT (7681)
  • Database Migration ( Database Migration )(Pro):
  • Upd: All updates are the same as dbMigration .NET software (7681)

New in Database .NET Professional 31.5.7643.1 (Dec 4, 2020)

  • View and edit data (Data Browser and Editor ):
  • Add: When the memory consumption exceeds Max 1GB(32bit)~8GB(64bit), it will automatically prompt to choose whether to continue or not to avoid affecting processing performance
  • Add: When memory is insufficient (OutOfMemoryException) Automatically interrupt processing at the time to avoid abnormal exit
  • Upd: The browsing progress increases and the memory occupied is displayed
  • Program update (Main):
  • Add: (Informix) Supports SQLI and DRDA Protocols dual communication protocol, automatic source detection Switch processing
  • Add:(Firebird) Support manually specifying the connection code (default is the database code)
  • Fix: (PostgreSQL) After the correction (7592), the numeric database type related processing
  • Upd: IBM DB2/Informix component version updated to IBM 9.7.4.4 .Data.DB2.dll (11.5.5000.9) (2020/11/18)
  • Misc: (IBM the DB2 / Informix) IBM the Data Server Client Packages Standard Package Version 11.5 FP0 (2020/11/18)
  • Upd: available The initial directory location of the portable database is automatically obtained from the location of the previous database, which greatly simplifies the omission of selection processing
  • Upd: Others include cumulative minor updates, corrections and optimization processing
  • And sorting field names ( Filtering and the columns the Sorting ):
  • the Add: enable supports copying selected field to the clipboard functions (copy the selected the columns to Clipboard)
  • Data import ( the data Import ):
  • the Add:Support batch file importing process (Batch Support), allows select multiple files into processing
  • Data Export ( the Data Export ):
  • Upd: user interruption after processing to avoid unnecessary subsequent processing operation
  • Generating a script ( generating the scripts ):
  • Fix: Fixed CLOB preset types of data missing quotes '' process
  • Design table ( the table Designer ):
  • the Add: (the SQLite / the Oracle 12+) [update] table ( Design Table) support new Auto field processing
  • Database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software

New in Database .NET Professional 31.4.7629.1 (Nov 20, 2020)

  • Main program update ( Main ):
  • Upd: Oracle component version is updated to Oracle.ManagedDataAccess.dll 19.10.0 (2020/11/17)(7629)
  • Related updates retain Oracle 10 support without being affected (7629)
  • Support Easy Connect Plus connection method and changes Latest connection settings (7629)
  • Add: Add Norwegian Bokmaal language (by Edvind Håpnes) (7629)
  • Add: (PostgreSQL 12+) Add JsonPath Type database type related processing (7629)
  • Add:(PostgreSQL) Add Composite Types to UDDT custom types (7629)
  • Fix: Improve interrupt handling capability, and fix (7613) The problem that automatic disconnection processing is not enabled (7629)
  • Upd: (Firebird) When the embedded version component does not exist, The original settings will be reopened to facilitate the update (7629)
  • Fix: (Oracle 10/11) Fix the problem that the initial default value of NUMBER exceeds the limit (7629)
  • Fix: Solve the problem that the size cannot be set correctly when using third-party fonts (7629)
  • Upd: PostgreSQL component version updated to Npgsql.dll 4.1.6 (2020/11/16)(7629)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7629) -Data
  • Browser and Editing (Data Browser and Editor ):
  • Add: Support ExpandoObject data type analysis processing (7629)
  • Fix: (PostgreSQL) Fix the problem that Composite Types data type cannot be displayed after (7592)
  • Fix:(PostgreSQL) Corrected (7592) timestamp/timestamptz/tstzrange database type related processing (7629)
  • Fix: (PostgreSQL) Corrected time/timetz database type related processing (7629)
  • Upd: Added timetz and improved timestamptz database type analysis capabilities (7629)
  • To generate script ( generating the scripts ):
  • the Add: support sCRIPT AS ALTER grammar definition generating (7629)
  • Fix: (Firebird) correcting (7613) lead to some type of information extra incorrect length is displayed (7629)
  • Fix: (Firebird ) amended DBTRIGGERS generation problem stalled (7629)
  • Data grid editor ( the cell editor ) / data grid browser ( the cell Viewer ):
  • Fix: (PostgreSQL) correction (7592) after Json Jsonb data type can not be saved question / ( 7629)
  • Data Export ( the data Export ):
  • the Add:(csv / tsv / psv / ssv / sql) to increase the blank option trimmed end of the line data (Trim Spaces trailing from the Data Fields) (7629)
  • SQL editor ( SQL Editor ):
  • Fix: corrected text under the old version of the implementation of Oracle 10g plan ( Plain Execution plan ) issue (7629) can not be displayed
  • Database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7629)

New in Database .NET Professional 31.3.7613.1 (Nov 4, 2020)

  • (SQL Server/SQL Azure) Change to PROC method to improve the processing speed of index key reference acquisition (7613)
  • Upd: Optimize (7607) interrupt handling capabilities, strengthen disconnected automatic reconnection processing (7613)
  • Fix: ( PostgreSQL) Fix (7607) 25P02: current transaction is aborted may occur in transaction mode (7613)
  • Fix: (Oracle) Fix (7607) the problem that DBMS_OUTPUT loses function, and rewrite the processing method (7611)
  • Upd: Others include accumulation Minor updates, corrections and optimizations (7613)
  • Transaction Mode ( Transaction Mode ):
  • Fix: (SQLite) Fix the problem that SQL Profiler ( SQL Profiler ) is not supported in transaction mode (7613)
  • Upd: (SQLite) distinguish journal mode=(wal/delete) processing method (7613) )
  • Fix: corrected (7607) cause problems stalled under the trading model (7611)
  • SQL editor ( SQL editor ):
  • Fix: solve the execution cursor may disappear issue (7613)
  • Conditions design constraints ( constraint Designer ):
  • Fix: (Oracle) can not be corrected problems include PK Tables (7613)
  • Automatically and perception ( autoComplete and IntelliSense ):
  • Upd: support and improve the object list of keyboard operation processing including Escape , PageUp , PageDown , Home , EndAnd other buttons (7611)
  • Generate scripts ( Generating Scripts ):
  • the Add: (Firebird 3.0+) support EXTERNAL ROUTINES (PROCEDURE / FUNCTION / TRIGGER ) grammar generation (7611)
  • Database Migration ( Database Migration ) (Pro):
  • Upd: All updates are the same as dbMigration .NET software (7613)

New in Database .NET Professional 31.2.7611.2 (Nov 2, 2020)

  • Main program update ( Main ):
  • Fix: Fix (7607) the problem that caused the loss of function in Transaction Mode (7611)
  • Fix: (Oracle) Fix (7607) the problem that caused DBMS_OUTPUT to lose function, and rewrite the processing method (7611)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7611) -AutoComplete and IntelliSense
  • AutoComplete and IntelliSense:
  • Upd: Support and improve the object list keyboard operation processing, including Escape ,PageUp , PageDown , Home , End and other buttons (7611) -Generating Scripts
  • Generating Scripts:
  • Add: (Firebird 3.0+) Support EXTERNAL ROUTINES (PROCEDURE/FUNCTION/TRIGGER) syntax generation (7611)

New in Database .NET Professional 31.2.7607.1 (Oct 28, 2020)

  • Main program update ( Main ):
  • Upd: Improved interrupt handling capability and faster interrupt handling speed (7607)
  • Support including SQL Server/SQL Azure/Oracle/PostgreSQL/MySQL/Sybase ASE/Informix/NuoDB and other databases
  • Add: ( MySQL) supports the latest connection verification method and the latest connection settings (7607)
  • Upd: MySQL component version is updated to MySql.Data.dll 8.0.22 (2020/10/19)( )(7607)
  • 1. Supports the latest connection Agreement, 2. Related updates retain MySQL 5.0 support without being affected.
  • Fix:(SQL Server) Rewrite (7577) Index key reference [multi-column] sorting statement to avoid possible freezing problems (7607)
  • Upd: (HP Vertica) Strengthen restart and disconnection processing (7607)
  • Add: (PostgreSQL) Support BitArray (bit(n)/varbit(n)) Data type browsing/editing/exporting/importing and related processing (7607)
  • Fix: (MySQL) Fix the problem that the data type ENUM(), SET() get content value lost (7607)
  • Fix: (IBM DB2) Fix the problem that the data type CHAR(n) FOR BIT DATA, VARCHAR(n) FOR BIT DATA does not contain the length (7607)
  • Add: Add the query result status bar icon display (Status Icon) ( 7607)
  • Fix: Solve and fix other related issues after upgrading to Npgsql.dll 4.1.5 (7607)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7607)-Security
  • Manager ( Security Manager ) :
  • Add: (PostgreSQL 9.0~9.4) Support table structure description permission definition language (DDL) generation (7607)
  • Fix: (MySQL 5.0~5.5) Fix the problem that user-defined language (DDL) cannot be generated (7607)
  • rows browsing and editing (the Data Browser and Editor ):
  • Fix: Fixed Array data type is empty {} display and related processing issues (7578)
  • connection process management ( Connection Process Manager ):
  • the Add: Support HP Vertica process deletes processing (7607)
  • database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7607)

New in Database .NET Professional 31.1.7592.1 (Oct 14, 2020)

  • Main program update ( Main ):
  • Add: (PostgreSQL 10+) Support SCRAM-SHA-256 connection verification method (7592)
  • Upd: (PostgreSQL) Support more complete connection settings (7592)
  • Add: Upgrade .NET Framework to version 4.6.1, performance Optimize and improve related functions at the same time (7592)
  • Upd: The PostgreSQL component version is updated to Npgsql.dll 4.1.5 (2020/09/28)(7592)
  • To cope with the update of this component, this version contains a lot of related changes and improvements
  • Upd:Update Database .NET Additional Files 64bit (2020/10/14)(7592)
  • Update PostgreSQL 13.0 related components
  • Upd: (ODBC/OleDB) Optimize the display problem of object list structure description (7592)
  • Upd: (ODBC/OleDB) Improve TABLE/VIEW objects load faster (7592)
  • Upd: (the HP Vertica) to enhance VIEW / SYSTABLE object field processing speed (7592)
  • Upd: other includes the cumulative minor updates, fixes and optimization (7592)
  • Main connection ( Connection Explorer ):
  • the Add : Add the Duplicate function of the server version database connection (7592)
  • Add: Add the function of deleting the server version database connection (Delete) (7592)
  • Fix: Fix the server version database connection is not updated after the rename (Rename) Displayed problem (7592)-Database
  • Tools:
  • Add: Add server version of the database and structure description filtering processing ( Filtering Databases and Schemas ) (7592)
  • Fix:Amendment Library after switching the current issue (7592) Schema Extensions are not synchronized with the refresh
  • Database Migration ( Database Migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7592)

New in Database .NET Professional 31.0.7578.1 (Sep 30, 2020)

  • Main program update ( Main ):
  • Fix: Fix (7331) VistaDB 5.0/6.0 common causes 5.0 can not get the built-in functions normally
  • Upd: Others include cumulative minor updates, corrections and optimizations)
  • Data Browser and Editor:
  • Upd: restriction annotation header length of the display, to avoid affecting the operation is too long
  • Database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NETSoftware

New in Database .NET Professional 31.0.7577.1 (Sep 29, 2020)

  • Generating script ( Generating Scripts ):
  • Fix : Fix the sorting problem of the external index key reference [multi-column] in some databases (7577)
  • Fix: (PostgreSQL) Fix the problem that the external index key reference [multi-column] cannot be obtained (7577)
  • Upd: Optimize to obtain external index key reference processing speed (7577)
  • Compare query ( comparison query ):
  • Fix: corrected float query mode (float query mode) issue (7577) can not take focus in the vertical label mode off
  • form browser ( form Viewer ):
  • Add:Increase the field name search function, more fields can be highlighted for quick browsing (7577)
  • Management Code ( Code Manager ):
  • Upd: optimized code files loaded with search speed (7577)
  • the main program update ( Main ):
  • Upd: (SQL Server) Solve the problem of unusual slowness when listing databases in a few environments (7559/7560)
  • Upd: Improve clipboard read and write exception handling capabilities (7577)
  • Upd: Optimize HiDPI high zoom display many related issues under the proportional (7577)
  • Upd: other includes the cumulative minor updates, fixes and optimization (7577) database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7577)

New in Database .NET Professional 30.9.7559.1 (Sep 11, 2020)

  • Main program update ( Main ):
  • Fix: (SQL Server) Solve the problem of abnormally slow database reading in a few environments (7559)
  • Fix: (SQL Server/SQL Azure/Sybase ASE) Fix the problem that objects after Bookmark will not be highlighted (7559) )
  • Upd: After the database or Profile [renaming/removing/deleting], the original Bookmark settings will be updated together (7559)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7559)-Filtering
  • and sorting field names ( Filtering and Sorting columns ):
  • Add: Support copy selected columns to clipboard (Copy selected columns to clipboard) (7559)-SQL
  • Editor ( SQL Editor ):
  • Upd: Object inspection ( Inspect Object ): Update shortcut keys to ( Shortcut Keys : Ctrl + B ) (7559) -AutoComplete and IntelliSense
  • ( AutoComplete and IntelliSense ):
  • Upd: Table alias automatic generation processing (AutoAliases): When processing JOIN, increase repetitive detection and improve reserved character processing (7559)-Connection
  • process management ( process Manager Connection ):
  • Upd: strengthen Oracle process deletes the processing power (7559)
  • database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7559)

New in Database .NET Professional 30.8.7541.1 (Aug 23, 2020)

  • SQL Editor ( SQL Editor ):
  • Add: Messages Tab: Add SQL statement display (7541)
  • Add: Message Tab (Messages Tab): Add SQL execution time display (7541)
  • Add: Display results in text (Results to Text): Add SQL execution time and total time display (7541)
  • Add: Plain Execution Plan ( Plain Execution Plan ): Add SQL execution time display (7541)
  • Add: Add Keeping original formatting): Easy excluded can not be formatted correctly or want to keep the original content format handling (7541)
  • generate scripts ( Generating Scripts ):
  • the Add: (SQLite 3.31+) support computing data fields ( Computed the Columns ) generation process (including editing and other related Processing) (7541)
  • Fix: (SQLite) Fix the problem of index expressions generation (7541)
  • Upd: (Firebird) Update the calculation data field to SQL standard syntax display ([type] GENERATED ALWAYS AS) (7541)
  • Upd : (PostgreSQL) Optimize Index Columns acquisition speed (7541) -Data Browser and Editor
  • (Data Browser and Editor ):
  • Upd: Improve and optimize the result of label object removal processing (7541)-Main
  • program update ( Main ) :
  • Upd: Optimize the display of different fonts under HiDPI high zoom ratio (7541)
  • Upd: (SQLite) Database tool- >Password (encryption) setting: Add integrity check to avoid database damage due to version differences (7541)
  • Add:All new object scripts are generated, and the reference URL is added (7541)
  • Upd: SQLite component version is updated to System.Data.SQLite.DLL 1.0.113.0 (3.32.1) (2020/06/01)(7541)
  • Upd: Others include cumulative minor updates, fixes and optimization (7541)
  • database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7541)

New in Database .NET Professional 30.7.7521.2 (Aug 3, 2020)

  • Fix: (MySQL) correction can not be displayed Shenkaoziliao table (includes other related functions)
  • automatically and perception ( autoComplete and IntelliSense ):
  • Upd: to enhance the external reference index key ( automatically Foreign key List the References ) processing Ability

New in Database .NET Professional 30.7.7520.1 (Aug 3, 2020)

  • Main program update ( Main ):
  • the Add: PostgreSQL support read-only mode ( the read-Only mode ) (7520)
  • currently supports include SQLite / SQLCE / Access / Excel / dBase / Text / the HP Vertica / MySQL / SQL Server / VistaDB / PostgreSQL and other databases
  • Fix: Fixed the display problem of the cursor prompt under HiDPI high zoom ratio (7520)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.0.2.0 (2020/07/07)( )(7520)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7520)-Copy
  • cell results to Clipboard (Copy cell results to Clipboard):
  • Upd: Significantly increase processing speed while reducing memory usage (7520)
  • Add: Increase waiting Cursor status and exception handling (7520) -Data Browser and Editor
  • (Data Browser and Editor ):
  • Upd: Solve the problem of opening the right-click menu due to the number of selected cells (Cells) and rows (Rows) affecting the opening speed (7520)
  • Data Browser (Data Browser ):
  • Fix : Fix the problem that caused an exception when the printed content is too long (7520)-Object
  • authorization management ( Grant Manager ) and Security Manager ( Security Manager ):
  • Fix: solve the problem the box through Space processing key, an abnormality cause problems (.NET apos bugs) (7520)
  • to generate script ( generating the scripts ):
  • Upd:(Firebird) Update VIEW object generation script processing (7520) AutoComplete and IntelliSense
  • ( AutoComplete and IntelliSense ):
  • Upd: Improve table alias automatic generation processing (AutoAliases)(7520)

New in Database .NET Professional 30.5.7488.2 (Jul 1, 2020)

  • Browse data Data Browser and Editor:
  • Fix: Fix (7484) the initial display problem caused by the status bar affected (7488)

New in Database .NET Professional 30.5.7484 (Jul 1, 2020)

  • -Data Browser and Editor (Data Browser and Editor ):
  • Add : The title of the data row column prompts to increase the base table and column display ( Getting base table name and base column name )(7484) Exclusive Features
  • : Through prompt able to understand the source of [actual] the table name and column names
  • Add: increase row Field Properties ( Column the Properties ) content is displayed (7484)
  • Upd: Status column to increase SQL execution time (SQL Execution time) display (7484 )
  • Upd: When switching between different results tabs, the status bar performs time synchronization update display (7484)-SQL
  • history ( SQL History ):
  • Add: supports the specified time or time range record (7484)
  • Add: supports the specified database type or Records of all database types (7484)-SQL
  • Editor ( SQL Editor ):
  • Upd: Avoid Undo/Redo exception processing (7484)-Plain Execution Plan
  • ( Plain Execution Plan ):
  • Add: Added content search function (Find: Ctrl + F ) (including Messages Tab) (7484)-Connection
  • Manager ( Connection Manager )
  • Upd: Preset to change depending on the date of treatment access, and correct the date format exception handling (7484)
  • connection process management ( Connection Process Manager ):
  • the Add: increase Looking function (in the field in the Find an In Grid ) (7484)
  • Main Program update ( Main ):
  • Add: Increase the detection of the existence of the table structure description (Schema) (7484)
  • Upd: Improve the case of different case when switching SCHEMA via SQL statement (7484)
  • Upd: File open exceeds Increase the prompt message at 10MB (7484)
  • Upd: Limit the display of the name of the tab page (<32) (including other related updates) (7484)
  • Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2020/06/26) (7484)
  • Support the latest version database backup and restore from PostgreSQL (32bit/64bit) 9.3/9.4/9.5/9.6/10, (64bit) 11/12 and 13.0 beta 2
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7484)
  • Database Migration ( Database Migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7484)

New in Database .NET Professional 30.4.7484.1 (Jun 28, 2020)

  • View and edit data column (Data Browser and Editor ):
  • Add : Add display of the title prompt of the data row column ( Getting base table name and base column name )(7484) Exclusive Features : Through the prompt, you can understand the source [actual] table name and field name Add : Add data column field properties ( Column properties ) content display (7484) Upd: Status bar increase SQL execution time (SQL Execution time) display (7484) Upd
  • When switching between different results tabs, the status bar performs time synchronization to update the display (7484)-SQL
  • History ( SQL History ):
  • Add: supports the specified time or time range record (7484)
  • Add: supports the specified database type or all databases type of record (7484)
  • SQL editor ( SQL editor ):
  • Upd: avoid recovery (undo) / redo (redo) generates an exception (7484)
  • text of the implementation plan ( Plain execution plan ):
  • the Add: increase in content search Function (Find: Ctrl + F ) (including Messages Tab) (7484)-Connection
  • Manager ( Connection Manager )
  • Upd: The default is to process based on the access date, and the date format is modified to handle exceptions (7484)-Connection
  • process management ( Connection Process Manager ):
  • Add : Add search function in the field ( Find In Grid ) (7484)
  • Main program update ( Main ):
  • Add: Increase the detection of the existence of the table structure description (Schema) (7484)
  • Upd: Improve the case of different case when switching SCHEMA via SQL statement (7484)
  • Upd: File Increase the prompt message when opening more than 10MB (7484)
  • Upd: limit the display of the name of the tab page (<32) (including other related updates) (7484)
  • Upd: update Database .NET Additional Files ( 32bit / 64bit ) (2020/06/ 26) (7484)
  • Support the latest version database backup and restore from PostgreSQL (32bit/64bit) 9.3/9.4/9.5/9.6/10, (64bit) 11/12 and 13.0 beta 2
  • Upd: Others include cumulative minor updates, corrections and optimization (7484)
  • database migration ( database migration ) (Pro):
  • Upd: all updates with dbMigration .NET software (7484)

New in Database .NET Professional 30.3.7445.1 (May 20, 2020)

  • 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)

New in Database .NET Professional 30.1.7400.1 (Apr 6, 2020)

  • Main program update ( Main ):
  • Add: (64bit) Add Vertical Tabs Mode (7400)
  • Make full use of the large screen, so it can accommodate more labels to display (7400)
  • Support title text search, can quickly find matching tags (7400)
  • Support mouse scrolling, no need to click to quickly browse (7400)
  • Upd: Massively optimized Dark Mode user interface display (7400)
  • Upd: reconfigure multiple menu options to provide more intuitive operation processing (7400)
  • Upd: Improve the update of quoted identifiers (Quoted identifiers) to avoid the problem of related preload statements failing after switching between different database types (7400)
  • Upd: Synchronize and update the query label menu order after sorting and moving (7400)
  • Fix: (SQL Server / SQL Azure) Fixed (7331) the problem that the SYSTEM VIEWS object field may be displayed abnormally (7400)
  • Fix: Fix the problem that the label is not switched correctly when switching the structure description under the non-object tree view (7400)
  • Fix: Fix the problem of querying the label [detection of existing] in the newly opened data table after the program restarts (7400)
  • Upd: Others include cumulative minor updates, corrections and optimization (7400)
  • SQL Editor ( SQL Editor ):
  • Add: batch command GO , / increase horizontal line (Horizontal Line) display, can clearly display the execution block (7400)
  • Add: integrate the cursor position information into the editor (7400)
  • Add: Change the font size (Font Size) to the editor (7400)
  • Add: Integrate Editor Options to Editor (7400)
  • Upd: Improved Undo / Redo problem for multi-line processing of Comment and Indent (7400)
  • Comparison query ( Comparison Query ):
  • Fix: Fix the problem that the status of the taskbar is not updated synchronously (7400)
  • Generating scripts ( Generating Scripts ):
  • Fix: (PostgreSQL) Fix the problem of generating script when DOMAIN contains CHECK (also compatible with old database version) (7400)
  • Connection profile ( Connection Profile ):
  • Add: Connection test includes pre-loaded script (SQL statement) settings (7400)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7400)

New in Database .NET Professional 30.0.7373.1 (Mar 9, 2020)

  • SQL Editor:
  • Add: Add the highlighted column [Selected] display (Highlight current line) (7373)
  • Upd: Optimize the [Background] display of the highlighted column (Highlight current line: Options-> Editor-> LineViewerStyle = FullRow) (7373)
  • Upd: Optimize the [Number] display of the highlighted column (Highlight current line: Options-> Editor-> LineNumber = True) (7373)
  • Upd: Highlighting all matching words under cursor : Keep the original text color when the background is highlighted (7373)
  • Generating Scripts:
  • Add: Support node all object types [Delete] Script All Object Types as DROP (7373)
  • Add: Support node column [Add and Query] script generation (Script Column as ALTER AND SELECT) (7373)
  • Add: Support node foreign index key [New] Script Foreign Key as ALTER (7373)
  • Add: Support node check condition constraint [New] Script Check Constraint as ALTER (7373)
  • Fix: (Firebird) Fix CRUD Stored Procedures generation processing (7373)
  • Fix: (Firebird) Fixed TRIGGERS generation script processing (backwards compatible with all database versions) (7373)
  • AutoComplete and IntelliSense :
  • Upd: Automatically select the first object in the field [ Check ] for easy insertion processing (7373)
  • Fix: Improve click. Insert processing to avoid repeated prefix characters in some cases (7373)
  • Main program update:
  • Upd: Update status bar [color and text content] multiple improvements (7373)
  • Fix: (Firebird) Exclude non-DATABASE TRIGGERS objects from being displayed (7373)
  • Fix: (Free / Plus) Solve the problem of abnormal handling of High DPI scaling under 32bit (7355)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 16.20.9.0 (2020/01/24) ( ) (7373)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7373)

New in Database .NET Professional 29.9.7349.1 (Feb 14, 2020)

  • Main program update ( Main ):
  • Add: Support DATABASE TRIGGERS object browse / delete / enable / generate processing (7349)
  • Support Firebird / SQL Server / SQL Azure / Oracle / NuoDB and other databases
  • Upd: a large number of interface updates and optimizations (7349)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.5.0.0 (2020/02/06) ( ) (7349)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7349)
  • Data Browser and Editor :
  • Upd: Results column display is faster and smoother (7349)
  • Upd: Optimize the result column column width automatic scaling display processing (7349)
  • Upd: Significantly improves the processing speed when the [Query and Result Columns] tab is closed (7349)
  • Visual Execution Plan :
  • Upd: Integrate the Plain Execution Plan into the tab page (7349)
  • Supports SQL Server / SQL Azure / PostgreSQL / Oracle / HP Vertica and other databases
  • Upd: Initially automatically selects the root node and displays the attribute content (7349)
  • Fix: Improve and fix related issues when executing multiple statements (7349)
  • AutoComplete :
  • Fix: Quoted identifiers: Automatically exclude inline functions with @@ character at the beginning (7349)
  • Upd: Improve the response speed of the object list window (7349)
  • Connection Process Manager :
  • Upd: Status column adds Last Updated time (7349)

New in Database .NET Professional 29.8.7331.1 (Jan 27, 2020)

  • Main program update ( Main ):
  • Add: (64bit) Support VistaDB 6 database
  • Upd: backward compatible with VistaDB 5 database
  • Add: Support VistaDB 5 to VistaDB 6 Database (Database Tools-> Upgrade)
  • Upd: (VistaDB / SQLCe) Improve the speed of opening encrypted database
  • Fix: (SQL Server / SQL Azure) Solve the problem that the field information cannot be obtained correctly when the table name prefix is ​​_ (second correction)
  • Upd: (Teradata) Exclude Built-in Custom Types (User-Defined Data Types) Browse Display
  • Fix: (Sybase ASE) Fix database creation processing (Database Tools-> Create)
  • Upd: Others include cumulative minor updates, corrections and optimizations
  • Generating Scripts:
  • Upd: (Oracle) Significantly improves the processing speed of Foreign Key Relationships (50% +) (affects multiple functions)
  • Fix: (PostgreSQL 12) Fixed an issue that could not generate UDDT script
  • Binding SQL variables:
  • Upd: Automatically exclude @var: = xxx and @ var = xxx configured bind variable processing
  • Upd: Change the interrupt processing (No) to cancel the setting (Cancel) and continue execution to avoid any misjudgment
  • SQL Formatting:
  • Upd: Added DROP [type] IF EXISTS [objname] formatted exception handling
  • Filtering data with the selected cells:
  • Upd: Automatically exclude if the field type of the selected cell is not supported
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Softwares

New in Database .NET Professional 29.0.7226 (Oct 14, 2019)

  • Table Designer :
  • Add: Support data line sorting (Collation Name) setting processing (7226)
  • Support for databases such as SQL Server/SQL Azure/SQLite/PostgreSQL/Firebird/MySQL/NuoDB
  • Add: Column Properties setting increment type (Identity Type: BY DEFAULT / ALWAYS) setting processing (7226)
  • Support for libraries including Firebird 4+/Oracle 12+/PostgreSQL 10+/NuoDB/IBM DB2/Teradata
  • Upd: Boolean default value Selector: Increase the data type such as logical/yesno (7226)
  • Upd: (PostgreSQL) Enhanced data type automatic conversion processing, automatic use of arithmetic processing (USING expression) when conversion fails (7226)
  • Fix: (MySQL) Correct calculation data field transaction processing (7226)
  • Object Authorization Management (64bit):
  • Add: Add item menu to add SCHEMAS object option (7226)
  • Support for databases such as SQL Server/SQL Azure/NuoDB/IBM DB2/PostgreSQL/HP Vertica
  • Fix: After fixing the new object, the title column shows that the count is not updated synchronously (7226)
  • Upd: Unified PROCEDURE and FUNCTION group name display (7226)
  • Data Import :
  • Upd: Improve processing speed when importing large text content (7226)
  • AutoComplete and IntelliSense :
  • Fix: Fixed the problem of avoiding the conversion of Quoted Identifiers to uppercase (7226)
  • Main program update ( Main ):
  • Add: Support for PostgreSQL 12.0 RTM database (7226)
  • Upd: Improved query column display efficiency when query tabs (Query Tabs) switch (7226)
  • Fix: Resolve the problem of unable to read MATERIALIZED VIEW due to changes in PostgreSQL 12 (7226)
  • Fix: (PostgreSQL) Fixed a problem where MATERIALIZED VIEW could not display UDT field type (7226)
  • Fix: (Firebird) Automatically excludes connection exceptions (Error Code:335544325) (7226)
  • Upd: Others include cumulative small updates, corrections and optimizations (7226)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7226)

New in Database .NET Professional 28.6.7184.2 (Sep 2, 2019)

  • Security Manager:
  • Add: (SQL Server) Support Library Properties [Settings] Processing
  • Main program update ( Main ):
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 28.6.7181 (Aug 30, 2019)

  • Main program update:
  • Fix the problem that the message dialog shows the content length limit
  • Others include cumulative small updates, corrections, and optimizations
  • AutoComplete and IntelliSense:
  • Fix correct text highlighting deviation problem
  • User Interface: Dark Mode :
  • Upd: Add error message/execution plan/text result/auto-complete...etc. dark mode display
  • Security Manager :
  • Add: (SQL Server) Add Library Online/Offline Settings
  • Add: (SQL Server) Add database property script generation display
  • Fix: (MariaDB) Fixed user lock and password expiration enabled state under different versions
  • Upd: (PostgreSQL) Support ENCRYPTED PASSWORD 'xxx' Encrypted content display
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 28.5.7171 (Aug 20, 2019)

  • User Interface: Dark Mode :
  • Upd: Highlighting Groups of Cells shows problems (7171)
  • Main program update ( Main ):
  • Upd: MySQL component version [return] to MySql.Data.dll 6.9.12 (2018/04/27) ( ) (7171)
  • Fix: Fixed (7156) Resolved issues not supported by older versions of MySQL 5.0.x (7171)
  • Upd: Others include cumulative small updates, corrections and optimizations (7171)
  • Misc: Compatible with Compatible with PostgreSQL 12.0 beta 3 / 11.5 / 10.10 / 9.6.15 / 9.5.19 / 9.4.24 (2019/08/08)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7171)

New in Database .NET Professional 28.4.7159 (Aug 8, 2019)

  • Data Browser and Editor :
  • Upd: Virtual Mode: Optimize the sort processing speed of the field
  • Upd: Virtual Mode: Supports filtering of related data in the field
  • Fix: Virtual Mode: Fixed problem handling for multiple SQL queries
  • Data Visualization :
  • Upd: Supports visualization of data after filtering data ( a column )
  • Main program update ( Main ):
  • Upd: Others include cumulative small updates, corrections and optimizations

New in Database .NET Professional 28.4.7156 (Aug 5, 2019)

  • 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)

New in Database .NET Professional 28.3.7139 (Jul 19, 2019)

  • - 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)

New in Database .NET Professional 28.2.7120 (Jun 30, 2019)

  • Data Export :
  • Upd: greatly improves the [all formats] export processing speed of [Query Result] while reducing the memory usage (7109/7120)
  • Main program update ( Main ):
  • Fix: (Odbc) Fixed the problem that the length of the [short name] data type could not be obtained after converting to the [long name] data type (7120)
  • Upd: (Odbc) Reference Tag Data Type: Update [short name] data type to [long name] data type display (7120)
  • Upd: Resolving issues that may cause Unsupported startup parameter: extra_float_digits when PostgreSQL is connected through a mediation program (7120)
  • Upd: EPPlus component version updated to EPPlus.DLL 4.5.3.2 (2019/06/16) (7120)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.0.4) (2019/06/27) (7120)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5GA (2019/06/27)
  • Upd: Others include cumulative small updates, corrections and optimizations (7120)
  • Misc: Compatible with Compatible with IBM DB2 11.5 GA database (7120)
  • Misc: Compatible with Compatible with PostgreSQL 12.0 beta 2 / 11.4 / 10.9 / 9.6.14 / 9.5.18 / 9.4.23 (2019/06/20)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7120)

New in Database .NET Professional 28.1.7106 (Jun 16, 2019)

  • Server Objects (64bit/ An exclusive feature ):
  • Add: Exclusive support for Sybase ASE Remote Servers (7106)
  • Add: (Oracle) Integrate SYNONYMS Object Browsing (7106)
  • Add: (PostgreSQL/Oracle/Sybase ASE) Data Table Root Node Adds Create Template and Resource Link (7106)
  • Plain Execution Plan :
  • Upd: Greatly improve the processing efficiency of digital content highlighting (7106)
  • Data Editor :
  • Fix: (Oracle/Teradata) Fixed an issue where the number/Decimal data type was Auto Increment and could not be updated synchronously (7106)
  • Fix: Fixed (7044) Unable to process Decimal data field as Null when "no primary key" was updated (7106)
  • Generating Scripts :
  • Add: (Sybase ASE) Support for Partitioned tables property generation display (7106)
  • Add: (Sybase ASE) Support Data Table Lock Type Property Display (7106)
  • Main program update ( Main ):
  • Fix: Fixed a problem that might cause an exception when switching [archive] database type under certain conditions (7106)
  • Fix: (OData) Fixed an issue where the browsing data sheet data could not be processed properly when the extended field was extended (7106)
  • Fix: (OData) Fixed an exception when browsing data sheet data was empty (7106)
  • Fix: (Oracle) Fixed Number preset and length range size (7106)
  • Fix: Corrected Quotes (Quoted identifiers) exception character processing (7106)
  • Upd: Optimize memory release processing efficiency (7106)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.111.0 (3.28.0) (2019/06/10) (7106)
  • Upd: Others include cumulative small updates, corrections and optimizations (7106)

New in Database .NET Professional 28.0.7106 (Jun 16, 2019)

  • Server Objects (64bit/ An exclusive feature ):
  • Add: Exclusive support for Sybase ASE Remote Servers (7106)
  • Add: (Oracle) Integrate SYNONYMS Object Browsing (7106)
  • Add: (PostgreSQL/Oracle/Sybase ASE) Data Table Root Node Adds Create Template and Resource Link (7106)
  • Plain Execution Plan :
  • Upd: Greatly improve the processing efficiency of digital content highlighting (7106)
  • Data Editor :
  • Fix: (Oracle/Teradata) Fixed an issue where the number/Decimal data type was Auto Increment and could not be updated synchronously (7106)
  • Fix: Fixed (7044) Unable to process Decimal data field as Null when "no primary key" was updated (7106)
  • Generating Scripts :
  • Add: (Sybase ASE) Support for Partitioned tables property generation display (7106)
  • Add: (Sybase ASE) Support Data Table Lock Type Property Display (7106)
  • Main program update ( Main ):
  • Fix: Fixed a problem that might cause an exception when switching [archive] database type under certain conditions (7106)
  • Fix: (OData) Fixed an issue where the browsing data sheet data could not be processed properly when the extended field was extended (7106)
  • Fix: (OData) Fixed an exception when browsing data sheet data was empty (7106)
  • Fix: (Oracle) Fixed Number preset and length range size (7106)
  • Fix: Corrected Quotes (Quoted identifiers) exception character processing (7106)
  • Upd: Optimize memory release processing efficiency (7106)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.111.0 (3.28.0) (2019/06/10) (7106)
  • Upd: Others include cumulative small updates, corrections and optimizations (7106)

New in Database .NET Professional 28.0.7086.1 (May 27, 2019)

  • Main program update ( Main ):
  • Add: Support for PostgreSQL 12.0 beta 1 database (7086)
  • Upd: Update oid related processing with PostgreSQL 12 (7086)
  • Upd: Improved detection of Firebird installation path, processing with exception characters (7086)
  • Fix: Fixed some problems with partial interface display (7086)
  • Upd: (Sybase ASE) Improve sp_dboption transaction processing related settings (7086)
  • Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2019/05/24) (7086)
  • Upd: Others include cumulative small updates, corrections and optimizations (7086)
  • Table Designer :
  • Add: Support PostgreSQL 12 Computed Columns definition processing (7086)
  • Add: Support editing [existing] data sheet, add calculation data field (Computed Columns) processing (7086)
  • Support for libraries including Firebird/SQL Server/SQL Azure/Sybase ASE/MySQL 5.7+/PostgreSQL 12+
  • Data Editor :
  • Add: Support PostgreSQL 12 Computed Columns Synchronous Update Display (7086)
  • Backup and Restore :
  • Add: Support for PostgreSQL 12 database backup and restore (7086)
  • Upd: (PostgreSQL/MySQL) Improved re-brushing after database restore in non-browsing mode (7086)
  • Generating Scripts :
  • Add: (PostgreSQL 12+) Supports GENERATED ALWAYS AS ( generation_expr ) STORED definition display (7086)
  • Upd: (PostgreSQL 10+) Complete Partitioned Table Indexes and Partitioned Indexes Definition Display (7086)
  • Upd: (PostgreSQL 10+) Fixed (6820) caused GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY may not display properly (7086)
  • Fix: Fixed issue where [multiple] fields were defined as GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY (7086)
  • SQL Editor ( SQL Editor ):
  • Upd: Update Shortcut Keys : Results to Grid: Ctrl + F1 , Results to Text: Ctrl + F2 , Results to File: Ctrl + F3 (7086)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7086)

New in Database .NET Professional 27.9.7079.5 (May 20, 2019)

  • Main program update ( Main ):
  • Add: (HP Vertica 8.0+) Supports CHECK Constraints Object Related Processing (7079)
  • Add: (MySQL 8.0.16+/MariaDB 10.2.22+, 10.3.10+) Support for CHECK Constraints object related processing (7079)
  • Upd: (Oracle/PostgreSQL/HP Vertica/NuoDB) Data Table Delete Increases CASCADE Delete Association Processing (7079)
  • Fix: (Teradata) Fixed an issue where some data types were not displayed in full format (7079)
  • Upd: Others include cumulative small updates, corrections and optimizations (7079)
  • Database Tools:
  • Add: (FoxPro) Support for Detach Table Processing (7079)
  • Upd: In non-browsing mode, there is no need to disconnect after the database or structure description is deleted (7079)
  • Backup and Restore :
  • Upd: (PostgreSQL) Replaces the current database description (Current Schema) with the entire database (Entire Database) backup (7079)
  • Upd: (PostgreSQL/MySQL) related parameters plus overflow character processing (7079)
  • Upd: (PostgreSQL/MySQL) message report changed to scrolling display processing (7079)
  • Generating Scripts :
  • Add: (IBM DB2) Data Type BLOB(x) Increase Length Display (7079)
  • Add: (HP Vertica) data type long varbinary(x)/long varchar(x) increase length display (7079)
  • Fix: Fixed a problem where some database generated CHECK Constraints did not specify the name of the data table (7079)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7079)

New in Database .NET Professional 27.8.7071.5 (May 13, 2019)

  • Main program update:
  • Add:(ODBC) Short Type Names automatically convert to long data type display
  • Add:(MySQL) Preset to join the Keep Alive connection settings, to avoid idle time when the remote connection is idle, resulting in automatic interrupt
  • Upd: Improved Commit/Rollback Transaction exception handling
  • Fix: Fixed data column editing advanced option [ADV]: Problem with conditional setting lost
  • Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2019/05/12)
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Misc: Compatible with Compatible with PostgreSQL 11.3 / 10.8 / 9.6.12 / 9.5.17 / 9.4.22 (2019/05/09)
  • Misc: Compatible with Compatible with MySQL 8.0.16 / MySQL 5.7.26 / MySQL 5.6.44 (2019/04)
  • SQL Editor ( SQL Editor ):
  • Add: Support copy to CSharp/Visual Basic Code (7071)
  • Add: support paste code from the code transfer function (Paste from CSharp/Visual Basic Code) (7071)
  • Add: Copy and Cut (Cut) current row and column when supporting [Not Selected] (7071)
  • Generating Scripts:
  • Fix: (Firebird) Fix ARRAY data type [LOWER:UPPER] BOUND Complete display
  • Connection Profile:
  • Fix: (SQL Server) Fix <Attach a database...> Additional Post-Processing Issues
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 27.7.7065.5 (May 6, 2019)

  • Data Import:
  • Upd: Rewrite the input file format (Delimited file format) processing (7065)
  • Supports native line feed character (CrLf) import processing, and compatibility with old newline character string (rn) import processing
  • Support for string content when multiple double quotes (") are parsed
  • Support for file files generated by third-party tools such as Mac/Unix/Dos
  • Fix: (Oracle) Resolve an issue with ORA-01704 error caused by importing more than 4000 characters (7065)
  • Fix: Fixed the problem that the statistics of the import data column was successfully counted without deducting the failure count (7065)
  • Fix: Fix preview window open *.psv file option has no effect (7065)
  • Data Export:
  • Add: Supports the native line feed character (CrLf) export processing, and retains the original newline character string (rn) for the preset (7065)
  • Add: Add Include Column Headings Export Options (7065)
  • Data Editor:
  • Upd: Improve and correct new data columns when the default value (Default Value) related problem processing (7065)
  • Main program update ( Main ):
  • Add: (SQL Server) Database Tools: Support Library Online/Offline Settings Processing (7065)
  • Upd: (Firebird) Remove unsupported data types for different database versions (7065)
  • Upd: Avoid the problem that the contents of the error message dialog box is out of the display range (7065)
  • Upd: Oracle component version [return] updated to Oracle.ManagedDataAccess.dll 12.2.1100 to resolve 10g compatibility issues (7065)
  • Upd: Others include cumulative small updates, corrections and optimizations (7065)
  • Upd: Compatible with Compatible with Microsoft Windows 10 (1903) (7065)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7065)

New in Database .NET Professional 27.6.7058.4 (Apr 29, 2019)

  • Data Editor and Browser:
  • Add: Processing of Boolean data type default value (7058) when adding new data columns
  • Upd: When the Boolean data type data is allowed to be added when the data column is added (Value IS NULL) (7058)
  • Upd: Automatically convert text presets to quotes with double quotes (") to single quotes (') (7058)
  • Fix: Filtering data with a query : Fixed an issue where other data sheets could not be edited after use (7044.2)
  • User Interface: Dark Mode :
  • Upd: Increases Dark Red and Dark Green (7058)
  • Upd: Optimize custom color display processing while improving restore sync update issues (7058)
  • Main program update ( Main ):
  • Upd: Switching database list : Synchronous re-brushing when adding [Add/Remove/Restore] database (7058)
  • Add: (PostgreSQL) Increase varbit(bit varying) data type processing (7058)
  • Upd: Optimize all database version processing (7058)
  • Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.12 (2019/04/09) (7058)
  • Upd: Others include cumulative small updates, corrections and optimizations (7058)
  • Misc: Compatible with Compatible with Informix 14.10 (2019/03/20)
  • SQL Editor ( SQL Editor ):
  • Add: Supports all tag names to be displayed in the ToolTip (7058)
  • Server Objects (64bit):
  • Add: Support for inserting text (Insert Text) processing (7058)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7058)

New in Database .NET Professional 27.5.7044.1 (Apr 15, 2019)

  • Data Editor and Browser:
  • Add: Supports the sorting process of clicking the Decimal data type field, which can exceed > 28-29 precision sorting processing ( A special feature ) (7044)
  • Fix: Solve the problem that MySQL can't handle Decimal accuracy > 28-29 (7044)
  • Upd: Displaying Data Types on the column header (7044)
  • - Main program update ( Main ):
  • Add: Optimize automatic connection processing (Auto-Reconnect): Add connection restart (ConnectionReset) detection processing (7044)
  • Add: Supports the Edge -Slip setting ( Anti-Aliasing setting ) (7044)
  • Fix: (ODBC/OleDB) Fixed an issue where the execution of the SQL statement was not excluded if the comments were included (7044)
  • Fix: Improved [automatic] Quoted identifiers processing, adding more exception character processing (7044)
  • Upd: Improved error message display processing, avoiding the same error repeated display (7044)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 18.6.0 (2019/03/18) (7044)
  • Upd: Others include cumulative small updates, corrections and optimizations (7044)
  • - Filtering and Sorting columns :
  • Add: Add a Quick Button to the field display (7044)
  • Add: Increase Sort Columns Alphabetically (7044)
  • Upd: If you want to reorganize in the data column edit mode, you can keep the settings without re-screening (7044)
  • Upd: This function is removed in the data column search mode to avoid conflicts, because the display of the field depends on the search field (7044)
  • - Grant Manager for Members (64bit):
  • Fix: (Oracle) Fix user member authorization to the database role (GRANT DATABASE ROLES) (7044)
  • - Connection Profile :
  • Upd: (Sybase ASE) Adds the ServerDefault setting (same as the server character set) to the connected character set (7044)
  • Upd: (Sybase ASE/Firebird) Allows manual entry of character set encoding (CharSet) (7044)
  • - Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7044)

New in Database .NET Professional 27.4.7033.1 (Apr 5, 2019)

  • Add: (SQL Server 2008+) Support for Linked Servers
  • Add: (PostgreSQL 9.1+) Support for External Servers ( Foreign Servers )
  • Add: (Oracle 10+) Support Database Links
  • Main program update ( Main ):
  • Add: Support home page shortcut key processing ( Shortcut Keys ):
  • Object Explorer: Ctrl+1 , Code Manager: Ctrl+2 , SQL References: Ctrl+3 , Server Objects: Ctrl+4
  • Add: (Access) Supports Pass-Through Queries Object Display
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Auto Filter Data :
  • Add: When the preset 500 totals are exceeded, the prompt will be displayed and the summary number switching selection will be provided
  • Upd: 1. Support the shortcut key after the selection, 2. Increase the display processing speed
  • AutoComplete and IntelliSense :
  • Fix: Fix the problem of displaying an exception after moving the up and down keys after displaying the member list
  • SQL Editor ( SQL Editor ):
  • Add: Support for selecting single word shortcuts ( Select Word : Ctrl + W )
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 27.3.7023.2 (Mar 25, 2019)

  • - Find in the field ( Find In Grid ):
  • Add: Support for Find Next and Find Previous button processing:
  • Add: Support shortcut key processing ( Shutcut Keys ):
  • Get Focus: Enter : Get the first position after input
  • Find Next: F3 : Find the next one, Find Previous: Shift+F3 : Find the previous one
  • Upd: Update the highlight background color to more clearly distinguish the selected background from the search highlight background
  • Upd: Clear search status by color
  • - Search Database Objects :
  • Upd: Redesigned ( Redesign ), support multiple search database type
  • Upd: Added to the Database Tools menu
  • - Data Browser :
  • Upd: Update the result list label name, replace the original database with a number
  • - Data Editor :
  • Fix: Fix and update replaces the function in the field ( Replace In Grid )
  • Fix: Fix and update status column message display and related issues
  • Fix: Fixed issue of conditional filtering (or re-brushing) control release
  • - Main program update ( Main ):
  • Upd: Detail Optimized User Interface
  • Upd: (SQLite) Modify the way to open the network disk database connection (only for new)
  • Upd: Others include cumulative small updates, corrections and optimizations

New in Database .NET Professional 27.2.7016.1 (Mar 18, 2019)

  • Find in the field ( Find In Grid ):
  • Greatly rewritten, directly highlighted after inputting the search, the query speed is several times faster than the original processing (7016)
  • Integration into the query result list / edit result list / search data table result list / SQL performance analyzer / SQL file version control management / SQL history record ... and other functions (7016)
  • Main program update ( Main ):
  • Add: Support search word [bottom line hint] display, including [object and connection] node search (7016)
  • Add: Add Show or Hide Results Panel Shortcut Keys : (Show or hide the results pane: F10 )(7016)
  • Upd: Detailed optimization of user interface (User Interface) controls and text font display (7016)
  • Upd: Update Security Protocol ( Tls11/Tls12 /Tls/Ssl3) (7016)
  • Upd: (Firebird) Improved INSERT (...) RETURNING (...) Unable to get back the value (7016)
  • Upd: (Firebird) Improve user login account case sensitivity (7016)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.110.0 (3.27.2) (2019/03/04) (7016)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.4041.4) (2019/03/06) (7016)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.4 Fix Pack 4a (2019/03/06)
  • Upd: Others include cumulative small updates, corrections and optimizations (7016)
  • Connection Explorer :
  • Add: Add Clear Button and Shortcut Key: Esc (7016)
  • Fix: Resolve an issue where the database or path contains exception characters (including: Connection Profile and Connection Manager ) (7016)
  • Quick Filtering Objects :
  • Add: Add Shortcut Key: Esc (7016)
  • Database Diagram :
  • Add: Add data table association syntax prompt message display (7016)
  • AutoComplete and IntelliSense :
  • Upd: Improve new and optimized member list response speed (7016)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7016)

New in Database .NET Professional 27.1.7002 (Mar 4, 2019)

  • Main program update ( Main ):
  • Upd: greatly optimize the user interface (User Interface) control and text font display (7002)
  • Add: Query Tab Menu Adding Query Tabs (7002)
  • Add: Query tab page menu to add R Close tabs to the right (7002)
  • Upd: Others include cumulative small updates, corrections and optimizations (7002)
  • SQL Editor ( SQL Editor ):
  • Add: Supports cursor text uppercase (Uppercase: Ctrl + U ) and lowercase (Lowercase: Ctrl + L ) conversion processing, no need to select (7002)
  • Add: Right-click menu search (Find) to increase the uppercase and lowercase sub-options ( U Uppercase and L Lowercase) (7002)
  • Add: Right click on the menu to add the restore and redo suboptions ( U Undo and R Redo) (7002)
  • Data Editor and Browser :
  • Fix: Resolve an issue that is abnormally slow if you cannot read data from a database type such as System.Decimal or System.DateTime (7002)
  • Object Navigator :
  • Fix: Click the middle mouse button to browse and solve the problem that cannot be executed when the focus is not fixed (7002)
  • Generating Scripts :
  • Upd: Optimize and improve multiple database objects to create new sample generation content (7002)
  • Cell Viewer :
  • Upd: Browse BLOB content: 1. Add AUTO to automatically select the format, 2. Maintain the selected format display when switching (7002)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (7002)

New in Database .NET Professional 27.0.6995 (Feb 25, 2019)

  • Main program update ( Main ):
  • Add: Support for locking query tags ( Locking Query Tabs ) (6995)
  • Add: Changing the schema of query tabs (6995)
  • Upd: Last query tabs keeps records from original 100 to 200 (6995)
  • Upd: Others include cumulative small updates, corrections and optimizations (6995)
  • Grant Manager for Objects (64bit):
  • Add: Increase the script generation display (Generating Scripts) (6995)
  • Add: (IBM DB2) Increase SEQUENCES permission settings (6995)
  • Add: (HP Vertica) Increase FUNCTIONS permission settings (6995)
  • Add: (Firebird) Increase FUNCTIONS/SEQUENCES permission settings (6995)
  • Upd: (Firebird) Excludes unwanted objects, greatly increasing the speed of member objects (6995)
  • Fix: Fixed an issue where some databases could not handle VIEWS permission settings (6995)
  • Fix: Fixed a problem with the permission setting when some databases PROCEDURES/FUNCTIONS did not contain parameters (6995)
  • Upd: Modify the authorization method to change the processing directly, replace the change and then save the processing (6995)
  • Upd: Change to exclusive display processing, avoiding the loss of function due to switching between different databases (Databases) or Schemas (6995)
  • Grant Manager for Members (64bit):
  • Fix: Fix and update script generation (Generating scripts) (6995)
  • Fix: (Informix) Fix user member authorization to the database role (GRANT DATABASE ROLES) (6995)
  • Data Export :
  • Fix: (Sybase ASE) Export SQL format: Fixed issue with date data type quote characters (6995)
  • Query Builder ( Query Builder )
  • Fix: Table Alias ​​keyword AS is replaced by a space to be compatible with different database systems (6995)

New in Database .NET Professional 26.9.6988 (Feb 18, 2019)

  • New Security Manager with Grant Manager for Members (6988)
  • Support for database role authorized user members ( GRANT USERS : IBM DB2/Informix/Oracle/SQL Server/SQL Azure/Firebird/Teradata/HP Vertica/NuoDB/MySQL/MariDB/PostgreSQL)
  • Support for user member authorization to the database role ( GRANT DATABASE ROLES : IBM DB2/Informix/Oracle/SQL Server/SQL Azure/Firebird/Teradata/HP Vertica/NuoDB/MariDB/PostgreSQL)
  • Support server role authorization login member ( GRANT LOGINS : SQL Server / Sybase ASE)
  • Support login member authorization to server role ( GRANT SERVER ROLES : SQL Server / Sybase ASE)
  • Grant Manager for Objects (64bit):
  • Add: Work column increases the button function that can be switched from [Specified Object] to [All Objects] (6988)
  • Add: (NuoDB) Join WITH GRANT OPTION Authorization check setting (6988)
  • Fix: (NuoDB) Fix and update User and Roles display mode and authorization processing (6988)
  • Security Manager :
  • Upd: (PostgreSQL) Detailed User and Roles Processing and Display (6988)
  • Fix: (NuoDB) Fix and update User and Roles display mode (6988)
  • Add: Support for Generating GRANT ROLE scripts (6988)
  • Add: Support for SQL Syntax Highlighting display processing (6988)
  • Upd: Also contains a lot of optimization updates and fixes (6988)
  • Auto Filter Data :
  • Add: Shortcut Key: Help F1 , Clear F4 , Execute F5 (6988)
  • Fix: Fixed an issue where IS NULL/IS NOT NULL could not be processed normally (6988)
  • SQL Editor ( SQL Editor ):
  • Fix: Fix and Improve Increase Indent and Reduce Indent Processing (6988)
  • Fix: Fixed a problem when indenting processing when ConvertTabsToSpaces=True (6988)
  • AutoComplete and IntelliSense :
  • Fix: Fixed 32bit under the list of inexplicable checkboxes (6988)
  • Main program update ( Main ):
  • Upd: Others include cumulative small updates, corrections and optimizations (6988)
  • Misc: Compatible with Compatible with PostgreSQL 11.2 / 10.7 / 9.6.11 / 9.5.16 / 9.4.21 (2019/02/14)

New in Database .NET Professional 26.8.6981 (Feb 11, 2019)

  • Add: New database object (DATABASE OBJECTS) management: Support browsing / adding / deleting processing (6981)
  • Support includes: MySQL/SQL Server/Sybase ASE and other databases
  • Add: Supports object permissions management such as SQL Server (Server Roles/Database Roles/Application Roles/Users) (6981)
  • Add: Supports object permission management such as Sybase ASE (Server Roles/Users) (6981)
  • Add: Increase database switching processing, convenient for different databases (SQL Server) AppRoles/DbRoles/Users, (Sybase ASE) Users and other object management (6981)
  • Add: Support Sybase ASE login (Logins) password change processing (6981)
  • Add: Support IBM DB2 structure description (Schemas) [non-empty time] delete processing (6981)
  • Add: Object property management includes both object attribute content display (6981)
  • SQL Editor ( SQL Editor ):
  • Add: support to open the association. SQL file processing, if the program is associated with the .SQL format, when double-clicked it will be able to open under [same program] (do not open more programs) (6981)
  • Add: Support for opening .SQL files (6981) without any query page (blank)
  • Upd: Drop the .SQL file to the editor to directly edit the file mode instead of the content loading process (6981)
  • AutoComplete and IntelliSense :
  • Fix: Avoid automatic processing in Completion Mode when [Field] is automatically perceived (6981)
  • Upd: Displayed when the right-click menu is enabled (Mode: C/S/None, IntelliSense: On/Off) (6981)
  • Table Designer :
  • Upd: (Sybase ASE) improved data table alter table processing power (6981)
  • Secure Shell Agreement ( SSH: Secure Shell ):
  • Fix: (Teradata) Fixed an issue that was not enabled (SSH) after setting (6981)
  • Code Manager :
  • Fix: Fix some database double-click to open the .SQL file and the label icon update problem (6981)
  • Plain Execution Plan :
  • Upd: (Access) Improves processing speed when SQL syntax errors are raised while avoiding unnecessary external processing (6981)
  • Main program update ( Main ):
  • Fix: Fixed a problem with reconnecting [different types] database after the current database connection failed (6981)
  • Fix: (Sybase ASE) Fixed a problem with the 'master' database's options cannot be changed when some of the libraries were on the master (6981)
  • Upd: (Teradata) Modifying the way Reserved Words is obtained, reducing the need for permissions (6981)
  • Upd: Others include cumulative small updates, corrections and optimizations (6981)

New in Database .NET Professional 26.7.6967 (Jan 28, 2019)

  • 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)

New in Database .NET Professional 26.6.6959 (Jan 21, 2019)

  • 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: Others include cumulative small updates, corrections and optimizations (6960)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6960)

New in Database .NET Professional 26.4.6946 (Jan 7, 2019)

  • - 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)

New in Database .NET Professional 26.4.6940 (Jan 1, 2019)

  • - Main program update ( Main ):
  • Add: (64bit) Added floating query mode ( Float Query Mode* ) (6940)
  • In addition to the split query mode ( Distributed Query Mode* ), the exclusive way to provide another intuitive and convenient query content and data browsing content, the independent window can be more scalable
  • Upd: (64bit) Split Query Mode* : Improvements in editor text search and replacement dialog position and related issues (6940)
  • Add: Add Comment Tips to display (6940)
  • Column Comments: Included in the Data Editor , Object Navigator , Search Table Data , etc.
  • Table Comments: Included in the Object Navigator function
  • Upd: Optimize the main menu and the main work column click processing, you can directly click on the post-processing without having to get the focus (6940)
  • Upd: SQLite (SQLCipher AES256) component version update from 3.8.10 to 3.20.1 (6940)
  • Upd: Others include cumulative small updates, corrections and optimizations (6940)
  • - Quick Filtering Objects
  • Upd: (SQL Server/SQL Azure/Sybase ASE) Support for search processing including schema.objname, objname (schema), etc. (6940)
  • Upd: Improved input synchronization processing problem (6940)
  • Fix: Fixed an issue where SYNONYMS objects were not included in the quick screening process (6940)
  • - Generating Scripts :
  • Add: (HP Vertica) Support for Partitioned tables property generation display (6940)
  • - Table Designer :
  • Fix: (IBM DB2/Teradata) Fixed a problem with Column Comments getting lost (including generating scripts) (6940)
  • - Data Editor :
  • Fix: (Teradata) automatically distinguishes DATE and TIMESTAMP (WITHZONE) date format content, solves problems that cannot be added and updated (including SQL INSERTs output) (6940)
  • - Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6940)

New in Database .NET Professional 26.3.6920.1 (Dec 12, 2018)

  • Add: (64bit) New Split Query Mode* (6908/6920)
  • Exclusively provide more intuitive and convenient comparison of query content and data browsing content, greatly eliminating the trouble and inconvenience of switching tabs
  • Add: Split Ctrl key to synchronize horizontal and vertical scrolling (6920)
  • Fix: Fixed (6778) problem that prevented the table and view objects list from being opened (6908)
  • Fix: Fixed an issue that caused an exception when the object was initially loaded as the [First] repository in the All databases mode (6905)
  • Add: (MariaDB 10.3.5+) Support PACKAGES object browsing, new and delete processing (6905)
  • Fix: (Firebird 3.0+) Fix CREATE PACKAGE New Sample Sample (6905)
  • Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.11 (2018/12/04) (6920)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.4040.4) (2018/11/21) (6908)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.4 Fix Pack 4 (2018/11/21)
  • Upd: Others include cumulative small updates, corrections and optimizations (6920)
  • Vertical browsing mode :
  • Add: Supports Ctrl key to synchronize vertical scrolling (6920)
  • Script Generator :
  • Add: Add more export formats: In addition to the original SQL/CSV, add a new export format such as TSV/PSV/SSV/XLSX/XLS/XML/JSON/HTML/MD (6920)
  • Security Manager :
  • Upd: (MySQL) Update user syntax generation issues to be compatible with MariaDB and MySQL (6905)
  • Fix: (MySQL) Change user password down compatible with 5.7 or later (6905)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6920)

New in Database .NET Professional 26.2.6905.2 (Nov 27, 2018)

  • Main program update ( Main ):
  • Fix: Fixed an issue that caused an exception when the object was initially loaded as the [First] repository in the All databases mode (6905)
  • Add: (MariaDB 10.3.5+) Support PACKAGES object browsing, new and delete processing (6905)
  • Fix: (Firebird) Fix CREATE PACKAGE New Sample Sample (6905)
  • Upd: Others include cumulative small updates, corrections and optimizations (6905)
  • Security Manager :
  • Upd: (MySQL) Update user syntax generation issues to be compatible with MariaDB and MySQL (6905)
  • Fix: (MySQL) Change user password down compatible with 5.7 or later (6905)

New in Database .NET Professional 26.2.6901.1 (Nov 23, 2018)

  • Upd: Accumulated more than 100 updates, correction and optimization processing (6901)
  • Misc: Compatible with Compatible with PostgreSQL 11.1 / 10.6 / 9.6.11 / 9.5.15 / 9.4.20 / 9.3.25 (2018/11/08)
  • Table Designer :
  • Add: Support data sheet column movement ( Column moving* ) processing (6901)
  • In addition to the original supported database, all new databases such as Access/dBASE/FoxPro/Firebird/ODBC/OleDB are supported.
  • Duplicating Tables :
  • Add: Support for copying data table indexes (Indexes) and checking condition constraints (CHECK Constraints) (6901)
  • Upd: Support automatic update (AUTOINCREMENT) field value after copying (6901)
  • Fix: Fixed (SQL Server) unable to copy the problem with the IDENTITY field data table (6901)
  • Data Editor :
  • Add: (Firebird 2.5+) Update and delete data column processing when UUID is supported as primary key (PK) (6901)
  • Upd: Synchronous update display when TRIGGER is supported as Default Value (6901)
  • AutoComplete and IntelliSense :
  • Upd: Improved single-line annotation ( -- ) in the automatic perceptual processing of data sheets (6901)
  • SQL Editor ( SQL Editor ):
  • Fix: Fixed an issue where the Increase Indent could not be processed on [Selected Fragments] when the format property ConvertTabsToSpaces=True (6901)
  • Security Manager :
  • Upd: (Firebird 4+) Supports unchecking the role system permission setting processing (6901)
  • Fix: (Firebird 4+) Fixed a problem with partial file system permission settings being displayed incorrectly (6901)

New in Database .NET Professional 26.1.6880.1 (Nov 2, 2018)

  • AutoComplete and IntelliSense:
  • Add: Support for database names and schema names Auto Perception
  • Upd: Resolves user-defined high DPI settings settings, causing display anomalies
  • Upd: Optimize and improve automatic sensing processing speed
  • Fix: (SQL Server/SybaseASE) Fixed an issue where the [initial selected database] auto-sensing function in All databases mode has no effect
  • Add: (SQL Server/SybaseASE) supports schema.{table} auto-aware
  • Upd: (SQL Server/SybaseASE) Optimize db.schema.{table}, db.{schema.table} Auto Perception
  • Object Navigator:
  • Add: (FoxPro) supports Foreign Keys object display and delete processing
  • Fix: (NuoDB 2.5+) with the latest version of the Foreign Keys object display and delete processing (including data sheet design)
  • Fix: (Teradata) Fixed Foreign Keys object display and deletion processing (including data sheet design)
  • Main program update ( Main ):
  • Upd: Improved query tab icon and status column database type update processing
  • Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.10 (2018/10/30)
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Misc: Compatible with SQL Server 2014 SP3 / SQL Server 2014 SP3 Express and LocalDB (2018/10/30)
  • Horizontal browsing mode:
  • Add: Supports Ctrl key to synchronize scrolling
  • Cell Editor / Cell Viewer:
  • Add: Support HTML Browsing Mode web browsing mode
  • SQL Performance Analyzer ( SQL Profiler ):
  • Add: Global Mode supports Firebird 3.0/4.0 Embedded inline version
  • Plain Execution Plan:
  • Upd: Optimize content display, distinguish between text and digital colors to make content reading more intuitive
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 26.0.6869 (Oct 22, 2018)

  • Main program update ( Main ):
  • Upd: Support for PostgreSQL 11 RTM database system (2018/10/18) (6869)
  • Add: (PostgreSQL 11) Supports Store Procedures Pre-stored program objects, including: Browse/Delete/Generate/Execute...etc. (6869)
  • Fix: (PostgreSQL) Fixed (6862) Numeric data type (6869) that could not be processed [without specified length]
  • Upd: (PostgreSQL) Support Numeric [no specified length] generation and display (including script generation) (6869)
  • Upd: Optimize interface display problem and graphic display processing speed (6869)
  • Upd: VistaDB component version updated to VistaDB.5.NET40.dll 5.7.4 (2018/10/14) (6869)
  • Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2018/10/19) (6869)
  • Upd: Others include cumulative small updates, corrections and optimizations (6869)
  • Connection Profile :
  • Add: Support Secure Shell Protocol ( SSH: Secure Shell ) connection method (6869)
  • Supports databases such as PostgreSQL/IBM DB2/Informix/NuoDB/Vertica/SQL Server/Sybase ASE/MySQL/Oracle/Teradata
  • Add: (Firebird) [New Library] Add PageSize Setting Item (6869)
  • Upd: (Firebird) Simplified connection setting display and update enable status (6869)
  • Upd: (Firebird) Client Library path is saved in Relative path, which is convenient for portable version mobile processing (6869)
  • SQL Editor ( SQL Editor ):
  • Add: Query Tab Adds Query Tab Icons : You can view the properties of the tab directly through the icon without switching (6869)
  • Code Manager :
  • Upd: Code Path path is saved in Relative path, which is convenient for portable version mobile processing (6869)
  • Fix: Fixed an issue where the original code path was not updated after switching from the default path to the portable mode ()
  • Data Import :
  • Upd: Improved error column number and source information message when the import process is wrong (6869)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6869)

New in Database .NET Professional 25.9.6862 (Oct 15, 2018)

  • Main program update ( Main ):
  • Add: Add Execute query to text: Ctrl + T : Steps to save processing after switching
  • Upd: (Oracle) supports complete field type display and related processing such as
  • Number(*,x), Number(x,-x):
  • Upd: (Oracle) Improved alternative handling when SEQUENCES cannot be generated
  • Upd: (NuoDB) supports Number Scale x field type display and related processing
  • Fix: (NuoDB) Fix and update field data type generation method
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Misc: Compatible with Compatible with NuoDB 3.3
  • Connection Profile :
  • Add: (Firebird) Add Character Sets List to simplify setup issues
  • Upd: (Firebird) [New Library] The default encoding is changed to UTF8 and allowed to be modified in the property page
  • Fix: (Firebird) [Embedded] Fixed an error that the test did not continue if it was processed directly
  • SQL Editor ( SQL Editor ):
  • Upd: Replace the [Selected] node object name with the [Source] to edit content
  • SQL Performance Analyzer ( SQL Profiler ):
  • Fix: Fixed an issue where the SQLite pause (with exit) feature has no effect
  • Data Editor :
  • Fix: Filter Expression : Fix exception handling under the database that supports RowID
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 25.8.6853 (Oct 8, 2018)

  • Main program update ( Main ):
  • Add: New Switch to another database : Steps to save the interrupt and then reconnect
  • Supports SQLite/SQLCe/Firebird/Access/Excel/Text/dBASE/FoxPro/OleDB/ODBC/OData/SQL Azure and other databases
  • Upd: Improve user experience: Interrupt connection button right click menu to increase reconnection function
  • Upd: Improve user experience: Cancel mouse click on object name change processing (Note: Shortcut key F2 and menu processing are still available)
  • Upd: Improve user experience: Group node is changed to click to close
  • Upd: Improve the user experience: Icon (Icon) level can show whether the node object has been loaded
  • Upd: Improved user experience: Optimized processing of the user interface (UI)
  • Fix: Improve compatibility issues: Avoid accidental startups in the latest operating environment
  • Upd: Compatible with Compatible with Microsoft Windows 10 (1809)
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Visual Execution Plan :
  • Upd: (MySQL 5.6+) supports both visual and textual execution plan display
  • Upd: (MariaDB) Change to textual execution plan display processing
  • Fix: Fixed an issue where the split window control on the right didn't work
  • Connection Profile :
  • Add: New Schemas auto-execution: Supports databases such as IBM DB2/Informix/PostgreSQL/HP Vertica/NuoDB
  • Add: Automatic database (Databases) auto-execution: Supports Informix/HP Vertica and other databases
  • Upd: When the manual connection setting processing is performed, the Select last object when connected processing (6853) will be skipped.
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 25.6.6837.3 (Sep 20, 2018)

  • Command line processing ( Command-line ):
  • Fix: Fixed a problem where the command line specified the database type of the last selected database type in the non-wired list will cause invalidation
  • Fix: Improved [Servo Library Direct Connection Processing] Temporary setting deletion problem when disconnected
  • Main program update ( Main ):
  • Upd: (Firebird) Improvement (6806) When the same instance is not enabled to open the message using different fbembed.dll/fbclient.dll components
  • Upd: Resolving the DataGridView control When the field name contains comma(,) characters, clicking on the field sorting will cause an exception
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Generating Scripts :
  • Upd: (PostgreSQL 10+) The main data table is generated with sub-partitioned tables .
  • SQL Editor ( SQL Editor ):
  • Add: Messages Tab Right-click menu to add Save As and Clear
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 25.6.6827 (Sep 10, 2018)

  • Main program update ( Main ):
  • Add: (Access) supports user-level security database processing ( Microsoft Access User-Level Security ) ( ) (6827)
  • Fix: (Access) Resolved an issue where [First] could not open a database file with a password in a [specific] job environment (6827)
  • Upd: (MySQL) Forces the connection property setting (Old Guids=True) and removes it from the settings, avoiding browsing, editing, and import and export failures (6827)
  • Fix: (SQLCe 3.1/3.5) Fix database upgrade function ()
  • Upd: Resolved an issue that caused the program to fail to open when the system environment setting FipsAlgorithmPolicy=Enabled is enabled (6827)
  • Upd: Improve text display: Includes Database Diagram , Visual Execution Plan (6827)
  • Upd: Others include cumulative small updates, corrections and optimizations (6827)
  • Visual Execution Plan :
  • Add: (SQLite) supports both SQLite visualization and textual execution plan display (6827)
  • Fix: (Oracle) Fix (68??) causes the [visualization] execution plan to be invalid (6827)
  • Plain Execution Plan :
  • Upd: (SQLite) Optimized output display: Display textized execution plan content in a hierarchical manner (6827)
  • Fix: (Oracle) Fix (68??) causes the [textualization] execution plan to be ineffective (6827)
  • Form Editor and Viewer :
  • Add: Form Edit Join: DateTime Picker , GUID Generator (6827)
  • Upd: Exclude hidden field display to avoid causing related problems (6827)
  • Connection Profile :
  • Fix: Fixed connection timeout setting (ConnectionTimout) can not change the saved problem (6827)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6827)

New in Database .NET Professional 25.5.6820.1 (Sep 3, 2018)

  • Main program update ( Main ):
  • Add: Support for the Oracle 18c database system (6820)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 18.3.0 (2018/08/27) (6820)
  • Fix: (NuoDB 3.x) Resolve the issue that the enable state preset for INDEXES under the latest version may be NULL (6820)
  • Fix: (NuoDB 3.x) Resolve the problem that the DOMAIN data type cannot be displayed properly in the latest version (6820)
  • Upd: Others include cumulative small updates, corrections and optimizations (6820)
  • Generating Scripts :
  • Add: (PostgreSQL 9.2+) Support for Collation Name property generation display (6820)
  • Fix: (PostgreSQL 9.1+) Fixed <10.0 or lower version of Foreign tables syntax generation issue (6820)
  • Upd: (SQL Server 2016+) Update Temporal Tables data table related attribute generation display (6820)
  • Fix: (SQL Server 2000) Fixed an issue that CHECK constraints could not generate (6820)
  • Add: (NuoDB) supports Partitioned tables property generation display (6820)
  • Upd: (NuoDB) Update DOMAIN object generation processing, length display of non-numeric types (6820)
  • Search Table Data :
  • Add: Supports regular expression search processing, (Note: Fixed (6726) unopened question) (6820)
  • Support includes MySQL/Oracle/DB2/Informix/PostgreSQL/Firebird/SQLite/Vertica/SQL Server/SQL Azure
  • Connection Profile :
  • Upd: (Sybase ASE) Increase the character set list drop-down option (Character Sets List) to simplify setup issues (6820)
  • Upd: (Firebird) Removes the Global Connection Profile , individual connections are included and therefore no longer needed (6820)
  • Security Manager :
  • Upd: (SQL Server 2000) Select the login account (LOGINS) to change the attribute display to replace the permission modification (6820)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6820)

New in Database .NET Professional 25.4.6806.1 (Aug 20, 2018)

  • Main program update:
  • Add: Support for PostgreSQL 11 beta database system
  • Support for the latest PostgreSQL 11.x Backup and Restore Database backup and restore processing
  • Need to work with the latest Database .NET Additional Files
  • Add: Supports the middle mouse button to quickly open the Databases and Tables/Views (Shortcut Key
  • Upd: (Sybase ASE) Modify the default text size processing (Default Text Size: 32KB->2GB)
  • Fix: (FoxPro) Fixed (6792) Preset quote string change, causing the problem that the field could not be displayed properly ()
  • Upd: Allows Firebird Embedded to open a database with different fbembed.dll/fbclient.dll components in the same instance
  • Upd: Avoid external factors that cause the program to load slowly when the program starts, resulting in an exception
  • Upd: Others include cumulative small updates, corrections and optimizations
  • Data Editor :
  • Add: (Firebird/FoxPro) Ability to update with ROWID without primary key (NoPKs)
  • Fix: (Oracle/SQLite/Informix/PostgreSQL) Fixed an issue where ROWID update processing was disabled when there was no primary key (NoPKs)
  • Upd: Default Value synchronization update display when no-keys (NoPKs) are improved
  • Plain Execution Plan:
  • Add: (Access) Support for processing display in Windows XP environment
  • Fix: (Sybase ASE) Fix (37??) causes the original function to be disabled and cannot be displayed
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 25.3.6792 (Aug 6, 2018)

  • Table Designer:
  • Add: (Access/NuoDB) support check condition constraint ( CHECK constraints ) add and delete processing (6792)
  • Upd: (SQLite) Cannot add a non-constant default when the new fields are built in. Can not add a column with non-constant default (6792)
  • Main program update ( Main ):
  • Upd: (NuoDB 3.1/3.2+) With the latest version of Data Type update processing, solve the problem that the data type cannot be displayed normally (6792)
  • Upd: (Access/Excel/Text/dBASE/FoxPro) Preset quote string ``replace with [] instead (6792)
  • Upd: Others include cumulative small updates, corrections and optimizations (6792)
  • Misc: Compatible with NuoDB 3.1 / 3.2
  • Misc: Compatible with Compatible with MySQL 8.0.12 / MySQL 5.7.23 / MySQL 5.6.41 / MySQL 5.5.61 (2018/07)
  • Generating Scripts:
  • Add: (Access) supports CHECK constraints definition generation and deletion processing (6792)
  • Fix: (VistaDB) Fixed issue where CHECK constraints did not contain quoted string () (6792)
  • Fix: (Teradata) Fix CHECK constraints [Do not include name] (6792)
  • Fix: (Informix) Fixed CHECK constraints [with multiple lines] (6792)
  • Fix: (Firebird) Fixed issue with CHECK constraints multi-field condition processing (6792)
  • Fix: (Firebird) Fixed an issue where the default keyword in the field was defined as [lowercase] and could not be parsed properly (6792)
  • Connection List:
  • Add: Supports Dragging multiple selections (6792)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6792)

New in Database .NET Professional 25.2.6785.1 (Jul 30, 2018)

  • Main program update ( Main ):
  • Add: My Favorites : Add support for Databases and Schemas object processing (6785)
  • Add: (PostgreSQL 9.1+) Supports the processing of Foreign tables data table (6785)
  • Add: (PostgreSQL 10+) Supports Partitioned tables data table related processing (6785)
  • Upd: Others include cumulative small updates, corrections and optimizations (6785)
  • Misc: Compatible with Compatible with MySQL 8.0.12 / MySQL 5.7.23 / MySQL 5.6.41 / MySQL 5.5.61 (2018/07)
  • Connection List :
  • Add: Support my favorite connection list ( My Favorite Connections ) (6785)
  • Data Editor :
  • Fix: Correct the System.Object data type handling method when there is no primary key (6785)
  • Cell Editor / Cell Viewer :
  • Upd: When the field data type is System.Byte[], the text can be saved and saved by default (6785)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6785)

New in Database .NET Professional 25.2.6778.1 (Jul 24, 2018)

  • Main program update ( Main ):
  • Add: Support multiple selections (Multi selections ) (6778)
  • Object Navigator : Support for deleting/opening/editing/editing/Scripting multiple selections (Deleting/Opening/Editing/Scripting multiple selections)
  • Connection List : Support for deleting and removing multiple selections (Deleting/Removing multiple selections)
  • Code Manager : Support for deleting and opening multiple selections (Deleting/Opening multiple selections)
  • Insert Text: Supports dragging/copying multiple selections
  • Add: (Firebird) Support CryptKey by using Base64 string connection property setting (req Encryption plugin ) (6778)
  • Add: (Firebird) Add Embedded version display (6778)
  • Fix: (Firebird) Fix (6726) causes the status update issue when Remote and Embedded are selected (6778)
  • Fix: (64bit) Solve the problem that the user interface color picker (Color Picker) function can not work under the latest Win10 (6758)
  • Upd: Others include cumulative small updates, corrections and optimizations (6778)
  • Code Snippets :
  • Add: New Filtering Code Snippets (6778)
  • Fix: Fixed an issue where the original code fragment was not reloaded after updating the management content (6778)
  • SQL Editor ( SQL Editor ):
  • Add: Right-click menu auto-complete project ( AutoComplete ): Add switch auto-complete mode sub-option [N/S/C] (6778)
  • Fix: Fix Close All Tabs, when the [Last Label is Edit Mode] is turned off, it will cause an exception (6778)
  • Data Export :
  • Add: Copy the Selected Selected Items to Clipboard : Supports formats such as Markdown/JSON/HTML (6778)
  • Upd: Optimize [all] export format processing (6778)
  • Data Import :
  • Upd: Preview Mode no longer displays dialog prompts to support pre-correlated change processing (6758)
  • Upd: Add file format detection to avoid opening unsupported import format files (6758)
  • SQL Formatting ( SQL Formatting ):
  • Add: Support editor properties ConvertTabsToSpaces and TabIndent settings to format processing (6758)
  • Table Designer :
  • Fix: Resolve the problem of resetting if the data table contains an incremental field (AUTOINC) after changing the name of the field (6758)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6778)

New in Database .NET Professional 25.1.6758.2 (Jul 3, 2018)

  • Fix: (64bit) Solve the problem that the user interface color picker (Color Picker) function can not work under the latest Win10 (6758)
  • Upd: Others include cumulative small updates, corrections and optimizations (6758)
  • Data Import :
  • Upd: Preview Mode no longer displays dialog prompts to support pre-correlated change processing (6758)
  • Upd: Add file format detection to avoid opening unsupported import format files (6758)
  • SQL Formatting ( SQL Formatting ):
  • Add: Support editor properties ConvertTabsToSpaces and TabIndent settings to format processing (6758)
  • Table Designer :
  • Fix: Resolve the problem of resetting if the data table contains an incremental field (AUTOINC) after changing the name of the field (6758)

New in Database .NET Professional 25.1.6746 (Jun 21, 2018)

  • Upd: All updates with dbMigration .NET Software (6746)

New in Database .NET Professional 25.1.6743.1 (Jun 18, 2018)

  • Main program update ( Main ):
  • Add: Title Column Add Total Configuration Managed Memory (CPU usage) Usage Status Display (6733/6743)
  • Upd: (IBM DB2/SQL Server/SQL Azure) Updated Complete Built-in Functions (Including Auto-Complete Display Processing) (6743)
  • Add: (Firebird) Support to reopen Shutdown database files (6743)
  • Fix: (ODBC/OleDB) Avoid nullchar when returning Quoted Identifiers characters (6743)
  • Add: Table Properties: Increase Table Dependencies (6733)
  • Databases such as SQL Server/SQL Azure/Firebird/Oracle/IBM DB2/Informix/Sybase ASE
  • Upd: After the Splash Form opens and ends, return to the issue of the owning window (6733)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6743)
  • Results to Text :
  • Upd: Improved Maximum Single-field Width Increase to 2048 Characters (6743)
  • Upd: Optimized output content display format (6743)
  • Transaction Mode :
  • Add: Joins the Plain Execution Plan and Visual Execution Plan (6743)
  • Add: Join Support DBMS_OUTPUT (Oracle/IBM DB2) output message display (6743)
  • Data Editor :
  • Upd: Distinguish between NULL value and 'NULL' string processing, including editing/browsing/exporting (6743)
  • Upd: Filter Expression : Allows re-entry when error is returned (6743)
  • AutoComplete and IntelliSense :
  • Upd: Optimizing and Improving Display Problems (6743)
  • Fix: Fix the problem that the screen may not display properly under occasional situations (6733)
  • Generating Scripts :
  • Fix: (PostgreSQL) Fixed issue where SCHEMA was not specified when generating object annotations (COMMENT) (6733)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6733)

New in Database .NET Professional 25.0.6733.1 (Jun 8, 2018)

  • Main program update ( Main):
  • Add: Title Column Add Status Show Total Configuration Managed Memory (6733)
  • Add: Table Properties: Increase Table Dependencies (6733)
  • Databases such as SQL Server/SQL Azure/Firebird/Oracle/IBM DB2/Informix/Sybase ASE
  • Upd: After the Splash Form opens and ends, return to the issue of the owning window (6733)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6733)
  • Generating Scripts:
  • Fix: (PostgreSQL) Fixed issue where SCHEMA was not specified when generating object annotations (COMMENT) (6733)
  • AutoComplete and IntelliSense:
  • Fix: Fix the problem that the screen may not display properly under occasional situations (6733)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6733)

New in Database .NET Professional 25.0.6726.1 (Jun 1, 2018)

  • Main program update ( Main ):
  • Add: (HP Vertica/Informix/Teradata/VistaDB) Add Built-in Functions (6726)
  • Upd: (VistaDB) Improving CHECK constraints Object Browsing Processing (6726)
  • Fix: (PostgreSQL) Names of Built-In Functions Changed to Lowercase Display (6726)
  • Upd: (Firebird) Connection Status Enable/Update when Default/Embedded option is switched (6726)
  • Upd: Optimizing Interface Display (6726)
  • Upd: IBM DB2/Informix Component Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.3031.4) (2018/05/22) (6726)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.3 Fix Pack 3a (2018/05/22)
  • Upd: Others include cumulative minor updates, corrections, and optimizations (6726)
  • Search Table Data :
  • Add: Supports regular expression search processing (6726)
  • Fix: Fixed an issue where PostgreSQL could not search normally (6726)
  • AutoComplete and IntelliSense :
  • Add: (HP Vertica/Informix/Teradata/VistaDB) Added built-in functions to automate display processing (6726)
  • Fix: Fixed (6505) Problems with partial object types were not excluded when quotation mark identification was enabled (6726)
  • Upd: Improvements to automatically determine if an object name exception character requires quotation mark identification (6726)
  • Data Editor :
  • Add: Showing filter expression on the toolbar (6718)
  • Fix: (Oracle) Correct CLOB/NCLOB data type processing when there is no primary key (6717)
  • Data Export :
  • Fix: Fix (6715) Problem with Export Format Caused by [No Export Options] Cannot Be Processed Normally (6717)
  • Upd: (Oracle) Added automatic recognition TIMESTAMP data type format millisecond dimension .FFx length export processing (6717)
  • Upd: (Oracle) Joining Automatically Recognize TIMESTAMP and TIMESTAMP WITH TIME ZONE Data Type Format Export Processing (6717)
  • Binding Function parameters :
  • Fix: (Teradata) Repeatedly adding Quoted Identifiers characters when correcting text type (Char) (6726)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6726)

New in Database .NET Professional 24.9.6717 .2 (May 23, 2018)

  • Data Export:
  • Fix: Fix (6715) Problem with Export Format Caused by [No Export Options] Cannot Be Processed Normally (6717)
  • Upd: (Oracle) Added automatic recognition TIMESTAMP data type format millisecond dimension .FFx length export processing (6717)
  • Upd: (Oracle) Joining Automatically Recognize TIMESTAMP and TIMESTAMP WITH TIME ZONE Data Type Format Export Processing (6717)
  • Data Editor:
  • Fix: (Oracle) Correct CLOB/NCLOB data type processing when there is no primary key (6717)
  • Main program update ( Main ):
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6717)

New in Database .NET Professional 24.8.6701.1 (May 7, 2018)

  • Main program update ( Main ):
  • Add: Supports MySQL 8.0 GA Database System (6701)
  • Supports the latest Caching SHA-2 Pluggable Authentication plug-in authentication connection processing (6701)
  • Supports the latest MySQL 8.0 Backup and Restore Database backup and restore processing, and supports all versions 5.0 to 8.0 down (6701)
  • Need to work with the latest Database .NET Additional Files ( 32bit / 64bit ) (2018/04/22)
  • Upd: Acquires access to the database KeyInfo such as Access/Excel/dBase/FoxPro/Text (affects related functions) (6701)
  • Upd: If you switch to another program during execution, you will not switch back to the main program when completed, to avoid affecting the user experience (6701)
  • Upd: Improved Password Dialog Display and Positioning Order Problems (6701)
  • Upd: Minimized to Tray (6701)
  • Upd: MySQL Component Update to MySql.Data.dll 6.9.12 (2018/05/02) (6701)
  • Upd: Others include cumulative minor updates, corrections, and optimizations (6701)
  • Misc: Compatible with SQL Server 2016 SP2 / SQL Server 2016 SP2 Express and LocalDB (2018/04/23)
  • Misc: Compatible with Compatible with MySQL 8.0.11 / MySQL 5.7.22 / MySQL 5.6.40 / MySQL 5.5.60 (2018/04/19)
  • Misc: Compatible with Microsoft Windows 10 (1803) ( )
  • Security Manager :
  • Upd: (MySQL) Update CREATE USER generated content: Added WITH [authentication plugin] authentication method (6701)
  • Generating Scripts :
  • Add: (Oracle) Processing When Auto-repair Causes ORA-39212 Error (6701)
  • Add: (SQL Server 2016+/SQL Azure) Support for Encrypted columns syntax generation (6701)
  • Upd: Remove content [ends] for GO's batch character processing (6701)
  • SQL Editor :
  • Add: Close Query Query Dialog Add Save Button Processing (6701)
  • Add: Duplicate the current line: Ctrl + D (6701)
  • Add: Add Rename Query: Double-Click (6701)
  • Connection List :
  • Upd: Improved [double-click] connection processing to avoid scrolling due to Description for connections (6701)
  • Backup/Restore Database :
  • Upd: (MySQL/PostgreSQL) Improved Automatic Detection of Local Database Installation Paths (6701)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6701)

New in Database .NET Professional 24.7.6677.1 (Apr 13, 2018)

  • SQL Editor :
  • Add: Add copy result as IN clause (6677)
  • Connection Profile :
  • Add: Supports changing the profile name in the connection settings, replacing the original new processing (6677)
  • Fix: Fixed the auto-reading function of the pull-down database menu. Repeated attempts to cause long waiting problems when the connection failed (6677)
  • Upd: When updating the Profile Name process, avoid changes due to automatic reading of existing settings with the same name (6677)
  • Connection List :
  • Upd: Add duplicate name detection processing when changing profile name (6677)
  • Connection Manager :
  • Upd: Automatically Refreshing the List of Master Programs After Updating Pin/Unpin Updates (6677)
  • Fix: Avoid open connection processing when double-clicking Pin/Unpin update (6677)
  • Binding Function parameters :
  • Fix: Fix the problem of generating missing () characters in the script when the function does not take any parameters (6677)
  • Main program update ( Main ):
  • Upd: Main Program Title Increases Profile Name Display (6677)
  • Upd: Others include cumulative minor updates, corrections, and optimizations (6677)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6677)

New in Database .NET Professional 24.6.6673.1 (Apr 9, 2018)

  • Main program update ( Main ):
  • Add: (IBM DB2) Support DBMS_OUTPUT output message display (6673)
  • Supported include: Oracle/ IBM DB2 and other databases
  • Upd: (Oracle) Solve the problem that when the database encoding is non-UTF (8/16), and the client code is not English, the error message is garbled (6673)
  • Upd: (MySQL) Forces the connection attribute setting (Allow Zero Datetime=False) and removes it from the settings to avoid failures resulting in editing and export in/out (6673)
  • Add: (VistaDB) Identity Data Seed Reset After Clearing Data Sheet Data (6673)
  • Add: (VistaDB) support data table Identity property Increment value get(6673)
  • Upd: (Access/SQLCe) Improves the data table clearing process, retaining the original Identity property Increment value (6673)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6673)
  • Misc: How to install 64bit Microsoft Access Database Engine alongside 32bit Microsoft Office
  • Binding Procedure parameters:
  • Add: (IBM DB2) Support OUTPUT output parameter content display (6673)
  • AutoComplete and IntelliSense:
  • Fix: Fix the problem that the shortcut Ctrl + K Code Code (Code Snippets) doesn't work (6673)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6673)

New in Database .NET Professional 24.5.6664.1 (Mar 31, 2018)

  • Data Editor:
  • Add: (SQLite) Automatically recognizes Binary GUID and String GUID Add/Update/Delete processing (6664)
  • Add: (Sybase ASE) Default Value Synchronization Update Display After Supporting [New Data Column] (6664)
  • Upd: (MySQL) Improvements When the Default Value='' is Blank [New Data Column] Synchronized Update Display (6664)
  • Upd: (MySQL) Supports ON UPDATE CURRENT_TIMESTAMP [Update Data Column] Synchronized Update Display (6664)
  • Fix: Fixed an issue that could cause exceptions if the save was skipped at the same time as the reflash process (6664)
  • Main program update ( Main ):
  • Upd: (SQLite) Resolve compatibility issues with System.Data.SQLite.DLL encryption characters and use of open methods (6664)
  • Upd: (dBase) Automatically exclude files from [non-] dBase Table File Format to avoid invalid loading (6664)
  • Upd: (Oracle) Updating TIMESTAMP Data Type Maximum Length Limit (6664)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6664)
  • Table Designer:
  • Add: DateTime default value selector (6664)
  • Fix: (FoxPro) Fixed an issue that could not [update] existing data tables (6664)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6664)

New in Database .NET Professional 24.3.6645.1 (Mar 12, 2018)

  • Main program update ( Main ):
  • Add: (PostgreSQL 10) Supports MacAddr8 Data Type Handling (6645)
  • Upd: Update the new database default extension name: (SQLite) *.db, (Firebird) *.fdb(6645)
  • Fix: (SQLite) Fixes Problems That Cannot Process WITH RECURSIVE Views (6645)
  • Add: Display indicator for a taskbar button (6640)
  • Fix: (SQL Server/SQL Azure) Problem Solved When Field Names Begin with _ Name (6640)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.108.0 (3.22.0) (2018/03/02) (6640)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6645)
  • Misc: Compatible with PostgreSQL 10.3 / 9.6.8 / 9.5.12 / 9.4.17 / 9.3.22 (2018/03/01)
  • Generating Scripts :
  • Upd: (SQLite) Improved Content Formatted Output (6645)
  • Displaying informational messages :
  • Upd: When an error occurs, if there is an informative message associated with the display (6640)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6645)

New in Database .NET Professional 24.2.6640.3 (Mar 7, 2018)

  • Main program update ( Main ):
  • Add: Displaying a progress indicator in a taskbar button (6640)
  • Fix: (SQL Server / SQL Azure) The problem of unable to get the field correctly when data table name begins with _ (6640)
  • Upd: SQLite Symbol Version Updated to System.Data.SQLite.DLL 1.0.108.0 (3.22.0) (2018/03/02) (6640)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6640)
  • Misc: Compatible with Compatible with PostgreSQL 10.3 / 9.6.8 / 9.5.12 / 9.4.17 / 9.3.22 (2018/03/01)
  • Displaying informational messages :
  • Upd: In case of an error in execution, an informative message will be displayed (6640)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6640)

New in Database .NET Professional 24.2.6635.2 (Mar 2, 2018)

  • Main program update ( Main ):
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6635)
  • Misc: Compatible with Compatible with PostgreSQL 10.3 / 9.6.8 / 9.5.12 / 9.4.17 / 9.3.22 (2018/03/01)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6635)

New in Database .NET Professional 24.2.6627.2 (Feb 21, 2018)

  • Main program update ( Main ):
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6627)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6627)

New in Database .NET Professional 24.2.6624.1 (Feb 19, 2018)

  • Query Design Tool ( Query Builder )
  • Add: Support Table Sort Sort by Name and Index (6624)
  • Add: Support Fields Data Types Data Types (6624)
  • Upd: Optimize the field interface display, clear identification and identification fields such as PK / FK / NOT NULL (6624)
  • Upd: Optimized Data Sheet Title Display (Schema.Table AS Alias) (6624)
  • Upd: Enhance the processing speed of open data table, and increase the number of objects displayed (6624)
  • Upd: Support Windows maximize display (6624)
  • Fix: Avoid New Multiple Execution Tags When Executing and Testing Syntax (6624)
  • Upd: Improve the window when the database connection is interrupted does not automatically shut down (6624)
  • Upd: Boost Selected Queries to Selected Text to Query Builder (6624)
  • Main program update ( Main ):
  • Upd: Optimizing Database Diagram (6624)
  • Add: Add Profile Auto Backup and Restore (6624)
  • Fix: (Oracle) Fixing Packages Packages Same Name Program Overload Issues (6624)
  • Add: (OData) Right-Click Menu Open Data Sheet Specified Field Data (same general database) (6624)
  • Upd: (Firebird 4) Update Info Type DECIMAL / NUMERIC Maximum Length to 34 (6624)
  • Fix: WinXP amended under the tree node background display problems (6624)
  • Upd: SQLite Symbol Version Updated to System.Data.SQLite.DLL 1.0.107.0 (3.22.0) (2018/01/30) (6624)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6624)
  • Misc: Compatible with Compatible with PostgreSQL 10.2 / 9.6.7 / 9.5.11 / 9.4.16 / 9.3.21 (2018/02/08)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6624)

New in Database .NET Professional 24.1.6603.1 (Jan 29, 2018)

  • Table Designer :
  • Fix: Unspecified issue of SCHEMA when correcting data sheet field update or data sheet reconstruction (6603)
  • Upd: (MySQL) data table to establish the default encoding to Server-side settings encoding to simplify the relevant processing (6603)
  • Constraint Designer :
  • Add: (MySQL) to version 5.0 database support (6603)
  • Connection Profile :
  • Fix: solve the problem when the focus in the Properties page (Properties), click ENTER can not be saved (6603)
  • Main program update ( Main ):
  • Upd: (MySQL) When the server side encoding utf8mb4, if the Client default is automatically modified with the Server side consistent (6603)
  • Upd: MySQL Component Version Updated to MySql.Data.dll 6.9.11 (2018/01/20) (6603)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6603)
  • Grant Manager (Pro):
  • Add: (MySQL) to join the database version 5.0 to 5.4 support (6603)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6603)

New in Database .NET Professional 24.0.6593.1 (Jan 19, 2018)

  • Main program update ( Main ):
  • Add: Add Duplicating Tables (6593)
  • Fix: fix the specified database connection failure and then switch [different types] database connection processing problems (6593)
  • Fix: (IBM DB2) Fixing VIEWS / INDEXES Browse Problems with Identical Names of Objects Different in Different Schemas (6593)
  • Fix: (Informix) Fixed Problems with TABLES / VIEWS / INDEXES Browse for Objects with Same Name but Different Case in Different SCHEMA (6593)
  • Fix: (Informix) Fixes for Non-sysmaster Number of Columns Message Unreachable ( Table RowCount ) (6593)
  • Upd: (Text) No processing will continue when the attached file does not exist (6593)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6593)
  • Command Line Processing ( Command-line ):
  • Upd: rewrite significantly improve the processing speed (6593)
  • Fix: fixing the problem of missing separator format (6593)
  • Data Export :
  • Fix: (VistaDB) export query results column SQL format: Keep Keep Identity keep no effect (6593)
  • Connection List :
  • Upd: Improve User Experience: Launch the Last Connection List Automatically After Launch, Eliminate One-Click Processing (6593)
  • Upd: Improve user experience: Double-click the connection after switching between different database types to avoid the normal processing due to scrolling (6593)
  • Visual Execution Plan (Pro):
  • Add: Support Tree node on the right [Click] Display Properties Content Processing (same as click left visual) (6593)
  • Upd: Automatically switches to [Textual] Plain Execution Plan display (6593) when [Execute Text Output] or Library Version [Visualization Not Supported]
  • Data Editor :
  • Add: (PostgreSQL) OID-enabled processing is supported when no columns are updated or deleted by the primary key (PKR) (6593)
  • Add: (Informix) Supports rowid-based processing when no primary key (PK) updates or deletes a data column (6593)
  • SQL Editor :
  • Upd: Save If no folder is selected, the current folder location is saved as the current folder type (6593)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6593)

New in Database .NET Professional 23.9.6586.2 (Jan 12, 2018)

  • Main program update ( Main ):
  • Fix: To solve (6585) in some user's environment, after the start exception error (6586)

New in Database .NET Professional 23.9.6585.1 (Jan 11, 2018)

  • 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)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6585)

New in Database .NET Professional 23.8.6578.1 (Jan 4, 2018)

  • 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)

New in Database .NET Professional 23.7.6557.1 (Dec 14, 2017)

  • 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)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6557)

New in Database .NET Professional 23.5.6544.2 (Dec 1, 2017)

  • 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)

New in Database .NET Professional 23.5.6540.3 (Nov 27, 2017)

  • Main program update ( Main ):
  • 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 (6540)
  • Data Export :
  • Upd: Update XML Export Format: Add XSD Schema Definition Display (6540)
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6540)

New in Database .NET Professional 23.5.6528.1 (Nov 15, 2017)

  • Main program update ( Main ):
  • Add: Read-Only Mode : Add support for MySQL / SQL Server database read-only mode processing (6528)
  • Has been included Support: MySQL / SQL Server / SQLite / SQLCe / Access / Excel / dBase / Text / HP Vertica and other databases
  • Add: External Index Keys Enabling or Disabling Foreign Keys: Adding Support for SQL Server / SQL Azure / Oracle Databases (6528)
  • Fix: fixes SQL Server 2005 can not get the field message (the impact includes multiple functions) (6528)
  • Upd: Waiting for Windows to Support Manual Shutdown to Avoid Problems That Can not Be Processed When Any Exception Occurs (6528)
  • Fix: Fix (6512) Causes Correlated Issues (6528)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6528)
  • Misc: Compatible with Compatible with PostgreSQL 10.1 / 9.6.6 / 9.5.10 / 9.4.15 / 9.3.20 / 9.2.24 (2017/11/09)
  • Connection List :
  • Add: Add Click Single-click button (6528)
  • Add: Added Generate the command-line to Clipboard automatically generated selected connection name (6528)
  • Command Line Processing ( Command-line ):
  • Add: support servo database direct connection processing, without establishing connection settings (6528)
  • Without a profile_name you can use: [-s: servername] [-d: databasename] [-p: port] [-u: username] [-w: password] [-e winauth]
  • Add: Support directly open the protected portable database with password connection processing (6528)
  • app.exe c: 1.db -w: password
  • Database Migration (Pro):
  • Upd: All Updates Same as dbMigration .NET Software (6528)

New in Database .NET Professional 23.4.6519.1 (Nov 6, 2017)

  • Data Export :
  • Add: Added Export Result Column (Update and Delete) State Generating UPDATE and DELETE statements from results (6519)
  • Add: Add Export selected rows to a file (6519) for Export [Selected]
  • Upd: The original [N] [All] data column to new query window Change to the [Selected] data column output (6519)
  • Fix: Copy [Selected] Rows to Clipboard : Fix Multiple Separated Characters in the First Column of SQL Format (6519)
  • Fix: export query result column SQL format: fix the Keep Nulls settings also affect the Keep Identity retention error (with the 6341 data table export) (6519)
  • Main program update ( Main ):
  • Add: (64bit) Join SQLCe 3.5 as a built-in process to replace the original attached file (6519)
  • Upd: Read-Only Mode : Update menu function enable status, exclude non-read-only function (6519)
  • Upd: Improving User Experience: Optimizing Click Auto-Expand / Collapse Nodes Processing to Avoid Double-Click Occurrences that Cause Unfolding Simultaneously and Concatenate (6519)
  • Upd: Improving User Experience: Optimizing Right-Click Menu Selection Status and Sub-Key Display Processing (6519)
  • Upd: SQLite Symbol Version Updated to System.Data.SQLite.DLL 1.0.106.0 (3.21.0) (2017/11/02) (6519)
  • Upd: HP Vertica Component Version Updated to Vertica.Data.dll 9.0.0.1 (2017/10/27) (6519)
  • Upd: MySQL Component Version Updated to MySql.Data.dll 6.9.10 (2017/10/23) (6519)
  • Upd: Sybase ASE Component Version Updated to Sybase.AdoNet4.AseClient.dll 4.157.1000.0 (2013/04/26) (6519)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6519)

New in Database .NET Professional 23.3.6512.1 (Oct 29, 2017)

  • Main program:
  • Upd: Optimize the main program startup speed and overall processing efficiency (6512)
  • Add: Restored recently closed tabs : Add to the index label button with the label title in the right menu (6512)
  • Add: support script generation export to clipboard ( Copy Script to Clipboard ) (6512)
  • Add: re-filter filter columns : integrated into the data list right-click menu, as a sub-option sub-option [F] (6512)
  • 1. Increase the work bar and right-click menu, 2. Support batch processing, 3. Support drag and drop mobile processing, 4. WYSIWYG immediately update ... and other new features
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6512)
  • Misc: (Excel 32bit) due to Microsoft update lead to the occurrence of connection Unexpected error from external database driver, can refer to ( Link1 , Link2 ) solution
  • SQL editor:
  • Upd: Improved label off processing: When you close more than one [Edit] tab, only one question window (6512) will be displayed.
  • Fix: Fixed a problem where the list item in the Window menu can not be removed when the [Edit] tab is removed (6512)
  • Fix: Fix the label off the problem of exception handling in some cases (6512)
  • Process List:
  • Fix: Fix the problem that the editor can not hide the editor when the current query page is empty (6512)
  • Upd: Improved Execution Processing Exclusion Records in SQL History (6512)
  • Updating: 1. Increase the field to hide the memory, 2. Remove the unnecessary auto filter data button (6512)
  • Data column editor:
  • Fix: Duplicate the Row: Fixed a problem that could not be saved if the virtual field was included (6512)
  • Upd: Duplicate the Row: Improvements will not be processed when the remake field is read-only (eg BLOB type) (6512)
  • Data Editor / Cell Viewer :
  • Upd: Edit mode: Format and compression separate processing, browse mode: Optimize the formatting function and change to automatic processing (6512)
  • AutoComplete and IntelliSense :
  • Add: Generates the Generating Cache TimeOut, which automatically ends the processing when the build time exceeds the setting (6512)

New in Database .NET Professional 23.2.6505.1 (Oct 22, 2017)

  • Main program:
  • Add: (64bit) Added support for the dBase IV / 5.0 (* .dbf) database (6505)
  • Upd: Improvements When the login user has no SELECT privilege or can not load Data Types, you can choose to disconnect or continue to connect (6505)
  • Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.106.0 (3.21.0) (2017/10/17) (6505)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 9.0.0.0 (2017/10/16) (6505)
  • Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.2021) (2017/10/10) (6505)
  • Misc: (IBM DB2 / Informix) IBM Data Server Client Packages 11.1 Fix Pack 2a (2017/10/10)
  • Upd: EPPlus Component Version Update to EPPlus.dll 4.1.1 (2017/10/08) (6505)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6505)
  • Misc: Compatible with Compatible with MySQL 5.7.20 (2017/10) / MySQL 5.6.38 (2017/10) / MySQL 5.5.58 (2017/10)
  • Misc: Compatible with Compatible with Microsoft Windows 10 (1709) ( )
  • SQL Profiler:
  • Add: (Vertica) Added support for Vertica 7.x older versions (6505)
  • Connection Manager:
  • Fix: (dBase) Fixed list field does not fully display the specified path (6505)
  • AutoComplete and IntelliSense:
  • Add: Add Quoted Identifiers (6505) Enable Quoted Identifiers (6505)
  • Upd: Improved User Experience: Re-Remove Shortcut F5 Insert Project Processing (6505)
  • Upd: Optimize Field Perceptions (6505)
  • Data Viewer:
  • Upd: Browse Schema Original XML / JSON AutoFormat to manual formatting (6505)
  • Database Migration (Pro):
  • Add: (64bit) Added support for the dBase IV / 5.0 (* .dbf) database (6505)
  • Fix: (64bit) Fixed when the problem did not get the focus of the display (6505)
  • Upd: All updates with dbMigration .NET Software (6505)

New in Database .NET Professional 23.1.6488.1 (Oct 6, 2017)

  • Main program:
  • Add: add or hide left panel Shortcut Keys : (Show or hide the left panel: F12 ) (6488)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.1.6 (2017/09/27) (6488)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6488)
  • Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2017/10/03)
  • Misc: Compatible with Compatible with PostgreSQL 10 RTM (2017/10/05)
  • Misc: Compatible with Compatible with SQL Server 2017 RTM (2017/10/02)
  • Object Navigator :
  • Add: (Access) Support System Table Display (6488)
  • SQL history:
  • Updating SQL statements such as INSERT / DELETE / UPDATE SQL performance analyzer (including SQL Profiler 's LOG mode) (6488)
  • Data Editor and Browser :
  • Fix: (PostgreSQL / Oracle) Fixed (6448) caused TIMESTAMPTZ field type, when the data is NULL can not handle the problem (6488)
  • Data Browser :
  • Upd: Update (6467) Field [Text] Data Type Increment Length Display (Column Size) (same as editing) (6488)
  • AutoComplete and IntelliSense :
  • Upd: Optimize SUB-SELECT Sensing Resolution (6488)
  • Database Migration (Pro):
  • Fix: (64bit) Fixed when the main program is minimized when the progress window shows the problem (6488)
  • Upd: All updates with dbMigration .NET Software (6488)

New in Database .NET Professional 23.0.6467.1 (Sep 15, 2017)

  • Main program:
  • Add: add 64-bit professional version ( Database .NET Standard x64 (w / o Data Migration) ) (6467)
  • Provide another option for 64-bit and professional users who have all the features but do not need a database conversion feature
  • Upd: Improved click (+/-) issues associated with double-clicking expand / collapse nodes (6467)
  • Upd: Optimize ListView Control Display Efficiency, Avoid Unnecessary Heavy Brush Display Processing (6467)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6467)
  • SQL editor:
  • Upd: Support Messages Tab Font Size Update (inherited from Text Results) (6467)
  • Data Browser :
  • Upd: field [text] data type increase length display (Column Size) (same editor) (6467)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6467)

New in Database .NET Professional 22.9.6463.1 (Sep 11, 2017)

  • Code Manager :
  • Add: support multi-line search processing (6433)
  • Add: support result highlighting (6463)
  • Upd: Support Search Process Interrupt Processing (6463)
  • Main program:
  • Add: add GetColumns alternative processing (support for all database types), when the built-in can not get the data table field automatically switch processing (6463)
  • Resolve the problem when Excel can not get fields when the table name contains - characters
  • Fix: (MySQL 5.x) down compatible lower database version update processing:
  • Upd: (MySQL 5.5.3+) Increased version detection when PROCEDURE AND FUNCTION PARAMETERS is accessed to avoid invalid handling (6463)
  • Fix: Security Manager : Fixed an issue where older versions (<5.5) were not working properly (6463)
  • Fix: Fixed an issue where the older version (<5.0.?) Could not normally generate object definition content (DDL) (including TABLES / VIEWS / PROCRDURES / FUNCTIONS) (6463)
  • Fix: Fix older version (<5.1.21) Problems with object definition content (DDL) that can not be generated properly (including TRIGGERS) (6463)
  • Fix: Process List : Fixed an issue where the older version (<5.0.?) Could not display the contents of the field (6463)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6463)
  • Misc: Compatible with Compatible with NuoDB 3.0 (2017/09)
  • Generating Scripts :
  • Fix: Keep the data type case different display (including data table update and script generation) (6463)
  • Fix: (Firebird) Fixed DOMAIN data type generation processing (including data table update and script generation) (6463)
  • Upd: (Firebird) update DOMAIN script generation: increase SEGMENT SIZE, CHARACTER SET, COLLATE and other property display (6463)
  • Fix: (Firebird) Fix INDEX script generation: Fix the problem of generating Indexing on expressions (6463)
  • Fix: (SQLite) fixes CHECK constraints parsing processing (including table updates and script generation) (6463)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6463)

New in Database .NET Professional 22.8.6456.1 (Sep 4, 2017)

  • Search Objects :
  • Add: Support Content Search ( Search DDL (Data Definition Language) ( Pro ) (6456)
  • Support includes tables / indexes / triggers / views / procedures / functions / serial / packages / macros / synonyms ... etc etc etc.
  • Add: Right-click menu item Add sub-option Search all items [ALL] Processing (6456)
  • Upd: [Browse all database schemas] Change to search for [current Schema] Specifies that the object is no longer all (6456)
  • Upd: Improved Sub-Objects Search Processing: Contains all library object types (6456)
  • DateTime Picker :
  • Add: support time zone ( TimeZone ) automatic conversion processing (6456)
  • Security Manager :
  • Add: (Firebird 4+) support System privileges for Roles role system settings (6456)
  • SQL Profiler :
  • Add: (Firebird 3+) support 2.5, 3.x and 4.x Global Mode profiling (6456)
  • Inspect Object :
  • Add: Add Quick Filter objects (6456)
  • Data Editor and Browser :
  • Upd: Optimize the width of the field automatically adjust the processing (for different data types and data formatting ...) (6456)
  • Main program:
  • Upd: Improved [Library Object Search Window] and [Database Chart Window] (6456) after [Interrupted Connection] or [Switch between different Schema]
  • Fix: Clear Quick Filter : Fixes problems that can not be displayed in many states (6456)
  • Fix: resolving some of the data types with length may affect some of the functional judgment problems (6456)
  • Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.11.0.0 (2017/08/30) (6456)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6456)
  • Misc: Compatible with Compatible with PostgreSQL 9.6.5 / 9.5.9 / 9.4.14 / 9.3.19 / 9.2.23 (2017/08/31)

New in Database .NET Professional 22.7.6449.1 (Aug 28, 2017)

  • SQL editor:
  • Add: search and replace support for multi-file processing ( Finding and Replacing Multiple Documents ) (6448)
  • Add: search and replace the dialog box to join the shortcut key processing ( Shortcut Keys ): (6448)
  • Replace Next Alt + R , Replace All Alt + A , Match case Alt + C , Match whole word Alt + W , Regular Expressions Alt + E
  • Main program update:
  • Upd: (PostgreSQL) The original switch library function to the database tool (DB Tools-> Specify a database) (6448)
  • Upd: (Oracle) Update TIMESTAMP WITH [LOCAL] TIME ZONE Data Type Default Max (6448)
  • Upd: (OleDB / ODBC) Add DECIMAL / NUMERIC (precision, scale) Accuracy display (including data table editing and script generation) (6448)
  • Fix: (NuoDB) Fix and update INTEGER / DECIMAL / CLOB data type and precision display (including data table editing and script generation) (6448)
  • Upd: Improved Data Table Field Data Type Length (n) Resolution Capability (Impact Contains Multiple Functions) (6448)
  • Upd: Improved Table Fields Automatically Add Custom Type Processing (6448)
  • Fix: Data Statistics Update: Removes unsupported library options (6448)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6448)
  • Data Editor and Browser :
  • Upd: (Oracle) Support TIMESTAMP WITH TIME ZONE Display and Edit Processing (6448)
  • Upd: (PostgreSQL) support TIMESTAMPTZ display and edit processing (6448)
  • Support for databases containing Oracle / PostgreSQL / SQL Server / VistaDB / Teradata / Vertica (including export processing)
  • Data Export :
  • Upd: (Oracle) support TIMESTAMP WITH TIME ZONE format export processing (6448)
  • Upd: (PostgreSQL) support TIMESTAMPTZ format export processing (6448)
  • Fix: (Oracle) Export Format INSERT statement (* .sql): Fixed BEGIN ... END; The last INSERT unfinished character (6448)
  • Table Designer :
  • Fix: (Firebird 3+) Fix Table Fields NULL / NOT NULL Update Processing (6448)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6448)

New in Database .NET Professional 22.6.6437.2 (Aug 16, 2017)

  • Main program update:
  • Add: support Schema switch object cache processing, can quickly switch between different Schema query tags no need to reload processing (6437)
  • Add: Status column Add the current label Database Type and Schema Name Display (6437)
  • (NuoDB / Vertica / Informix / DB2 / PostgreSQL) support different Schema Name tag switching, while switching objects to browse under the Schema (6437)
  • Add: (FoxPro) support (* .dbf) database connection processing (automatically create dbc multiple choice to join * .dbf file) (6437)
  • Upd: Optimize command -line resolution (6430)
  • Upd: (Firebird) Improvements to get the installation directory may cause an exception event handling (6430)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6437)
  • Misc: Compatible with Compatible with PostgreSQL 9.6.4 / 9.5.8 / 9.4.13 / 9.3.18 / 9.2.22 (2017/08/10)
  • Open last query tabs on startup :
  • Add: add SchemaName and DBtype state save processing, re-connect directly after the state (6437)
  • Upd: Save the last label to 100 (6430)
  • Fix: Fix (6372) Problems with the same name tab can not be saved (6430)
  • Data Export :
  • Add: Data Column Export Format * .sql Add Preserve schema name (6437)
  • My Favorites ( My Favorites ):
  • Fix: rewrite and fix [Servo] database handling (6437)
  • Plain Execution Plan :
  • Upd: (Informix) Optimize output processing to exclude unwanted message display (6437)
  • Table Designer :
  • Upd: (SQLite) field defaults when the function is automatically added (Parentheses) brackets (including script generation) (6437)
  • Data editor ( Cell Editor ) / data grid browser ( Cell Viewer )
  • Add: support for exporting original file format (Original Format (*. *)) (6430)
  • Upd: Optimize Gif file format export processing (6430)
  • Fix: Fixed (6411) part of the file format export still can not handle the problem (6430)
  • SQL Profiler :
  • Upd: (MySQL) Join Global Mode Message Switch Display and Support Version Detection Processing (6430)

New in Database .NET Professional 22.5.6430.2 (Aug 9, 2017)

  • Main program update:
  • Upd: Optimize command -line resolution (6430)
  • Fix: start the last query to open the label: 1. Fixed (6372) lead to the same name tab can not save the problem, 2. increase the preservation of the last label to 100 (6430)
  • Upd: (Firebird) Improvements to get the installation directory may cause an exception event handling (6430)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6430)
  • Data editor ( Cell Editor ) / data grid browser ( Cell Viewer ):
  • Add: support for exporting original file format (Original Format (*. *)) (6430)
  • Upd: Optimize Gif file format export processing (6430)
  • Fix: Fixed (6411) part of the file format export still can not handle the problem (6430)
  • SQL Profiler:
  • Upd: (MySQL) Join Global Mode Message Switch Display and Support Version Detection Processing (6430)

New in Database .NET Professional 22.4.6411.1 (Jul 21, 2017)

  • Main program update:
  • Add: Automatically exclude unsupported connection attribute settings, to avoid problems with different versions that can cause no connection (6411)
  • Add: (HP Vertica 8+) Join CHECK Constraints Object Browse / Delete / Enable / Script Generation (6411)
  • Upd: (ODBC / OleDB) to improve the access to different types of database data types (6411)
  • Upd: (Firebird) Improved Data Table Fields DOMAIN Type Access Capabilities (6411)
  • Upd: Update Editor Font Size Max Settings (Editor Font MaxSize = 16) (6411)
  • Upd: (64bit) VistaDB Component Version Update to VistaDB.5.NET40.dll 5.6.8 (2017/07/12) (6411)
  • Upd: (64bit) MySQL Component Version Update to MySql.Data.dll 6.10.2 (2017/07/04) (6411)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.1.0 (2017/07/10) (6411)
  • Upd: Teradata component version update to Teradata.Client.Provider.dll 16.10.0.0 (64bit) (2017/07/05) /15.11.0.4 (32bit) (2017/04/28) (6411)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6411)
  • Misc: Compatible with Compatible with MySQL 8.0.2 (2017/07) / MySQL 5.7.19 (2017/07) / MySQL 5.6.37 (2017/07) / MySQL 5.5.57 (2017/07)
  • Data column editor:
  • Add: (HP Vertica) support after the automatic display (Named Sequence) value-added processing (6411)
  • Data Browser:
  • Upd: Field Data Type Display Replace the original System Types with the original System Types (6411)
  • Add: field name background display support different color distinction NOT NULL (same editor) (6411)
  • Data editor ( Cell Editor ) / data grid browser ( Cell Viewer )
  • Upd: Optimize and Improve Image Format Export Processing (6411)
  • Generating Scripts:
  • Add: (PostgreSQL 10+) support CREATE SEQUENCE AS datatype attribute generation (6411)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6411)

New in Database .NET Professional 22.3.6397.1 (Jul 7, 2017)

  • Main program:
  • Upd: (ODBC / OLEDB) to enhance the primary key (Primary Keys) to obtain the ability (including data editing and script generation) (6397)
  • Upd: (ODBC / OLEDB) Improved primary key index automatic elimination (including script generation) (6397)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.0.1.6 (2017/06/26) (6397)
  • Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.2020.4) (2017/06/23) (6397)
  • Misc: (IBM DB2 / Informix) IBM Data Server Client Packages 11.1 Fix Pack 2 (2017/06/23)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6397)
  • Generating Scripts :
  • Upd: (SQL Server 2005+) Increase the display of the Computed Column property PERSISTED (6397)
  • Connection Manager :
  • Upd: 1. The title shows the currently selected connection, 2. The initial selection of the last item (6397)
  • Fix: Fix the problem of missing new connection (6397)
  • Table Designer :
  • Fix: (Firebird) Fixed (6379) Problems with IDENTITY field attribute setting lost (6397)
  • Data Import :
  • Add: support record record separation ( Restoring the record separator from ' r n' ) (6387)
  • Upd: When you import via [Edit], the hidden field is no longer displayed (6387)
  • Fix: Improved ( Empty as NULL ): No processing when the source is not a text type (6387)
  • Data export:
  • Add: (Delimitex Text) supports the recording of the separator separator ( Convergence of the record separator to ' r n' ) (6387)
  • Add: (HTML) Support Multiple Lines of Text () Export Export Character Processing (6387)
  • SQL editor:
  • Upd: Optimizing and Correcting JSON Formatting and Compression Processing (6387)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6397)

New in Database .NET Professional 22.2.6387.3 (Jun 27, 2017)

  • DATA IMPORT:
  • Add: support record record separation (Restoring the record separator from ' r n') (6387)
  • Upd: When you import via [Edit], the hidden field is no longer displayed (6387)
  • Fix: Improved ( Empty as NULL ): No processing when the source is not a text type (6387)
  • DATA EXPORT:
  • Add: (Delimitex Text) supports the recording of the separator separator (Convergence of the record separator to ' r n') (6387)
  • Add: (HTML) Support Multiple Lines of Text () Export Export Character Processing (6387)
  • SQL EDITOR:
  • Upd: Optimizing and Correcting JSON Formatting and Compression Processing (6387)
  • MAIN PROGRAM:
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6387)

New in Database .NET Professional 22.2.6379.1 (Jun 19, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: Support Firebird 4 database system (6379)
  • Support SQL SECURITY {DEFINER | INVOKER} definition generation (6379)
  • Support GENERATED ALWAYS IDENTITY, INCREMENT BY definition generation (6379)
  • Upd: (Firebird Embedded) to improve the different versions of the Firebird database using the same program when the connection problem ( Managing different versions ) (6379)
  • Upd: (Firebird) support installation services detection processing, support 1.5.x version (6379)
  • Fix: (Firebird) amended under the normal function can not normally browse the FUNCTIONS object (6379)
  • Fix: (Firebird) improved when no installation of any FB service, the full use of embedded version of the problem (6379)
  • Add: (64bit) Join SQLCe 3.5 New Database Features (6379)
  • Fix: Resolve the problem of the exit exception (6379) after the program was opened twice (Alt + F4)
  • Fix: Fixed a problem after selecting the last object when connected after browsing [Browse all database schemas] (6379)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6379)
  • SQL EDITOR:
  • Add: support SQL / JSON / XML content compression ( SQL / JSON / XML Compression ) (6379)
  • Add: support JSON / XML content formatting (JSON and XML Formatting) (6379)
  • Add: Remember the data width of the DataGridView (6379)
  • Data editor ( Cell Editor ) / data grid browser ( Cell Viewer ):
  • Fix: Fixed formatting when editing or browsing XML Declaration does not show problems (6379)
  • Generating Scripts:
  • Fix: (Firebird) Fixed a problem with the PROCEDURES object script not being generated under version 1.5 / 2.0 (6379)
  • Object authorization management ( Grant Manager ) (Pro):
  • Add: (Firebird) Added support for version 1.5 database (6379)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6379)

New in Database .NET Professional 22.1.6372.1 (Jun 12, 2017)

  • Main program update:
  • Add: support JSON editing and browsing function ( JSON Editor and Viewer ) (6372)
  • Add: (64bit) support SQL Server Compact 3.5 database management ( Req. AdditionalFiles64.zip ) (6372)
  • Add: (Firebird Embedded) support the management of different Firebird database version, no need to switch services and settings ( Managing different versions ) (6372)
  • Add: (Firebird Embedded) embedded version support database backup, restore and compression ... and other functions, when the specified ClientLibrary path contains related files (6372)
  • Fix: (Firebird Embedded) fix the embedded version can not open the security administrator ( Security Manager ) problem (6372)
  • Fix: (Firebird) solve the problem can not support the remote connection, when the installation of any FB version of the machine (6372)
  • Upd: (PostgreSQL) Improved removal of SCHEMA processing, support for removing dependencies and support for more complete error message display (6372)
  • Upd: Database Object Search: The list of object names with the full name of the node (6372)
  • Upd: Open last query tabs on startup : Save the order from new to old last 20 index tags (6372)
  • Upd: Connection List: Improved Rename Related Issues (6372)
  • Add: support to restore the recently closed index label ( Restoring recently closed tabs ): can restore the latest 10 index tags (6372)
  • Add: Support for PostgreSQL 10 database system (6364)
  • Support GENERATED {ALWAYS | BY DEFAULT} AS IDENTITY (6364)
  • With the change of PG10, update CREATE SEQUENCE generation mode (6364)
  • Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.105.2 (3.19.3) (2017/06/12) (6372)
  • Upd: Oracle Component Version Update to Oracle.ManagedDataAccess.dll 12.2.1100 (2017/05/31) (6364)
  • Updating: HP Vertica Component Version Downgraded to Vertica.Data.dll 8.1.0 -> 8.0.1 to Resolve Some Users in 64bit Environment Compatibility Issues (6364)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6372)
  • Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2017/06/10)
  • Support PostgreSQL 10 database backup and restore (6372)
  • AutoComplete and IntelliSense :
  • Fix: Fixed (6364) Problems causing automatic processing of partial processing exceptions (6367)
  • Fix: Fix the priority of the project with the focus at [beginning match] for the focus, (6364/6367)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6372)

New in Database .NET Professional 22.0.6367.3 (Jun 7, 2017)

  • AutoComplete and IntelliSense :
  • Fix: Fixed (6364) Problems causing automatic processing of partial processing exceptions (6367)
  • Fix: Fix the priority of the project with the focus at [beginning match] for the focus, (6364/6367)
  • Main program update:
  • Add: Support for PostgreSQL 10 database system (6364)
  • Support GENERATED {ALWAYS | BY DEFAULT} AS IDENTITY (6364)
  • With the change of PG10, update CREATE SEQUENCE generation mode (6364)
  • Upd: Oracle Component Version Update to Oracle.ManagedDataAccess.dll 12.2.1100 (2017/05/31) (6364)
  • Updating: HP Vertica Component Version Downgraded to Vertica.Data.dll 8.1.0 -> 8.0.1 to Resolve Some Users in 64bit Environment Compatibility Issues (6364)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6367)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6364)

New in Database .NET Professional 22.0.6364.2 (Jun 5, 2017)

  • Main program update:
  • Add: Support for PostgreSQL 10 database system (6364)
  • Support GENERATED {ALWAYS | BY DEFAULT} AS IDENTITY (6364)
  • With the change of PG10, update CREATE SEQUENCE generation mode (6364)
  • Upd: Oracle Component Version Update to Oracle.ManagedDataAccess.dll 12.2.1100 (2017/05/31) (6364)
  • Updating: HP Vertica Component Version Downgraded to Vertica.Data.dll 8.1.0 -> 8.0.1 to Resolve Some Users in 64bit Environment Compatibility Issues (6364)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6364)
  • AutoComplete and IntelliSense :
  • Fix: Fix the problem with priority to [focus at the beginning] as the focus of the project (6364)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6364)

New in Database .NET Professional 22.0.6361.1 (Jun 2, 2017)

  • Data Import :
  • Add: increase the import null value is NULL set ( Empty as NULL ) (6361)
  • Add: Add the Remove Columns to the Workbar (6361)
  • Data Export :
  • Add: Delimited text format: Export Options (6361)
  • Support for Keep Identity, Keep Nulls, Custom Delimiter and other export options
  • Fix: Fixed (xSV) format, when the first field is hidden, the problem can not be properly exported (6361)
  • Fix: Fixed (XML) format, which affects the import problem when the table name has the same name as the field name (6361)
  • Script Generator :
  • Add: Add Batch Export Table to Generating Delimited text files (6361)
  • Fix: Batch Export to SQL INSERTs Fix the problem that the last output will be deleted (6361)
  • Plain Execution Plan :
  • Upd: (SQLite / IBM DB2) Original data format display to text (6361)
  • Upd: (SQLCe) After the completion of the implementation to locate the tree to display the results page (6361)
  • Data column editor:
  • Add: (ODBC / OLEDB) support after the automatic display of self-added value (Identity Column) processing (6361)
  • Upd: (SQLite) field type is INTEGER PRIMARY KEY and no Cell Value is specified, self-increment is automatically displayed after saving (6361)
  • Fix: Fix BLOB data type content is empty (Empty) display and output problems when non-NULL (6361)
  • Data Grid Editor :
  • Add: support BLOB data type text editing save processing (6361)
  • Add: support TEXT data type RTF edit save processing (6361)
  • Main program update:
  • Upd: (SQLite) Division Virtual Table Derived Data Sheet Display (6361)
  • Upd: Other Include Accumulated Minor Update, Fix and Optimize (6361)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6361)

New in Database .NET Professional 21.9.6352.1 (May 23, 2017)

  • SQL Profiler:
  • Add: (SQL Server 2012+) support for Extended Events , replacing all database versions after 2012+ (6352)
  • Add: Add SQL to New Query tab (6352)
  • Upd: multiple optimization and correction related issues (6352)
  • Main program update:
  • Upd: (SQLite) Individual distinction INTEGER PRIMARY KEY with AUTOINCREMENT definition processing for easy import and related processing (6352)
  • Upd: Optimize the connection list display with the increase left click to display the library menu function (6352)
  • Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.9.1.0 (2017/05/21) (6352)
  • Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.105.1 (3.18.0) (2017/05/15) (6352)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6352)
  • Misc: Compatible with Compatible with SQL Server 2017 CTP2.1 (2017/05/16)
  • Data column editor:
  • Fix: Fixed a problem where the default value can not be added when the default value is NULL (6352)
  • Fix: Fix the problem (6352) of the primary key selector ( PrimaryKey Selector ) when the foreign key field is a GUID type
  • SQL history:
  • Add: edit right-click menu to add SQL Formatting formatting (6352)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6352)

New in Database .NET Professional 21.8.6341.1 (May 12, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: Add Read-Only Mode :
  • Supports libraries such as SQLite / SQLCe / Access / Excel / dBase IV / Text / HP Vertica
  • Add: Support for IBM DB2 for z / OS database system (6341)
  • Fix: Improvements and Corrections Partial Database Constraints Generation and Reconstruction Issues (6341)
  • Upd: to avoid opening the program to force the exit, resulting in an exception (6341)
  • Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.9.0.1 (2017/05/07) (6341)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6341)
  • Misc: Compatible with Compatible with PostgreSQL 9.6.3 / 9.5.7 / 9.4.12 / 9.3.17 / 9.2.21 (2017/05/11)
  • PLAIN EXECUTION PLAN:
  • Upd: Execution Plan for MS Access : Optimize output processing Automatically remove portions that are repeatedly displayed (6341)
  • Upd: (PostgreSQL / MySQL) The original data format is displayed in text (6341)
  • Upd: (HP Vertica) Optimize content display while excluding unnecessary ( GraphViz Format ) format content (6341)
  • VISUAL EXECUTION PLAN (Pro):
  • Add: support to switch to Visual Execution Plan (6341)
  • Supports libraries such as SQL Server / SQL Azure / PostgreSQL / Oracle / HP Vertica / MySQL
  • OBJECT NAVIGATOR:
  • Fix: (Firebird 1.5.x) Fixed Loading FUNCTIONS Object Field Name Problem (6341)
  • Fix: (SQLite) Fixed a problem with CHECK Constraints that could not be obtained if the character was included (6341)
  • DATA EXPORT:
  • Fix: data column export format * .sql fix Keep Nulls settings also affect the Keep Identity retention or not (6341)
  • AUTOCOMPLETE AND INTELLISENSE:
  • Add: support DELETE FROM tab1 WHERE col1 = val data table awareness and field awareness processing (6341)
  • MY FAVORITES:
  • Add: increase support for databases such as IBM DB2 / Informix / SQL Azure (6341)
  • DATABASE MIGRATION (Pro):
  • Upd: All updates with dbMigration .NET Software (6341)

New in Database .NET Professional 21.7.6334.1 (May 5, 2017)

  • Data Export :
  • Add: Data Column Export Format * .sql Added (Single INSERT: A single INSERT statement) option (6334)
  • Add: Data Column Export Format * .sql Add (Keep Nulls: Preserve null values) Options (6334)
  • Main program update:
  • Add: (Firebird) to create a remote database (6334)
  • Upd: (Oracle) remove the OCI Driver connection support, the original set automatically turn Managed Driver is not affected (6334)
  • Upd: Increases the loading speed when clicking on the click list (6334)
  • Upd: Last query tabs : Update no longer> 1MB tags for content (6334)
  • Upd: SQL History : The maximum number of days to keep the record increased to 365 days (6334)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6334)
  • Object Navigator :
  • Add: Right-click menu Enabled or Disabling a CHECK Constraint (6334)
  • Support includes SQL Server / SQL Azure / Oracle and other databases
  • Add: (NuoDB / Sybase ASE) Right-click menu Enabling or Disabling a Trigger (6334)
  • Add: (NuoDB) Right-click menu to join the data table Enabled or Disabling an Index (6334)
  • Add: (NuoDB) Right-click menu to join the data sheet Rebuilding an Index (6334)
  • AutoComplete and IntelliSense :
  • Add: join the analysis of the complete table of contents ( Table Hints ) (6334)
  • SQL editor:
  • Upd: Improved SET TERM [XY] Custom Split Resolution (XY without spaces) (6334)
  • Fix: Inspect Object : Fixed (61xx) problem that caused the message to not disappear automatically (6334)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6334)

New in Database .NET Professional 21.6.6324.1 (Apr 25, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: Supports all database Asynchronous connection open , allows waiting for interruption processing (6324)
  • Add: Connection Profile Connection (Connection Profile), support for non-synchronous connection test interrupt processing (6324)
  • Upd: Data Import : Data Export : Increases the overall performance by 30% to 50% (6316)
  • Upd: Execute an SQL script file : Dramatically optimize batch processing speed (6316)
  • Fix: Improved re-targeting Firebird's path without immediate reboot (6316)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.0 (2017/04/17) (6324)
  • Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.1011.4) (2017/04/10) (6324)
  • Misc: (IBM DB2 / Informix) IBM Data Server Client Packages 11.1 Fix Pack 1a (2017/04/10)
  • Upd: Other Include Accumulated Small Update, Fix and Optimize (6324)
  • Misc: Compatible with Compatible with SQL Server 2017 CTP2 (2017/04/19)
  • Misc: Compatible with Compatible with HP Vertica 8.1 (2017/04)
  • OBJECT NAVIGATION:
  • Add: (SQL Server 2017+) Support SQL graph tables Object browsing / creation and deletion (6324)
  • Fix: (SQL Server 2014 or above) Improved Table Properties Display Problem (6324)
  • Add: (MariaDB 10.3+) support SEQUENCES object browsing / create and delete functions (6324)
  • Add: (MariaDB 10.2+) Support CHECK Constraints Object Edit / Browse / Create & Delete (6324)
  • Add: (Firebird 3) support PSQL Stored Functions object browsing / generation and execution functions (6316)
  • DATA IMPORT:
  • Upd: to increase the default value of the overtime, to avoid the problem that the batch setting value is large, the overtime problem occurs (6324)
  • Upd: Allows custom batch size settings (Options-> BatchSize) (6324)
  • Add: After the completion of the import, increase the number of skipped rows (Elipped time) and elapsed time (Elapsed time) and other information display (6316)
  • Displaying informational messages :
  • Fix: (64bit) (PostgreSQL) Fixed (6309) Problems with Reporting Errors and Messages (6324)
  • DATABASE MIGRATION:
  • Upd: All updates with dbMigration .NET Software (6324)

New in Database .NET Professional 21.5.6316.2 (Apr 18, 2017)

  • Main program update:
  • Upd: Data Import : Data Export : Increases the overall performance by 30% to 50% (6316)
  • Upd: Execute an SQL script file : Dramatically optimize batch processing speed (6316)
  • Fix: Improved re-targeting Firebird's path without immediate reboot (6316)
  • Data Import :
  • Add: After the completion of the import, increase the number of skipped rows (Elipped time) and elapsed time (Elapsed time) and other information display (6316)
  • Object Navigator :
  • Add: (Firebird 3) support PSQL Stored Functions object browsing / generation and execution functions (6316)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6316)

New in Database .NET Professional 21.5.6313.1 (Apr 14, 2017)

  • DATA IMPORT:
  • Add: support for different format date automatic conversion processing (6313)
  • Add: (Text) support UTF-16 format file import (including browsing) (6313)
  • Fix: (Text) Fixed UTF-8 File Import Problem (6313)
  • Upd: (Vertica) Dramatically Optimize and Improve Import Processing (6313)
  • Fix: Fixed an issue where the import failed to return to the original window (6313)
  • DATA EDITOR AND BROWSER:
  • Upd: Optimize Decimal data type display processing (including export processing) (6313)
  • MAIN PROGRAM UPDATE:
  • Fix: (Firebird) Fixed Firebird 3.0 In-Line Edition, [Not Initial] Added in the database [Test] function does not work properly (6313)
  • Fix: (Firebird) Fix Initialization Automatically specify Firebird default path problem (6313)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.0.1 (2016/12/16) (6313)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6313)
  • DATABASE MIGRATION - PRO:
  • Upd: All updates with dbMigration .NET Software (6313)

New in Database .NET Professional 21.4.6309.1 (Apr 10, 2017)

  • MAIN PROGRAM UPDATE:
  • Upd: (64bit) Target .NET Framework Upgrade from 4.5 to 4.5.2 (6309)
  • Add: Join BitArray datatype processing (with multiple related updates) (6309)
  • Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.105.0 (3.18.0) (2017/04/09) (6309)
  • Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.8.1.0 (2017/04/04) (6309)
  • Upd: (64bit) PostgreSQL Component Version Update to Npgsql.dll 3.2.2 (2017/03/21) (6309)
  • Upd: (64bit) MySQL Component Version Update to MySql.Data.dll 6.10.1 (2017/02/22) (6309)
  • Upd: (64bit) Teradata Component Version Update to Teradata.Client.Provider.dll 16.00.0.0 (2016/12/28) (6309)
  • Fix: Fixed (6295) caused (ODBC / OLEDB [Access / dBASE / FoxPro / Excel / Text]) database without SCHEMA can not normally get IndexColumn problem (6301)
  • Fix: Fixed window (Full Screen) reply, SQL editing window automatically zoom (6301)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6309)
  • Misc: compatible with Compatible with MySQL 8.0.1 (2017/03) / MySQL 5.7.18 (2017/03) / MySQL 5.6.36 (2017/03) / MySQL 5.5.54 (2016/11)
  • Misc: Compatible with Compatible with Teradata 16.0 (2016/04)
  • Misc: Compatible with Compatible with Microsoft Windows 10 RedStone 2 (1703)
  • GENERATING SCRIPTS:
  • Add: support VIEW dependencies INDEXES / TRIGGERS script generation and deletion (with TABLE) (6309)
  • INDEXES / TRIGGERS: SQL Server / SQL Azure
  • TRIGGERS: SQLite / Firebird / Informix / IBM DB2 / PostgreSQL / Sybase ASE / Oracle
  • OBJECT NAVIGATOR:
  • Fix: (Oracle / SQL Server / SQL Azure) Fix (6301) Causes INDEXED VIEW Not Displayed (6309)
  • Fix: (SQL Server / SQL Azure) Fix Check Constraints Browse Read, Resolve Compatibility Issues (6301)
  • Fix: (SybaseASE) Updates and Fixes Check Constraints / Triggers Browse Read Method (6301)
  • Upd: Add and update a large number of objects Reference URL (6301)
  • DATABASE MIGRATION:
  • Upd: All updates with dbMigration .NET Software (6309)

New in Database .NET Professional 21.3.6301 (Apr 2, 2017)

  • Main program update:
  • Fix: Fixed (6295) caused (ODBC / OLEDB [Access / dBASE / FoxPro / Excel / Text]) database without SCHEMA can not normally get IndexColumn problem (6301)
  • Fix: Fixed window (Full Screen) reply, SQL editing window automatically zoom (6301)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6301)
  • Misc: Compatible with Compatible with MySQL 8.0.1 (2017/03/23) / MySQL 5.7.17 (2016/11/29) / MySQL 5.6.35 (2016/11/29) / MySQL 5.5.54 (2016 / 11/29)
  • Object Navigator :
  • Fix: (SQL Server / SQL Azure) Fix Check Constraints Browse Read, Resolve Compatibility Issues (6301)
  • Fix: (SybaseASE) Updates and Fixes Check Constraints / Triggers Browse Read Method (6301)
  • Upd: Add and update a large number of objects Reference URL (6301)
  • Database Migration (Pro):
  • Upd: All updates with dbMigration .NET Software (6301)

New in Database .NET Professional 21.3.6295.1 (Mar 27, 2017)

  • MAIN PROGRAM UPDATE:
  • Upd: update the new version notification (New version notification), changed to non-pop-up notification mode (6295)
  • Upd: (Firebird) connection attribute CharSet allows the user to change the processing afterwards (initial automatic database coding) (6295)
  • Fix: (Firebird) Fixed a problem with the Statistics page in the Properties window (6295)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6295)
  • Misc: Database .NET ( Free / Plus ) and ( Pro ) are available on Chocolatey
  • Misc: Compatible with Compatible with Firebird 2.5.7 (2017/02/15) / Firebird 3.0.2 (2017/03/22)
  • OBJECT NAVIGATOR:
  • Fix: (OLEDB) Fixed View COLUMNS / INDEXES Unresolved if there was SCHEMA (6295)
  • Fix: (ODBC) Fix Browsing INDEXES Unspecified issue if there is SCHEMA (6295)
  • Fix: (SQL Server / SQL Azure) Fixed TRIGGERS issues that were not specified for SCHEMA when viewed and deleted (6295)
  • Fix: (SybaseASE) Fixed a problem where the resource was not immediately released after browsing the INDEXES object (6295)
  • Fix: (Firebird) Fixed CHECK Constraints Due to the number of fields specified Repeatedly displayed (including script generation) (6295)
  • Upd: Optimize the processing speed of the object when the table (TABLES / VIEWS) is expanded (6295)
  • Fix: Fixed system display> = 120DPI At the same time font size [non] Preset, display out of range problem (6287)
  • Fix: Fixed (6235) When the tree node font size [non] is preset, the problem is out of range (6287)
  • DATA IMPORT:
  • Upd: Improves the Import Process Error dialog box function that supports skipping all error column processing: (6287)
  • (Click [Yes] to skip all error rows), Click [No] to skip this error row), Click [Cancel] to exit
  • (Xls / xls to Excel and sql to new query window): only show the results to replace the original all the remittance (6287)
  • SQL HISTORY:
  • Upd: Excludes the history of the "Undefined Type" (6295)
  • DATABASE MIGRATION:
  • Upd: All updates with dbMigration .NET Software (6295)

New in Database .NET Professional 21.2.6287.57 (Mar 19, 2017)

  • MAIN PROGRAM UPDATE:
  • Fix: Fixed system display> = 120DPI At the same time font size [non] Preset, display out of range problem (6287)
  • Fix: Fixed (6235) When the tree node font size [non] is preset, the problem is out of range (6287)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6287)
  • DATA IMPORT:
  • Upd: Improves the Import Process Error dialog box function that supports skipping all error column processing: (6287)
  • (Click [No] to skip this error row), click [Cancel] to exit (Click [Yes] to skip all error rows)
  • (Xls / xls to Excel and sql to new query window): only show the results to replace the original all the remittance (6287)
  • DATABASE MIGRATION (PRO):
  • Upd: All updates with dbMigration .NET Software (6287)

New in Database .NET Professional 21.2.6281.1 (Mar 13, 2017)

  • DATA COLUMN EDITOR:
  • Updated: [SQL Server / SQL Azure / SybaseASE / VistaDB) support TIMESTAMP data type field (new and update) [synchronous update display] processing (6281)
  • Updating (Field) (update) when updating the (TIMESTAMP) data type (update) processing (6281)
  • Fix: (IBM DB2) Fixed TIMESTAMP Data Type Microsecond Length Problem (6281)
  • Fix: (Teradata) Fix TIMESTAMP Data Type Format Output Problem (with Export) (6281)
  • Fix: (Teradata) Fixed field where TIMESTAMP data type could not be added and updated (6281)
  • DATA EDITOR / DATA GRID BROWSER:
  • Upd: Automatically switch to Hex mode when setting content in binary and non-file format (6281)
  • TABLE DESIGNER:
  • Add: Right-click menu to add more features (same as working column) (6281)
  • Add: Add Shortcut Keys: Set PK Ctrl + K , Refresh F5 , Save Ctrl + S , Insert Ctrl + Ins , Delete Ctrl + Del (6281)
  • MAIN PROGRAM UPDATE:
  • Fix: Fix field (Icon and FK), when multi-column foreign key (6281)
  • Include: Object Navigator field icon and text, Table Designer field icon, database diagram, etc.
  • Add: Add Shortcut Keys: Move Up F3 , Move Down F4 (6281)
  • Including : script generator , Index Designer , Browsing / Edit Options, Table Designer ,
  • Upd: (FoxPro) automatically performs VFPOLEDB component registration repair processing, when the location is abnormal after the transaction (6281)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6281)
  • Misc: Compiled with Visual Studio 2017
  • DATABASE MIGRATION:
  • Upd: All updates with dbMigration .NET Software (6281)

New in Database .NET Professional 21.1.6268.1 (Feb 28, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: (PostgreSQL 9.1+) Add Extension objects : Show / Add / Delete / Script Generation ... and other functions (6268)
  • Upd: (TEXT) Increases the number of rows detected to improve the correctness of the detected field type (6268)
  • Upd: Improved Execution SQL Presentation Object Re-Brush (6268)
  • Upd: Optimize the processing speed of the object loading in the SQL References tab (6268)
  • Upd: (SQLite) Advanced Browsing Options : Modify OID System Field Detection (6268)
  • Fix: Fixed (6241) menu prompts to deal with problems that cause some functions to lose their function (6268)
  • Upd: Firebird component version update to FirebirdSql.Data.FirebirdClient.dll 5.8.0.0 (2017/02/23) (6268)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6268)
  • DATA EXPORT:
  • Add: add xls / xlsx to Excel ( Export the xls / xlsx file to open in Excel ) (6268)
  • Add: data column export format * .sql add sub-option (to a new query windows) (with the table to export) (6268)
  • Upd: Data Column Export Format * .xls / *. Xlsx provides a more detailed error message display (6268)
  • COMMAND LINE UPDATE:
  • Upd: Improved -ca + -f: parameter handling, omit object loading and dramatically increase processing speed (Note: not applicable * .lst) (6268)
  • Upd: Improved * .lst Batch Processing , Include Exception Processing Optional Continue or Cancel (6268)
  • SQL EDITOR:
  • Upd: Syntax highlighting Built-in Functions Color display processing (6268)
  • Upd: Improved batch command resolution for GO [count] and / (slash) (6268)
  • AUTOCOMPLETE AND INTELLISENSE:
  • Upd: clearly distinguish between built-in functions and general keywords (6268)
  • DATA COLUMN EDITOR:
  • Upd: Optimize No Master Key Column Update and Delete Processing (6268)
  • CODE MANAGER:
  • Upd: Raise the speed of the code object browsing (6268)
  • DATABASE MIGRATION:
  • Upd: All updates with dbMigration .NET Software (6268)

New in Database .NET Professional 21.0.6260.1 (Feb 20, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: (PostgreSQL 9.1+) support exclusion constraint object display, script generation and deletion ... and so on (6260)
  • Add: (Teradata) to join the MACRO object parameters (Parameters) display processing (6260)
  • Upd: (VistaDB / Informix) Exclude external index keys Object display with script generation (6260)
  • Upd: (SQLite / Teradata) Improved Multiple Fields Multiple-column foreign key Object Display Processing (6260)
  • Fix: (NuoDB) Fixed and updated multiple fields Multiple-column foreign key Object display with script generation (6260)
  • Upd: Add PACKAGES Object Heavy Brush (6260)
  • Upd: (SQL Server) How the update database is located (6260)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6260)
  • Misc: Compatible with Compatible with Firebird 2.5.7 (2017/02/15)
  • GENERATING SCRIPTS:
  • Add: (Teradata) joins MACRO object script generation and execution processing (6260)
  • Upd: (Teradata) Optimize DDL Format Output Processing (6260)
  • Upd: Update CHECK CONSTRAINTS Script Generation Issues (6260)
  • CONSTRAINT DESIGNER:
  • Fix: (Firebird) Fixed ON UPDATE, ON DELETE Unable to create a RESTRICT type (6260)
  • Fix: (IBM DB2) Remove ON UPDATE type CASCADE, SET NULL, etc. Invalid type setting (6260)
  • SQL HISTORY:
  • Upd: Search Results Synchronization Change SQL Statement Preview Processing (with SQL Profiler ) (6260)
  • Upd: Update List Content [Display] Processing , SQL Statementless Broken List Display (Contains SQL Profiler ) (6260)
  • Upd: Improve the list of content [search] processing , you can start the query (including SQL Profiler ) at the current location (6260)
  • AUTOCOMPLETE AND INTELLISENSE:
  • Updating Data Table Does Not Contain QuotedString Field Aware Processing Problem (6260)
  • SQL EDITOR:
  • Updix (6254) and then improve the SQL format to exclude IF problem (6260)
  • SQL FILE VERSION CONTROL MANAGEMENT:
  • Upd: Improved Feature Item Status Update (6260)
  • MY FAVORITES:
  • Upd: Add object to detect and exclude memory database and other processing (6260)
  • INDEX DESIGNER:
  • Fix: (Teradata) fixes the problem of missing new jobs (6260)
  • DATABASE MIGRATION:
  • Upd: All updates with dbMigration .NET Software (6260)

New in Database .NET Professional 20.9.6254.1 (Feb 14, 2017)

  • AUTOCOMPLETE AND INTELLISENSE:
  • Upd: Field Auto Sensing is more intelligent, dramatically reducing unnecessary perceived display processing while improving efficiency (6254)
  • JOIN + Space Automatically displays external index keys for reference, when displaying problems with no Alias ​​(6254). [FULL / INNER / LEFT / RIGHT / CROSS / NATURAL]
  • Upd: Improved improvements click on the right side of the space first non-text detection processing (6254)
  • Upd: Improve the resolution of Table + Alias ​​+ Keyword (6254)
  • DATA IMPORT:
  • Upd: Automatically remove the self-incrementing (IdentityColumn), eliminating the need for manual import processing (6254)
  • Upd: Increase field name Background color Clear distinction (NOT NULL) or not (6254)
  • Upd: Converts numeric type Decimal symbol: Displays the problem (Decimal symbol:.), Avoids misinterpretation of additional manual processing (same as import) (6254)
  • Select the query to the query generator ( Selected Text to Query Builder )
  • Upd: Improved Alias ​​+ Column Resolution (6254)
  • SQL EDITOR:
  • Upd: Improved SQL formatting control problem, excluding IF-THEN-ELSE Statement formatting (6254)
  • MAIN PROGRAM UPDATE:
  • Add: select the last object when connected after the new connection (6254)
  • Upd: The object name contains the handling of the exception character () (6254)
  • Upd: rewrite the system default [expand all nodes] shortcut * processing , only to the object itself is only fully developed (6254)
  • Upd: (Sybase ASE) Add InitializationString Connection Properties Settings, Script Tab (Script Tab) (6254)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6254)
  • Misc: Compatible with Compatible with PostgreSQL 9.6.2 / 9.5.6 / 9.4.11 / 9.3.16 / 9.2.20 (2017/02/09)

New in Database .NET Professional 20.8.6248.1 (Feb 8, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: (PostgreSQL 9.3 + / Oracle) MATERIALIZED VIEW to add Indexes object browsing, build and script generation (6248)
  • Add: (SQL Server 2005 + / SQL Azure) Add Index View Table (INDEXED VIEW) Browse, Build, and Script Generation Processing (6248)
  • Add: (Oracle) Browse [All] Database Schema ( Browsing all databases ): Add MATERIALIZED VIEW Object Display (6248)
  • Upd: (Oracle) Table Object Node Elimination of MATERIALIZED VIEW, USLOG $, etc. Object Display (6248)
  • Upd: (Oracle) Exclude Self- Generating System Index Displays, Avoiding Duplicate Processing (6248)
  • Fix: Removes VIEWS object node Unnecessary right-click menu item ( Data Import ) (6248)
  • (6235) the original '.' To '_' conversion, to avoid the extension of other issues (6248), to avoid the problem,
  • Upd: VistaDB component version is updated to VistaDB.5.NET40.dll 5.5.3 (2017/02/03) (6248)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Tuning (6248)
  • GENERATING SCRIPTS:
  • Add: Add objects such as INDEXES / TRIGGERS Right-click menu SCRIPT AS script generation processing (6248)
  • Fix: (Oracle) Fixed MATERIALIZED VIEW Script Creation (6248)
  • TABLE DESIGNER:
  • Upd: Allowed data table Length (Data Type Length) Post-change processing (6248)
  • DATA EDITOR AND BROWSER:
  • Upd: (ODBC) Improved access to data table data (DataRow), adding more exception handling (6248)
  • Upd: Improved access to field data type (DataType), when GetSchemaTable can not return normally (6248)
  • Upd: (SQL Server / SQL Azure) Update Geography / Geometry / HierarchyId and other data types to read the problem (6248)
  • SEARCH TABLE DATA:
  • Upd: Update the data type of searchable fields (6248)
  • DATABASE MIGRATION (PRO):
  • Upd: All updates are the same as dbMigration .NET Software (6248)

New in Database .NET Professional 20.7.6241.1 (Feb 1, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: Windows Title Add Object Icon Display (6241)
  • Add: Support batch processing of [single-row non-GO], enabling batch processing of repositories that do not support batch commands (6241)
  • Upd: non-fixed date data type to increase the length of the display (including script generation) (6241)
  • Upd: (Firebird) Adds VIEWS / PROCEDURES without source display (6241)
  • Upd: (NuoDB) Update data type (Decimal / Numeric) Maximum length setting (6241)
  • Upd: Auto-zoom the width of the library drop-down menu on the taskbar (6241)
  • Upd: to improve the right-click menu [main] option and the [sub] option prompt message, switch to avoid the display (6241)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimization (6241)
  • GENERATING SCRIPTS:
  • Add: (SQL Server 2008 + / SQL Azure) Support for Sparse Columns and Column Sets Script generation (6241)
  • Add: (SQL Server 2016 + / SQL Azure) Support for Generated Always Columns script generation (6241)
  • Upd: (SQL Server / SQL Azure) Processes encrypted objects instead of generating prompts instead of prompting dialogs (6241)
  • Fix: (Oracle) Fixed an issue (6241) that caused the table index name (INDEX name) to be incorrectly generated (6241)
  • Fix: Fixed Expression Columns generation, avoid adding unnecessary QuotedString displays (6241)
  • DATA EDITOR AND BROWSER:
  • Upd: (Informix) supports TEXT data type (blob) data type processing (6241)
  • Upd: (OData) Execution Time to Increase Execution Time (6241)
  • TABLE AND VIEW OBJECTS LIST:
  • Upd: Optimizing Exception Handling and Updating Titles after Object Deletion (6241)
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software (6241)

New in Database .NET Professional 20.6.6235.1 (Jan 26, 2017)

  • Main program update:
  • Upd: Add the `mysql_native_password` failed exception message to resolve the MySQL Connector / NET connection problem
  • Add: Execute an SQL script file : Add a complete Comments filter
  • Upd: Improved single-line comment syntax to automatically convert '-' to '-' to conform to partial repositories (eg MySQL) to avoid execution failures
  • Upd: Improved file output name Exception character conversion '.' To '_' Avoiding the display of the file extension
  • Upd: Improve the SQLite memory database establishment, the exclusion to the connection list processing
  • Add: Close Tabs ( Ctrl + W , including the original Ctrl + F4 , Middle-Click )
  • Upd: Update Custom Font Size Set the maximum value (from 10 to 11)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations
  • Table and View objects list :
  • Add: Deleting multiple selected objects
  • Upd: Support for MySQL 8.0+ Object Comments
  • SQL Editor :
  • Add: Join this [non-GO] batch instruction processing to increase processing speed while avoiding oversized issues that cause exceptions
  • Upd: Fixed an issue that could not be used with the TabIndent setting when setting ConvertTabsToSpaces = True
  • Fix: Fixed a problem when the file is changed outside the environment after the first save
  • Object authorization management function ( Grant Manager ):
  • Add: (MySQL 8.0 + / MariaDB 10.0.5+) ROLE support for the role of object licensing management
  • Add: (MySQL) Object TABLE OR VIEW Add TRIGGER privilege setting
  • Add: (NuoDB) Join the SEQUENCE object permission setting
  • Security Manager :
  • Add: (MySQL 8.0 + / MariaDB 10.0.5+) support ROLE role of objects and rights management (v)
  • Fix: (MySQL) Fix Permission Item CREATE VIEW / SHOW VIEW Problem Setting Unusually
  • Connection Process Manager ( Connection Process Manager ):
  • Add: Support for Firebird connection removal (Kill connections)
  • SQL history records ( SQL History ):
  • Upd: Exclude Execution Statements for SQL Statements such as INSERT / DELETE / UPDATE SQL Profiler ( with LOG Profiling for SQL Profiler )
  • Code Manager :
  • Upd: Improved synchronization of node prompts when file changes
  • Database Migration (Pro):
  • Upd: All updates are the same as dbMigration .NET Software

New in Database .NET Professional 20.5.6222.0 (Jan 13, 2017)

  • MAIN PROGRAM UPDATE:
  • Upd: Execute an SQL script file : Join [non-GO] batch processing to improve processing speed and solve the problem of processing large files failed (6222)
  • Upd: (32bit) SQLCe v3.5 component version update to SQL Server Compact 3.5 SP2 hotfix (3.5.8109.0) (6222)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimization (6222)
  • DATA IMPORT:
  • Add: Support for importing XML format (6222)
  • Fix: Fixed the problem of importing processing in [Preview Mode] in [Edit Data Column] (6222)
  • Fix: Fix display problem when preview mode is finished (6222)
  • DATA EXPORT:
  • Add: Support for exporting data to Markdown format (6222)
  • Upd: Update XML data format export processing: Format BLOB data types (with other format types) (6222)
  • GENERATING SCRIPTS:
  • Add: (SQL Server 2014 + / SQL Azure) Support for Memory-Optimized Tables script generation (6222)
  • (CLUSTERED | NONCLUSTERED) Cluster Type Display (6222) Added : (SQL Server 2012 + / SQL Azure) Added PRIMARY KEY [CLUSTERED |
  • INDEX DESIGNER:
  • Add: (SQL Server 2012 + / SQL Azure) Support for rowstore index build and script generation (6222)
  • Fix: (SQL Server / SQL Azure) Fixes (5959) Included Columns Problem with Initial Order and Field Order (6222)
  • DATA BROWSER:
  • Upd: Displaying results in text ( Results to Text ): Displaying output in Markdown format (with textual execution plan) (6222)
  • DATABASE MIGRATION (PRO):
  • Upd: All updates with dbMigration .NET Software (6222)

New in Database .NET Professional 20.4.6211.1 (Jan 2, 2017)

  • MAIN PROGRAM UPDATE:
  • Add: (Pro 64bit) Added full support VistaDB database ( Full Support for VistaDB ) (6211)
  • Add: (ODBC / OleDB) add structural object name Description Name Display ( Objects the with Schema name ) (6211)
  • Add: (Access / SQLite / SQLCe / VistaDB) direct support to establish an encrypted database features ( Creating AN ENCRYPTED Database ) (same SQLCe) (6211)
  • Upd: (DB2 / Informix) increased database load process AccessViolationException exception retry processing (6211)
  • Fix: Fixed some database connection after the establishment of the type, if you choose not to open it will not appear immediately on the list of connection problems (6211)
  • Upd: optimize the detection and release of interrupt processing Interconnect (6211)
  • Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.1010.4) (2016/12/16) (6211)
  • Misc: (the IBM the DB2 / the Informix) the IBM the Data Server Client Packages Standard Package Version 11.1 Fix Pack 1 (2016/12/16)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6211)
  • ROW EDITING AND BROWSING:
  • Fix: (ODBC) to solve [Text Type] field if it is to read the data when NULL, resulting in abnormal problem of slow input (including export and other related processing) (6211)
  • Upd: optimizing data updating process, when there is no primary key (PKs) and the field is defined as NOTNULL time (6211)
  • TABLE EDITOR:
  • Add: Create table syntax validation process increases ( Syntax for Creating the Validation A new new the Table ) (6211)
  • Upd: When the table for redevelopment, increase [referenced] detection process (6211)
  • THE INSTRUCTION CODE GENERATION:
  • Fix: (Oracle) correction (6 ???) causes the data to generate a table definition, unnecessary display problems (OR REPLACE) keyword (6211)
  • Fix: External key index syntax NONE automatically converted to NO ACTION (6211)
  • DATA EXPORT:
  • Upd: Improved (6199) File Format Export Processing: When canceled after the specified export file name is no longer for subsequent processing (6211)
  • AUTOMATICALLY AND PERCEPTION:
  • Upd: (Oracle) View next [all] support structure describes the structure of the default view described in the table under the SYS (V $ VIEWS) auto-sensing process (6211)

New in Database .NET Professional 20.3.6199.1 (Dec 21, 2016)

  • MAIN PROGRAM UPDATE:
  • Upd: configuration changes to improve the security of software compatibility (6199)
  • Upd: (Informix) updated Boolean field detection method, processing is performed to optimize the efficiency of SQL statements (6199)
  • Upd: Improved exception handling Message: Upon completion of the implementation of the object release but failed (6199)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6199)
  • Upd: SQLite element updated to System.Data.SQLite.dll 1.0.104.0 (3.15.2) (2016/12/16) (6199)
  • Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.7.0.0 (2016/12/12) (6199)
  • Misc: the with Compatible the MySQL 8.0.0 (2016/09/12) / the MySQL 5.7.17 (2016/11/29) / the MySQL 5.6.35 (2016/11/29) / the MySQL 5.5.54 (2016 / 11/29)
  • DATA EXPORT:
  • Upd: Export optimization approach: boost export processing speed while reducing memory consumption (6199)
  • Add: execution results Archive (Results to File): supports multiple outputs the result (Multiple Results) (6199)
  • Add: execution results Archive (Results to File): increase the display message tab (Messages Tab) (6199)
  • Add: file format export process, support interrupt handling (6199)
  • Upd: File format export process, changed to specify in advance the export file name before handling (6199)
  • Fix: (Informix) export format INSERT statement scripts (* .sql) Fixed Boolean data type generation problems (6199)
  • BROWSE ROW:
  • Add: Support Export Processing Data Grid View next ( the Cell Viewer: the Export to File ) (6199)
  • THE CONNECTION SETTINGS:
  • Upd: adding different bits (32 / 64bit) Oracle Instant Client version detection, avoid improper use causes an exception occurs (6199)
  • DATABASE MIGRATION:
  • Upd: Updated with all dbMigration .NET Software (6199)

New in Database .NET Professional 20.2.6185.1 (Dec 7, 2016)

  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Upd: optimized database object loaded into the processing speed of the tree nodes can improve the overall 30% (6185)
  • Add: increase in heavy brush all child objects option ( the Refresh All Objects ) (6185)
  • Add: Add the heavy brush and database schema list right-click menu ( the Refresh Database Schema and List ) (6185)
  • Fix: (Teradata) correction analysis query (Parse Query) after executing object resource release problems (including Binding dialog box test) (6185)
  • Fix: (SQL Server / SQLAzure / SybaseASE) amended [schema using the object name as the object of the preposition] settings, with the exception of characters deal with related issues (6185) (.)
  • Fix: (Pro 64bit) removed no longer supported (32bit) library function menu (6185)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6185)
  • ROW EDITING AND BROWSING ( the Data Editor and Browser ):
  • Add: Added full windows showed ( Full Screen Results ) (6185)
  • Upd: Add the full prompt message shortcut keys: Contains (Filter this column / Select this column / Open cell and row / Edit cell) (6185)
  • Fix: Display should return data shows the number of rows exceeds ( the Maximum Number of rows to answer the display ): Fixed issues with progress dialog window displayed simultaneously (6185)
  • TEXT OF THE PLAN OF IMPLEMENTATION ( Plain the Execution Plan ):
  • Upd: (Pro 64bit) SQL Server 2000 to change the execution plan text display process (6185)
  • Fix: Fixed return contains two-character language (DBCS) characters, the program can not proceed normally cause problems processing (6185)
  • SQL EDITOR ( the SQL Editor ):
  • Upd: Optimizing Queries tab (Query Tab) and new switching processing speed, significantly reducing the impact of a relatively large amount of time objects (6185)
  • Upd: Fixed jump to the next word shortcuts (Char Right: Ctrl + Right) : If we are to resolve when clicking will continue to repeat the last line of questions at the end of (6185)
  • Upd: Change the execution plan shows the shortcut keys (Execution Plan: Ctrl + F6) : Shortcuts to resolve duplication (6185)
  • DATA EXPORT ( the Data the Export ):
  • Upd: Improved JSON export file format Changduoxianzhi (> 4MB) Issues (6185)
  • THE CONNECTION SETTINGS ( the Connection Profile ):
  • Upd: resolve when IBM DATA SERVER DRIVER under execution connection (DB2 / Informix) is not installed, the program leads to abnormal exit problem (6185)
  • DATABASE MIGRATION ( Database Migration )L
  • Upd: Updated with all dbMigration .NET Software (6185)

New in Database .NET Professional 20.1.6176.2 (Nov 28, 2016)

  • Automatically and perception ( the AutoComplete and IntelliSense):
  • Fix: Fixed (6151) Effect of SELECT FROM [field] sensing range of issues (6176.2)

New in Database .NET Professional 20.1.6176.1 (Nov 28, 2016)

  • THE MAIN PROGRAM UPDATED ( the Main ):
  • Add: increase MySQL 8.0 support database system to solve PROCEDURE / FUNCTION / INDEX and other compatibility issues (6176)
  • Add: Browse items increased sub-function key when a message prompts (Tooltip) process, facilitate more aware of their functional properties (6176)
  • Add: increase conversion cursor (Cursor) Object Browser item when dealing with sub-functions, to facilitate more intuitive and precise click-function items (6176)
  • Upd: remember the last selected database (non-default), next time when you turn directly without further selection switch (see all the same database mode) (6176)
  • Upd: Updated interface Russian language Russian language (by Alexey Yakovlev) ( 6176)
  • Fix: Connection settings ( the Connection Profile ): Fixed an exception error message attribute set display problems (6176)
  • Fix: Problems on the left portion of the tree nodes function can not be displayed under amendments WinXP Environment (6176)
  • Upd: Improved exception handling starts when you read the settings file (6176)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6176)
  • MANAGEMENT CODE:
  • Upd: SQL File Version Control Manager ( Version Control Manager ): Save the original function LOG log file, change the Save selected to replace SQL log file (6176)
  • Fix: Fixed file name contains (...) issues when characters not properly handle related functions (including the title name, save files, etc ...) (6176)
  • Fix: Fixed Code Treeview is not completed before reading can not be performed in the SQL Editor [Save] or [renamed] Problems (6176)
  • SQL EDITOR:
  • Add: increase the automatic recognition ( Auto the Commit ) to the right-click menu (6176)
  • Add: increase automatically recognized shortcuts ( the Toggle AutoCommit the On / Off : the Ctrl +. 9) (6176)
  • DATA EXPORT:
  • Add: Export format INSERT statement scripts (* .sql) to increase the output page features a new query ( Generating INSERTs to new new Query window ) (6176)
  • DATABASE MIGRATION:
  • Upd: Updated with all dbMigration .NET Software (6176)

New in Database .NET Professional 20.0.6165.1 (Nov 17, 2016)

  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Upd: (PostgreSQL) Advanced browser ( Advanced Browsing the Options ): added field displays the complete system ( the System Columns ) (6165)
  • Add: (Firebird) increase SYSTEM SEQUENCES display objects (6165)
  • Fix: (Firebird) Correction (6151) database connection password characters exception handling, reference issues affect the default password (6165)
  • Fix: (MySQL) correction can not get MySQL 5.1 or above table outside key index (FKs) problems (affecting contain related functions) (6165)
  • Upd: (SQLite) data table editor ( the Table Designer ): Updated field type DECIMAL / NUMBER Zhangduxianzhi (preset 15,0) (6165)
  • Fix: (FoxPro) can not be amended to delete the external table index key (FKs) Issues (6165)
  • Upd: Data Export ( the Data the Export ): Advanced format output increased Filtered input option (Filter Expression) (6165)
  • Upd: search and replace function ( Quick the Find and the Replace ): Enter the search process to automatically locate the nearest location (6165)
  • Fix: solve the problem when the operating environment settings area and language (Turkish (Cyprus)) language, not fully normal use (6165)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6165)
  • Misc: the with Compatible the SQL Server 2016 SP1 (2016/11/15)
  • THE INSTRUCTION CODE GENERATION ( Generating the Scripts ):
  • Add: (SQL Server 2016+) supports Temporal Tables table generates a display related properties (6165)
  • Add: (Firebird 2.1+) support CREATE GLOBAL TEMPORARY TABLE table generates a display (6165)
  • Add: (PostgreSQL) support table attributes WITH OIDS generates a display (6165)
  • Upd: (MySQL) table coding changed to where the main repository database encoding to set the encoding supplement (6165)
  • Fix: (FoxPro) Correction AutoInc if [non-arranged in the first field or primary key] problem can not be properly made (6165)
  • Upd: CRUD stored procedure generation processing ( CRUD the Stored Procedures ): to change the field name as a parameter name (6165)
  • DATABASE MIGRATION ( Database Migration ) (Pro):
  • Upd: Updated with all dbMigration .NET Software (6165)

New in Database .NET Professional 19.9.1651.1 (Nov 3, 2016)

  • THE INSTRUCTION CODE GENERATION ( Generating the Scripts ):
  • Add: increase CRUD stored procedure generation processing ( CRUD the Stored Procedures )
  • Support databases include: SQL Server / SQLAzure / Oracle / MySQL / PostgreSQL / Access / Firebird
  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Add: increase JOIN + Space key index automatically display external reference ( the Automatically List Foreign Key References )
  • Upd: Update JOIN + Space table automatically sensing range (1 to 5)
  • ROW EDITOR ( the Data Editor ):
  • Upd: Allow BLOB fields with read only field set to null process (Set it As NULL)
  • BROWSE ROW (the Data Browser ):
  • Upd: text display the results ( the Results to the Text ): display dramatically improved processing speed and exception handling
  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Add: (PostgreSQL) Support Functions / Packages object returned data set is displayed ( the Displaying REFCURSOR Results )
  • Upd: Database connection password characters join exception handling
  • Upd: Correction and Update CREATE PROCEDURE script generation model
  • Upd: Improved Quoted Identifiers Remedy: Cancel the beginning of the text object (or ending) process
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.6.0.0 (2016/11/02)
  • Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.9 (2016/10/24) (6151)
  • Misc: the with the PostgreSQL Compatible 9.6.1 / 9.5.5 / 9.4.10 / 9.3.15 / 9.2.19 (2016/10/27)
  • DATABASE MIGRATION ( Database Migration ) (Pro):
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 19.8.6141.3 (Oct 24, 2016)

  • TEXT OF THE PLAN OF IMPLEMENTATION ( Plain the Execution Plan ):
  • Add: Support MS Access execution plan shows ( the Execution Plan for MS Access [!] ) ( Features Exclusive ) (6141)
  • Add: Support IBM Informix execution plan shows ( the Execution Plan for IBM Informix ) ( Features Exclusive ) (6141)
  • Add: Support NuoDB execution plan shows ( the Execution Plan for NuoDB ) (6141)
  • Upd: rewrite SQL Server / SQL Azure execution plan text display ( the Execution Plan for the SQL Server, the SQL Azure and LocalDB ) (6141)
  • SELECTED QUERY CRITERIA TO THE QUERY GENERATOR ( the Selected to the Text Query Builder )
  • Upd: Improved question contains comments (Comment) when not properly handled when the selection (6141)
  • Upd: Improved When TOP with (), the effect of the first field selected issues (6141)
  • BROWSE ROW ( the Data Browser ):
  • Upd: text display the results ( the Results to the Text ): update content formatting, line breaks (CrLf) and anchor (Tab) blank (Space) substituted characters (6141)
  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Upd: Perception lifting speed: add more aware processing to detect invalid (6141)
  • Upd: to enhance the perception Speed: field perception Ruoyi named table will not receive additional table fields (6134)
  • Upd: optimization SubSelect field perception and position data table (6134)
  • Fix: Fixed Schema shorter than resolve the problem of 3:00 (6134)
  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Add: increase in custom delimited text file filename extension update feature replaces the manual process ( the Custom Delimited File Extensions ) (6134)
  • Fix: Fixed connection list on the left, right-click menu disable status update issues at different operating (6134)
  • Fix: Fixed table data export options ( the Data the Export ), the problem can not be recovered after the disable status display canceled (6141)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6141)
  • Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.8 (2016/10/20) (6141)
  • Misc: the with Compatible the MySQL 5.7.16 (2016/10/12) / the MySQL 5.6.34 (2016/10/12) / the MySQL 5.5.53 (2016/10/12)
  • GENERATE SCRIPT ( Generating the Scripts ):
  • Fix: Fixed (5959) to generate table index, if this field while Auto Increment, will not produce the index field issues (6134)
  • DATABASE MIGRATION ( Database Migration ) (Pro):
  • Upd: Updated with all dbMigration .NET Software (6134)

New in Database .NET Professional 19.7.6134.2 (Oct 17, 2016)

  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Upd: to enhance the perception Speed: field perception Ruoyi named table will not receive additional table fields
  • Upd: optimization SubSelect field perception and position data table
  • Fix: Fixed Schema shorter than resolve the problem of 3:00
  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Add: increase in custom delimited text file filename extension update feature replaces the manual process ( the Custom Delimited File Extensions ) (6134)
  • Fix: Fixed connection list on the left, right-click menu disable status update issues at different operating (6134)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6134)
  • Misc: the with Compatible the MySQL 5.7.16 (2016/10/12) / the MySQL 5.6.34 (2016/10/12) / the MySQL 5.5.53 (2016/10/12)
  • DATA DEFINITION LANGUAGE ( the Data Definition! Language (the DDL) ):
  • Fix: Fixed (5959) to generate table index, if this field while Auto Increment, will not produce the index field issues
  • DATABASE MIGRATION ( Database Migration ) (Pro):
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 19.6.6118.1 (Sep 30, 2016)

  • The main program update ( the Main ):
  • Add: Support Firebird 3+ show complete implementation plan ( the Execution Plan for 3 or later The Firebird ) (6118)
  • Fix: (Firebird) Correction (6109) result that has been set Embedded Server / Remote Type settings such useless questions (6118)
  • Upd: Improved Message dialog text display limitations (

New in Database .NET Professional 19.5.6109.1 (Sep 22, 2016)

  • MAIN PROGRAM UPDATE:
  • Add new Firebird database-specific connection settings ( New Firebird Connection Profile )
  • Add: Support Windows login authentication mode (Windows authentication (Win_Sspi))
  • Add: Support for individual library to a different user account login process
  • Add: Support Custom Port Settings
  • Add: Support Connection test process
  • Upd: additional connection property is set far more intuitive
  • Upd: Merge Local and Remote settings to simplify the processing
  • Upd (Firebird) database coding automatic setting processing (Automatically set charset): supports remote database (Remote database) detection process
  • Upd: (Oracle) update DBMS_OUTPUT outgoing messages and displays the number of columns limit from 16-1024
  • Upd: Oracle component version update to Oracle.ManagedDataAccess.dll 12.1.24160719 (2016/09/17)
  • Upd: SQLite element updated to System.Data.SQLite.dll 1.0.103.0 (3.14.2) (2016/09/15)
  • Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.1.1.0 (2016/09/13)
  • Upd: SQLCe v4 elements updated to the SQL Server Compact 4.0 SP1 Hotfix (4.0.8902.1) (2014/06/10)
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Upd: Optimization table analysis processing to enhance the field perception
  • DATABASE MIGRATION (Pro):
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 19.4.6099.1 (Sep 12, 2016)

  • SECURITY ADMINISTRATOR (DATABASE TOOLS: SECURITY MANAGER):
  • Add: Added user authorization process ( Managing the User the Permissions ): Support comprises: SQL Server / MySQL / Oracle / PostgreSQL / Firebird 3.0 + / IBM DB2
  • Add: Added role permissions setting process (Managing Role Permissions): Support comprises: IBM DB2
  • Add: Join a user password to change the setting (Changing Password): Support comprises: SQL Server / MySQL / Oracle / PostgreSQL / Teradata / Vertica / NuoDB / Firebird
  • Add: Join the user's password expiration settings (Password Expiration): Support comprises: SQL Server / MySQL 5.7.6 + / Oracle 12 + / PostgreSQL / Vertica
  • Add: support more users lock setting (Account locking): Support comprises: SQL Server / MySQL 5.7.6 + / Oracle / PostgreSQL / Vertica / SybaseASE
  • THE MAIN PROGRAM UPDATE:
  • Upd: Database Tools (Database Tools): Move to the previous menu and the main task bar, display more intuitive and simpler operation
  • Add: (Firebird) support to bind parameter function execution process ( the Binding the Parameters Function )
  • Upd: (Firebird) resumes execution function (FUNCTION) instruction code generation ( SCRIPT the AS -> the SELECT )
  • Upd: (ODBC / OleDB) script generates multiple right-click menu disable status update
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Misc: the with Compatible the MySQL 5.7.15 (2016/09/06) / the MySQL 5.6.33 (2016/09/06) / the MySQL 5.5.52 (2016/09/06)
  • Misc: the with Compatible the HP Vertica 8.0 (2016/09/10)
  • SQL HISTORY RECORDS:
  • Add: increase untyped (Undefined Type) manually clear the historical record processing
  • Upd: Update not performed tag [after Close] to save the process, are excluded from the [External File] to open the content in order to reduce unnecessary treatment record
  • DATA DEFINITION LANGUAGE:
  • Upd: (MySQL) table object is generated (TABLE): Reset attribute AUTO_INCREMENT = 1
  • Fix: (Firebird) function to generate the object program (FUNCTION / PROCEDURE): Take solve change when VARCHAR does not include the length of the field Length Shows
  • Fix: (Firebird) function generates object (FUNCTION): Fixed CHARACTER SET is not fully correct the problem specified
  • Upd: (Firebird) program generates object (PROCEDURE): increase in the processing and DEFAULT CHARACTER SET's
  • DATABASE MIGRATION (PRO):
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 19.3.6087.1 (Aug 31, 2016)

  • DATABASE MIGRATION (PRO):
  • Upd: Updated with all dbMigration .NET Software
  • MANAGEMENT CODE:
  • Add: Custom SQL file location ( the Specifying at The LOCATION of SQL Files ): support the specified SQL file location
  • MAIN PROGRAM UPDATE:
  • Add: (ODBC / OleDB) increase function object (FUNCTIONS): with a view / perform other functions ...
  • Fix: When (ODBC / OleDB) If the amended database contains SCHEMA (VIEWS / PROCEDURES) and other objects loaded incomplete question
  • Fix: (FoxPro) to solve the data table contains time increments (AUTOINC) field-related issues: with a table reconstruction and data export functions ...
  • Add: (SQL Azure 12) increase the sequence object (SEQUENCES): with a view / execute / delete / script generation ... and other functions
  • Upd: (SQL Azure 12) updates object (PROCEDURES) script generation and execution process: Increase the return value display processing
  • Upd: (SQL Server / SQL Azure ) supports the table value function object (TABLE-VALUED FUNCTIONS) script generation and execution process
  • Fix: Fixed in the next multi-screen apps open part of the main sub-functions in a non-main window, the problem will still be displayed in the main window
  • Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.1.0.0 (2016/08/29)
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • DATA DEFINITION LANGUAGE:
  • Upd: (SybaseASE) script to generate VIEWS / TRIGGERS / PROCEDURES / FUNCTIONS other objects match the name of [schema] [objectname] is displayed
  • Fix: This update to resolve joint name of the original object within the definition of inconsistencies due to renamed objects

New in Database .NET Professional 19.2.6079.1 (Aug 23, 2016)

  • MAIN PROGRAM UPDATE:
  • Fix: Fixed (6078) after the update cause exceptions (*
  • Add: increase substituted row ( the Replace the In the Grid ): Batch replace data cell data (Batch replacing cell values)
  • Upd: Improved search row ( the Find the In the Grid ): change the current location as the starting point of search
  • Upd: (Oracle) objects to perform [automatic identification] with the need SchemaName treatment can avoid ORA-06550 / PLS-00302 error problem
  • Upd: Improved connection settings ( the Connection Profile ): support for more databases and more complete connection Property Description
  • Upd: Improved uncomment (Uncomment): 1. Support multi-line annotations /*...*/ cancellation process, 2. Improved single-line comments - the cancellation process, when the starting character is empty
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • ADVANCED VIEW / EDIT OPTION ([ADV] Advanced Browsing / the Edit the Options):
  • Fix: automatically ( Auto Completion ): Fixed field names exactly matching process
  • QUERY DESIGN TOOLS ( Query Builder )
  • Fix: Automatic correlation table added: Fix field names exactly matching process
  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Fix: Fixed table, fields, keywords, etc. name exactly matching process
  • DATA DEFINITION LANGUAGE ( the Data Definition! Language (the DDL) ):
  • Fix: (SQL Server / SQLAzure / SybaseASE) Fixed index UNIQUE + NONCLUSTERED, the resulting omissions UNIQUE key issues
  • DATABASE MIGRATION Database Migration ) (Pro):
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 19.1.6068.1 (Aug 12, 2016)

  • AUTHORIZATION OBJECT MANAGEMENT CAPABILITIES:
  • Add: Support SQL Server 2000 Authorization Manager objects: TABLE / VIEW / PROCEDURE / FUNCTION
  • Add: Support SybaseASE object Authorization Manager: TABLE / VIEW / PROCEDURE / FUNCTION
  • Add: Support Teradata objects Authorization Manager: TABLE / VIEW / PROCEDURE / FUNCTION / MACRO
  • Add: Support NuoDB object Authorization Manager: TABLE / VIEW / PROCEDURE / FUNCTION
  • Add: Support HP Vertica object Authorization Manager: TABLE / VIEW / SEQUENCE Add: Authorization Manager supports IBM Informix objects: TABLE / VIEW / PROCEDURE / FUNCTION / SEQUENCE (6068)
  • Add: Authorization Manager supports IBM DB2 objects: TABLE / VIEW / PROCEDURE / FUNCTION
  • fix: Problems unspecified sources Db (6068) when (MySQL) amended to read object permissions
  • Upd: (Firebird / Oracle) increased USER: PUBLIC default user permissions treatment
  • Fix: (PostgreSQL) correction can not (FUNCTIONS / PROCEDURES) of [Search Add] and [individual designated] Issue permission settings
  • Add: increase the effectiveness of detecting movement when permissions are configured to provide a more intuitive message display
  • Contains full support for SQL Server / SQL Azure / Firebird / MySQL / PostgreSQL / Oracle / IBM DB2 / Informix / SybaseASE / NuoDB / HP Vertica / Teradata database, etc.
  • SECURITY ADMINISTRATOR:
  • Fix: (NuoDB) to solve new user (User) when the batch command (GO) problem can not be executed
  • DATA DEFINITION LANGUAGE:
  • Problem (HP Vertica) Fixed script generation FUNCTION missing ")" in (6068): Fix
  • THE MAIN PROGRAM UPDATE:
  • Upd: (IBM DB2 / Informix) dramatically PROCEDURES / FUNCTIONS object browser loading processing speed
  • Add: (NuoDB) function increases object processing (FUNCTIONS): contains browse / execute / delete / script generation ... and other functions
  • Fix: completely solve the problem on the left to display the object heavy brush exception, when the content is not currently in heavy brush tab exception
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Misc: Compatible with Microsoft Windows 10 redstone

New in Database .NET Professional 19.0.6063.77 (Aug 8, 2016)

  • AUTHORIZATION OBJECT MANAGEMENT CAPABILITIES:
  • Add: Authorization Manager supports IBM DB2 objects: TABLE / VIEW / PROCEDURE / FUNCTION
  • Add: increase the effectiveness of detecting movement when permissions are configured to provide a more intuitive message display
  • Upd: (Firebird) increased USER: PUBLIC default user permissions handling
  • Fix: (PostgreSQL) correction can not (FUNCTIONS / PROCEDURES) of [Search Add] and [individual designated] Issue permission settings
  • MAIN PROGRAM UPDATE:
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Misc: Compatible with Microsoft Windows 10 redstone

New in Database .NET Professional 19.0.6059.1 (Aug 3, 2016)

  • MAIN PROGRAM UPDATE:
  • Add: (Pro) new authorization object management capabilities ( Grant Manager )
  • Supports all types of objects, add support search processing, support individual designated processing, greatly simplify the problem of object permissions
  • Support contains SQL Server / SQL Azure / Firebird / MySQL / PostgreSQL / Oracle and other database
  • Fix: Fixed screen resolution> = 4K and> = 250% environment, when you start cause display problems (6059) exception occurs
  • Upd: (Oracle / Firebird 3) Resolution (6015) led to suite object (Packages) loading too slow display problem (
  • Fix: (Firebird) Fixed remote connections can not use a non-default account connection problems
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Upd: Update Files Additional .NET Database ( 32bit / 64bit ) (2016/07/30)
  • Misc: the with Compatible the MySQL 5.7.14 (2016/07/29) / the MySQL 5.6.32 (2016/07/29) / the MySQL 5.5.51 (2016/07/29)
  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Upd: inserting an object no longer contains Quoted Identifiers, changed to automatically determine whether the exception processing characters (6059)
  • Fix: resolve quickly enter and click F5 to execute, the display of unnecessary problems
  • SQL EDITOR:
  • Fix: Fixed multi-line comments /*...*/, if one batch command GO, / issue that causes part of the database can not be processed normally
  • TABLE EDITOR:
  • Upd: (MySQL) New encoding table change to take character-set-server instead of the default character-set-database library encoding
  • ROW EDITING AND BROWSING:
  • Add: Support the field data type is System.Object (Date / String / Numeric) content is displayed as text and date digital processing
  • DATABASE OBJECT SEARCH:
  • Fix: Fixed If via shortcuts Enter or Ctrl + E when the input, resulting in repeated thereby affecting search speed
  • DATABASE MIGRATION:
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 18.9.6040.1 (Jul 15, 2016)

  • MAIN PROGRAM UPDATE:
  • Add: (Firebird) support single-dimensional array, multi-dimensional arrays data type is displayed with the relevant processing
  • Add: (PostgreSQL) support multi-dimensional arrays data type is displayed with the relevant processing
  • Add: (PostgreSQL) support bigserial data type is displayed with the relevant processing
  • Upd: (HP Vertica) table updates automatically increment fields grammar original AUTO_INCREMENT change IDENTITY (seed, increment) full definition (including table editing and script generation processing)
  • Add: Join Microsoft.ACE.OLEDB 12/15/16 automatic switching and connectivity, so as to enhance the Access / Excel / Text and other databases in different environments connection capacity
  • Add: Support Microsoft Office Access 2016 and Microsoft Access Runtime 2016 element connection process
  • Fix: resolve when TreeView [root] directory of more than 1 ?? nodes, may cause display freezing problems
  • Upd: (SQL Server) to update the database include ways to significantly improve loading speed resolve when login account [without authority] to access the database causes a load problem for too long
  • Upd: (64bit) Remove dBase IV / 5.0 (* .dbf) supported repositories
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Misc: the with Compatible the SQL Server SP2, 2014 / the SQL Server Express SP2 and LocalDB, 2014
  • TABLE EDITOR:
  • Add: (PostgreSQL / Informix) increase the auto-increment field set to automatically switch to Serial data type
  • Upd: Allow auto-increment columns plus [no] primary key (AUTO_INCREMENT + NON-PK) establishment process
  • DISPLAY INFORMATIONAL MESSAGE:
  • Add: (PostgreSQL) Join Reporting Errors and Messages support
  • Add: (PostgreSQL) was added LISTEN - listen for a notification support
  • SQL PERFORMANCE ANALYZER:
  • Add: Support SQLite database sessions analytical processing (Session Mode) (formerly Log Mode)
  • DATABASE MIGRATION:
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 18.8.6036.6 (Jul 11, 2016)

  • MAIN PROGRAM UPDATE:
  • Add: Join Microsoft.ACE.OLEDB 12/15/16 automatic switching and connectivity, so as to enhance the Access / Excel / Text and other databases in different environments connection capacity
  • Add: Support Microsoft Office Access 2016 and Microsoft Access Runtime 2016 element connection process
  • Fix: solve the root of the TreeView when more than 1 ?? nodes, may cause display freezing problems
  • Upd: (SQL Server) to update the database include ways to significantly improve loading speed resolve when login account [without authority] to access the database causes a load problem for too long
  • Upd: (64bit) Remove dBase IV / 5.0 (* .dbf) supported repositories
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • DISPLAY INFORMATIONAL MESSAGE:
  • Add: (PostgreSQL) Join Reporting Errors and Messages support
  • Add: (PostgreSQL) was added LISTEN - listen for a notification support
  • SQL PERFORMANCE ANALYZER:
  • Add: Support SQLite database sessions analytical processing (Session Mode) (formerly Log Mode)
  • DATABASE MIGRATION:
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 18.8.6029.1 (Jul 4, 2016)

  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Add: (SQLite) was added JSON1 extension support
  • Add: (SQLite) was added FTS5 extension support
  • Upd: (SQLite) update REGEXP extension mode is enabled
  • Add: (SQLite) database support to restore memory database processing (TOOLS -> Restore from a file into an in-memory database)
  • Fix: Problems error message (SQLite) to display when defining WITHOUT PK AND ROWID data editor
  • Add: (Firebird) database coding increases automatic setting processing (Automatically set charset), when you turn the different coding repository no longer any need to manually set
  • Upd: MySQL element updated to MySql.Data.dll 6.9.9 (2016/07/01)
  • Upd: SQLite element updated to System.Data.SQLite.dll 1.0.102.0 (3.13.0) (2016/06/23)
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • SQL HISTORY RECORDS ( the SQL History ):
  • Add: Added SQL insert query page to check processing (Insert SQL to new query)
  • Add: Add Tags [after Close] to save the process, even if did not perform will be recorded at any time convenient recovery processing (Note: The original record only [perform] After saving processing)
  • Upd: Other improvements: 1. Supports Right selected, 2. maintain the original SQL format of the content
  • AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
  • Upd: (SQL Server / SybaseASE) increased significantly with improved cross-repository [table] aware processing (Cross-database < table>.)
  • Fix: Cross-repository [table] (. Cross-database ) and cross structure description (. Cross-schema ) aware processing: Could not load successfully corrected the problem when the first read
  • Upd: Improved when SchemaName or TableName name is too long, table fields can not perceive a problem
  • DATABASE MIGRATION ( Database Migration ) (Pro):
  • Upd: Updated with all dbMigration .NET Software

New in Database .NET Professional 18.7.6023.3 (Jun 29, 2016)

  • Upd: (SQL Server / SybaseASE) increased significantly with improved cross-repository [table] aware processing (Cross-database < table>.)
  • Fix: Cross-repository [table] (. Cross-database ) and cross structure description (. Cross-schema ) aware processing: Could not load successfully corrected the problem when the first read
  • Upd: Improved when SchemaName or TableName name is too long, table fields can not perceive a problem
  • MAIN PROGRAM UPDATE ( the Main ):
  • Upd: SQLite element updated to System.Data.SQLite.dll 1.0.102.0 (3.13.0) (2016/06/23)
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in Database .NET Professional 18.7.6015.1 (Jun 20, 2016)

  • MAIN PROGRAM UPDATE ( the Main ):
  • Add: (Oracle / Firebird 3) increased Kit objects (Packages) in the stored procedure and function objects (Procedures / Functions) display and perform other functions (6015)
  • Fix: (Oracle) complete address different Procedures / Functions / Packages end; character display mode issues, affecting the implementation of compilation (6015)
  • Upd: (Oracle) database update delete (DROP USER), increase CASCADE property processing (6015)
  • Upd: (Firebird 3) Client Library can automatically correct the wrong set of issues (6015)
  • Fix: When executed automatically when not in heavy brush correction object tab page, will lead to [show] unusual problems (6015)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6015)
  • Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.0.4) (2016/06/16) (6015)
  • Misc: the with Compatible the IBM the DB2 11.1 (2016/06/16)
  • Misc: the with Compatible the MySQL 5.7.13 (2016/06/02) / the MySQL 5.6.31 (2016/06/02) / the MySQL 5.5.50 (2016/06/02)
  • BIND STORED PROCEDURES AND FUNCTIONS PARAMETERS ( the Binding Procedure To the Parameters and Function ):
  • Add: (Oracle) Support Procedures / Functions / Packages object returned REF CURSORS data set show (6015)
  • Upd: Error objects stored procedures and functions (Procedures / Functions) perform no longer occurs directly off, easy to modify the start-up process (6015)
  • Upd: When text and automatically add the relevant date type input quoted for (6015)
  • TRANSACTION MODE PROCESSING ( the Transaction Mode ):
  • Add: (SQL Server / SQLAzure) was added LOCK_TIMEOUT treatment, to avoid locking problems cause the program can not continue to operate (6015)
  • Fix: Fixed not support automatic switching current Schema Issues (6015)
  • Fix: Fixed not support the display of informative messages ( the Displaying informational to be messages ) Issues (6015)
  • SEARCH ROW( the Find the In the Grid ):
  • Fix: Fixed [specify field] The search is case of NULL or Byte [], the problem still searching for the other fields of the (6015)
  • Upd: increase Exclude binary data type (Byte []) and non-visible field (Visible = False) content search (6015)
  • QUERY DESIGN TOOLS( Query Builder )
  • Add: Support aggregate function generating process (Aggregate Functions): Count / Min / Max / Sum / Avg / Group By ... and others (6015)
  • Upd: Selected query criteria to the query generator ( the Selected to the Text Query Builder ): Improved ORDER BY, GROUP BY reducing treatment non-Alias ​​field when the (6015)
  • BATCH SCRIPT GENERATOR ( Generating Batch the Scripts ):
  • Fix: (Oracle) Fixed SQL INSERTs Export Processing: When not in use GO batch process to generate command is missing; end character (6015)

New in Database .NET Professional 18.6.6001.1 (Jun 6, 2016)

  • MAIN PROGRAM UPDATE:
  • Add: Support Firebird 3 Embedded Server mode (Property -> Client Library = fbclient )
  • Add: Support Firebird (Run as an Application) for the execution mode processing application
  • Add: increase Firebird Client Library path specifies the location (Property -> Client Library Path) : easy to switch between different versions
  • Upd: Improved tying dialog (Binding Dialog): Enter the text at the end of the contraction (blank characters and line breaks, etc.) processing
  • Upd: Improved Database [Backup and Restore] prompt message handling
  • Fix: (Oracle) solve different ending Functions; character display mode, the problem may affect the implementation of compilation
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Upd: HP Vertica element version [Back] Update to Vertica.Data.dll 7.2.3 -> 7.1.2 (6001)
  • Misc: the with Compatible the SQL Server 2016 the RTM (2016/05/31)
  • DATABASE MIGRATION:
  • Add: increase in test mode only the first 100 test process (Only Top 100 Rows)
  • Upd: Improved Firebird (Super / Embedded Service and Application ) automatic detection process
  • Add: increase Firebird database connection settings (Help-> Options-> Firebird Database Settings )
  • Fix: Fixed (5959) led to double-click can not change other types of data processing outside (6001) after [Objective field]
  • Upd: command line processing ( the Command-Line ):
  • Fix: Fixed custom object table approach, original -srctable | desctable: old_a | new_a to -srctable @ desttable: old_a @ new_a
  • Upd: Improved automatically match the field data types ( the Automatic Mapping Types & ):
  • Upd: optimization GUID / money / currency / char type data from sources such as the automatic matching process
  • Fix: Fixed Oracle numeric data type automatic matching process
  • Fix: Fixed length data location type is not the end of the show, many issues related to treatment (such as INTERVAL YEAR (x) TO MONTH ... etc)
  • AUTOMATICALLY AND PERCEPTION (AutoComplete and IntelliSense * ):
  • Upd: Increase in the membership list (List Members) shortcut Ctrl + Space (with Ctrl + J)

New in Database .NET Professional 18.4.5981.2 (May 17, 2016)

  • The main program update ( the Main ):
  • Add: Added to browse delimited text file function ( Browsing the Text Delimited Files ) Automatic Identification text file separator character (comma, tab, pipe, semicolon and custom delimiter) the file encoding
  • Can query SQL commands way to browse and convert other formats
  • Upd: Cumulative contain other minor updates, fixes and optimization
  • Misc: the with the PostgreSQL Compatible 9.5.3 / 9.4.8 / 9.3.13 / 9.2.17 / 9.1.22 (2016/05/12)
  • Database Migration ( Database Migration ) (Pro):
  • Add: New source-separated text file conversion process (Delimited Text Files) (5981)
  • Data Import ( the Data Import ):
  • Upd: import formats delimiters automatic determination process (Auto-detect delimiter): increase the Tab delimiter detection process (5981)
  • Automatically and perception ( the AutoComplete and IntelliSense * ):
  • Upd: Optimization table fields automatically senses the added characters # exception processing table (5981)

New in Database .NET Professional 18.4.5973.1 (May 9, 2016)

  • DATA EXPORT ( the Data the Export ):
  • Upd: rewrite Excel Workbook (* .xlsx) Export Processing
  • Export processing speed dramatically (5973)
  • Export processing can be carried out in the absence install MS Office or Access Database Engine environment (5973)
  • Fix: Fixed (59 ??) cause problems right [table] Data Export process interrupt button is not shown (5973)
  • DATA VISUALIZATION ( the Data the Visualization ):
  • Fix: Fixed multiple-choice questions generates an exception when switching to Kagi / PointAndFigure / Renko / ThreeLineBreak and other chart types under Y-Axis (5973)
  • BROWSE ROW ( the Data Browser ):
  • Upd: The results are given tag name in the underlying table name substituted (Base TableName -> Result [n ]) (5973)
  • THE MAIN PROGRAM UPDATE ( the Main ):
  • Fix: (Firebird 3) If you do not install the corrected version installed Guardian service will result when the connection is still not displayed FB installation problems (5973)
  • Upd: Cumulative contain other minor updates, fixes and optimization (5973)
  • Automatically and perception ( the AutoComplete and IntelliSense )