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

dbMigration .NET Changelog

What's new in dbMigration .NET 16.8.8816.1

Feb 22, 2024
  • Upd: [Same type] Database object migration adds support for index expression (8816)
  • Upd: [Same type] Database object migration adds support for partial indices (8816)
  • Fix: Correction [Non-same type] Database source and destination index generation issues (8816)
  • Fix: (PostgreSQL) Fix the issue where obtaining multiple fields fails (8816)
  • Add: Support Firebird 5 database system (8816)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.5 (2024/01/27)( )(8816)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8816)

New in dbMigration .NET 16.7.8767.1 (Jan 2, 2024)

  • Fix: (SQLite) The problem that the PK cannot be obtained when the field data type is NON-INTEGER and WITHOUT ROWID
  • 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()
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 10.0.0.0 (2023/11/13)()
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.9000.4) (2023/11/15)
  • 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

New in dbMigration .NET 16.6.8701.1 (Oct 28, 2023)

  • Upd: [Open and Save] session (File->Open/Save Session): related processing optimization and improvements (8701)
  • Upd: Improve the control item display problem in Windows 7 operating environment (8701)
  • Upd: Customized corresponding data types (Custom Mapping Types ):
  • Upd: (Oracle) Improve the processing of Number data type including complete length correspondence (8701)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.2 (2023/10/27)( )(8701)
  • Update: PostgreSQL component version updated to Npgsql 7.0.6 (2023/09/15)( )(8701)
  • Update: Others include cumulative minor updates, corrections and optimizations (8701)

New in dbMigration .NET 16.5.8689.1 (Oct 16, 2023)

  • Add: Added [Open and Save] session (Help->Open/Save Session) (8689)
  • Add: Command-line processing ( Command-line ): Support opening session files (app.exe opensession.dms) (8689)
  • Upd: Improve COMPUTED COLUMN syntax parsing capabilities (8689)
  • Upd: External index keys (Foreign Keys):
  • Fix: Correction and improvement (8656) Structure description name (Schema Name) processing (8662)
  • Upd: Custom corresponding data types ( Custom Mapping Types ):
  • Upd: (PostgreSQL/Informax) Custom corresponding data types can replace the Serial default data type (8662)
  • Upd: Data types Names allow different case matching processing (8662)
  • Fix: Fixed an exception that may occur when deleting custom corresponding data types (8662)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.12.0 (2023/10/10) ( )(8689)
  • Upd: PostgreSQL component version updated to Npgsql 7.0.5 (2023/09/15)( )(8689)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8689)

New in dbMigration .NET 16.4.8662.2 (Sep 19, 2023)

  • Upd: Foreign Keys:
  • Fix: Correction and improvement (8656) Processing of Schema Name (8662)
  • Upd: Custom corresponding data types (Custom Mapping Types):
  • Upd: (PostgreSQL/Informax) Custom corresponding data type can replace Serial default data type (8662)
  • Upd: Data type names allow different case matching (8662)
  • Fix: Fixed an exception that may occur when deleting custom corresponding data types (8662)
  • Update: Others include cumulative minor updates, corrections and optimizations (8662)

New in dbMigration .NET 16.4.8656.1 (Sep 13, 2023)

  • Add: Foreign Keys: Support changing the Schema Name (8656)
  • Upd: Foreign Keys: Support cross-schema definition (8656)
  • Fix: Fixed the problem that foreign index keys (Foreign Keys) cannot be enabled in batch mode (8656)
  • Fix: (SQLite) Fixed the problem that batch mode CHECK CONSTRAINTS cannot be enabled (8656)
  • Fix: Connection Profile: Fixed the drop-down browsing SCHEMAS/DATABASES control item not supporting SSH enable processing (8656)
  • Update: Others include cumulative minor updates, corrections and optimizations (8656)

New in dbMigration .NET 16.3.8610.2 (Aug 1, 2023)

  • Upd: Automatically correspond to field data types ( Automatic Mapping Types ):
  • Fix: Correct the problem that numeric(precision, scale) automatically corresponds to scales not included (8610 )
  • Fix: (Pro 64bit) When used with database management tools at the same time, the problem of related shared variables (8609)
  • Fix: (PostgreSQL) Fixed the problem that the associated field of GetForeignKeys is unique (8609)
  • Fix: (PostgreSQL) Fixed GetForeignKeys affects related issues when different Schema names have the same Table name (8609)
  • Upd: Oracle component version is updated to Oracle.ManagedDataAccess.dll 21.11.0 (2023/07/26)( )(8609)
  • Upd: SQLite component version is updated to System .Data.SQLite.DLL 1.0.118.0 (3.42.0)(2023/06/10)(8609)
  • Upd: Others include cumulative small updates, corrections and optimizations (8610)

New in dbMigration .NET 16.3.8610.1 (Jul 29, 2023)

  • Upd: Automatically correspond to field data types (Automatic Mapping Types):
  • Fix: Fix the problem that numeric(precision, scale) automatically corresponds to scale not included
  • Fix: (Pro 64bit) Fixed the problem of related common variables when used together with the database management tool
  • Fix: (PostgreSQL) Fixed the problem that the associated field of GetForeignKeys cannot be displayed when it is unique
  • Fix: (PostgreSQL) Fix the problem that GetForeignKeys affects related issues when different Schema names have the same Table name
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.11.0
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.118.0
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 16.2.8609.1 (Jul 28, 2023)

  • Fix: (Pro 64bit) Fixed the problem of related common variables when used together with the database management tool
  • Fix: (PostgreSQL) Fixed the problem that the associated field of GetForeignKeys cannot be displayed when it is unique
  • Fix: (PostgreSQL) Fix the problem that GetForeignKeys affects related issues when different Schema names have the same Table name
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll
  • Upd: SQLite component version updated to System.Data.SQLite.DLL
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 16.2.8558.1 (Jun 7, 2023)

  • Main program update (Main):
  • Add: Support the latest version of Oracle 23c database system
  • Add: Support Teradata 17 latest version database system
  • Add: Support PostgreSQL 16 beta 1 latest database system
  • Add: (Oracle 21c/23c) support new data types such as JSON/BOOLEAN
  • Add: (Oracle 23c) support DOMAIN object conversion processing
  • Upd: (PostgreSQL) Solve the problem that the default driver does not support the interval data type with year and month
  • Upd: PostgreSQL component version updated to Npgsql 7.0.4
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.10.0
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.6.0
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 16.1.8495.1 (Apr 6, 2023)

  • Main program update ( Main ):
  • Add: Support multiple selection object processing (Multiple selections): Ctrl or Shift key + Mouse Click(8495)
  • Add: (VistaDB) Support AES256 encrypted database processing (8495)
  • Upd: (Excel/Text) Solve the problem that getting ROWS COUNT is too slow when the content of a large data table is too slow (8495) Upd: (
  • Text ) Add a prompt message when the file length exceeds 64 characters , It must not be processed normally (8495)
  • Upd: (Text) Exclude click {*} to get ROWS COUNT processing (8495)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.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)

New in dbMigration .NET 16.0.8447.1 (Feb 16, 2023)

  • Upd: Support the latest version of MariaDB 10.10+ Database: Solve the compatibility problem caused by the new code
  • Upd: If the Server Compatibility Mode=Redshift attribute is not specified when connecting to Redshift, it will automatically add processing
  • Upd: Improve error message content display
  • Upd: SSH: Secure Shell component updated to Renci.SshNet.dll 2020.0.2
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.0
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.1.1.0
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.9.0
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 15.9.8401.1 (Jan 2, 2023)

  • main program update ( Main ):
  • Fix: (PostgreSQL) Solve Generated Columns if data type definition is included , The problem of missing () when PG itself is returned (8401)
  • Upd: (PostgreSQL) Add public global custom data type (UDDT) to all Schemas (affecting multiple places) (8401)
  • Upd: (PostgreSQL) Improve when the user has no Change to alternate processing when accessing information_schema with permissions (8401)
  • Upd: Improve the processing ability to obtain field data types (DataTypeName) (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)

New in dbMigration .NET 15.8.8360.1 (Nov 21, 2022)

  • Add: Support PostgreSQL 15.1 latest database system
  • Upd: PostgreSQL component version updated to Npgsql 7.0.0
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.1.0.0
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.0.1
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.8 FP0
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.8.0
  • Upd: MySQL component version updated to MySql.Data.dll 8.0.31
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.3.0
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 15.7.8318.1 (Oct 10, 2022)

  • 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)
  • Add: (SQL Server/SQL Azure) Connection Profile: Added Encryption option (Optional/Mandatory/Strict)(8318)
  • Add: Support to modify user and password in ODBC Connection Profile (8318)
  • Upd: Improve the processing speed of GetForeignKeys, affecting multiple functions (8318)
  • Upd: Update the length judgment of processing Text to Blob to solve possible exceptions (8318)
  • Upd: PostgreSQL component version updated to Npgsql 6.0.7 (2022/09/16)()(8318)
  • Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.0.0 (2022/08/06)()(8318)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.7.0 (2022/08/04)()(8318)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8318)

New in dbMigration .NET 15.6.8249.1 (Aug 2, 2022)

  • Upd: Update Office Access Compatibility Check, Support ClickToRun Installation Version:
  • Affects Contains: (Text) Delimited text files Custom extension file name... etc.
  • Fix: Fixed the problem of overlapping display when the data table size and ROWS COUNT exist at the same time after conversion (8249)
  • Fix: (MySQL 8/MariaDB) Generate CHECK CONSTRAINTS object syntax definition, remove exception Character(8249)
  • Upd: Generate CHECK CONSTRAINTS Object Syntax Definition: Improve the conversion of [None] Quote and [Single] Quote field (8249)
  • Upd: (MySQL) SSL Mode Added support for VerifyCA/VerifyFull(8249)
  • Upd: (MySQL) Automatically configure max_allowed_packet with a minimum size of 16M (8249)
  • Add:Connection Profile (Connection Profile): Clear dozens of useless connection properties in multiple databases to simplify settings (8249)
  • Upd: MySQL component version updated to MySql.Data.dll 8.0.30 (2022/07/26)( )(8249)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.0.2.0 (2022/07/12)( )(8249)
  • Upd: PostgreSQL component version updated to Npgsql.dll 6.0.5 (2022/06/19) )( )(8249)
  • Upd: Others include cumulative minor updates, corrections and optimizations (8249)

New in dbMigration .NET 15.5.8227.1 (Jul 11, 2022)

  • Main program update (Main):
  • Upd: (Text) xSV delimited archive file browsing supports more encoding processing (including BOM/NOBOM)
  • Upd: (IBM DB2) Exclude indexes automatically generated by the system
  • Upd: (Oracle) Whether the default case is converted or not, it will be processed according to the settings (Options) to avoid confusion
  • Upd: (Oracle) Data table definition preview (SQL preview): Exclude unnecessary DEFAULT VALUES display and prompt
  • Upd: Improve the efficiency of obtaining ROWS COUNT
  • Upd: PostgreSQL component version updated to Npgsql.dll 5.0.14 (2022/06/19)()(8227)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.2.0 (2022/05/23)()(8227)
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.6.1 (2022/04/16)(8227)
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 15.4.8202.1 (Jun 16, 2022)

  • Fix: Solve the compatibility problem of Windows 11 Build 25136+ latest version (8202)
  • Upd: (Firebird) Exclude versions of libraries that do not support COLLATE (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, corrections and optimizations (8202)

New in dbMigration .NET 15.3.8186.2 (Jun 1, 2022)

  • Fix: (IBM DB2/Informix) Fixed (8166) the problem that the quoted identifiers could not be obtained (8186)

New in dbMigration .NET 15.3.8184.1 (May 29, 2022)

  • Main Program Update ( Main ):
  • Upd: Optimized field data access processing, takes up less resources and faster processing speed (8184)
  • Add: Added Non-default database type automatic detection processing (8184)
  • Fix: Correction of whether the database object is supported or not is divided into database migration ( Database .NET Pro ) to avoid being affected (8184)
  • Upd: Others include cumulative minor updates, corrections and Optimization processing (8184)

New in dbMigration .NET 15.2.8166.1 (May 11, 2022)

  • Fix: (ODBC/OleDB) Allow database drivers to handle Quoted identifiers without quotes (8166)
  • Add: (Teradata) Support password expiration [update] processing (8166)
  • Fix: Connection provider (Provider) version detection, add password discrimination processing (8166)
  • Fix: (MySQL) Fix the timeout of obtaining ROWS COUNT, which makes it impossible to continue Fixed issue (8166)
  • Upd: Update MySQL component version to MySql.Data.dll 8.0.29 (2022/04)( )(8166)
  • Upd: Update PostgreSQL component version to Npgsql.dll 5.0.13 (2022/04/27) )( )(8166)
  • Upd:[Same type] Database object migration ( Migrating VIEW/PROCEDURE/FUNCTION/SEQUENCE/DOMAIN definitions ):
  • Upd: (PostgreSQL) Improve PROCRDURES/FUNCTIONS object parameters including IN/OUT/INOUT display (8166)
  • Upd: Others include cumulative minor updates , Fixes and optimizations (8166)

New in dbMigration .NET 15.1.8148.1 (Apr 23, 2022)

  • Add: Add "Getting table/view rows count: {*})
  • Fix: (Teradata) Fixed the problem that the password expired [hint] function does not work
  • Upd: will be automatically created when [last access time] does not exist
  • Upd: If the position of the window exceeds the current screen after startup, it will be automatically corrected to prevent the same setting from being abnormal in different display environments
  • Add: Support YugabyteDB database (PostgreSQL compatible)
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 15.0.8075.1 (Feb 9, 2022)

  • Main program update ( Main ):
  • Add: (SQLite) Added database connection memory release processing to avoid the problem of insufficient resources (8075)
  • Add: (Oracle) Support User-defined types to read custom type data (8075)
  • Add: (Oracle) Add Object tables display to data table objects (8075)
  • Upd: (PostgreSQL) Improve the processing speed of Array Types (8075)
  • Upd: Source data filtering ( Filtering source ) / conversion result browsing ( Showing target )
  • Add: (SQLCe 3.1/OleDB/ODBC) Support data column preview to limit the number of entries, to avoid excessive data volume affecting related processing (8075)
  • Fix:Fix (7943) the problem that some databases in the conversion result browsing are invalid due to different (Quoted identifiers) (8075)
  • Upd: Improve the problem of multiple SQL execution exception handling and error message display (8075)
  • Upd: The 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)

New in dbMigration .NET 14.9.8038.1 (Jan 3, 2022)

  • 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: Fix (7943) the problem that caused the original connection [last access time] setting to lose update (8038)
  • Upd: Improve the opening speed between different versions of the file type database (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: (SQLCe 3.1/OleDB/ODBC) Fix the database type without the top n keyword processing (including related functions) (8038)
  • Fix: (IBM DB2) Fix the version display problem (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)

New in dbMigration .NET 14.8.8007.1 (Dec 3, 2021)

  • 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/PostgreSQL) Improve VIEW object generation script processing speed (7996)
  • Fix: (SQL Server/SQL Azure) Fix (7989) the problem that the DOMAIN object is not displayed (7996)
  • 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)

New in dbMigration .NET 14.7.7996.3 (Nov 22, 2021)

  • Upd: (SQL Server/PostgreSQL) Improve VIEW object generation script processing speed.
  • Fix: (SQL Server/SQL Azure) Fix (7989) the problem that the DOMAIN object is not displayed.
  • 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.

New in dbMigration .NET 14.7.7989.1 (Nov 15, 2021)

  • Upd: Bulk Insert mode: Improve exception handling to improve processing efficiency
  • Upd: Rewrite GetSchemaTable related code to improve overall processing efficiency
  • Add: Support TimeOnly text data type (HH:mm:ss) conversion processing
  • Upd: Related optimization and update processing under Windows 11 operating environment
  • 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?)
  • 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: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.13.0
  • Upd: VistaDB component version updated to VistaDB.6.dll 6.2.3
  • Upd: Others include cumulative minor updates, corrections and optimization processing

New in dbMigration .NET 14.6.7943.1 (Sep 30, 2021)

  • Upd: Upgrade .NET Framework to version 4.7.2, performance and related functions are optimized and improved at the same time (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: (SQLite) Improve the processing speed of opening AES256 encrypted database (7943)
  • Add: Add a new database to the destination database drop-down option (7943)
  • Upd: The source is array data type, when the destination is not array data type, turn to [no length] text type (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)
  • Upd: Update Firebird asynchronous processing (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: SQLite component version updated to System.Data.SQLite 1.0.115.0 (3.36.0) (2021/08/25)(7943)
  • Upd: [Same type] Database object migration (Migrating VIEW/PROCEDURE/FUNCTION/SEQUENCE/DOMAIN definitions):
  • Fix: (SQL Server/SQL Azure) Fix the issue of Included Columns generation (7943)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7943)

New in dbMigration .NET 14.5.7908.1 (Aug 26, 2021)

  • Appending Data: Support Preserve source Auto Increment values (7908)
  • Add: Command-line: Support additional data parameter setting (Appending Data Parameters: -keepauto) (7908)
  • Add: Add the right-click menu function to the source and destination drop-down options, and integrate the connection functions such as add/delete/update/new (7908)
  • Upd: Auto-generating FOREIGN KEYS of tables: Open to general users (7908)
  • Fix: (PostgreSQL) Solve the 25P02 exception handling, and provide a more detailed error cause display (7908)
  • Upd: Optimize the interface and HiDPI high zoom ratio display problem (7908)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7908)

New in dbMigration .NET 14.4.7890.1 (Aug 8, 2021)

  • Upd: Bulk Insert mode:
  • Upd: Optimize and improve a large number of import mode related issues
  • Upd: Improve database processing for [not supported] bulk import mode
  • Add: Support source data table size information (Table Size Information) display
  • Support SQL Server/Sybase ASE/PostgreSQL/MySQL/Oracle and other databases
  • Upd: Automatic Mapping Types:
  • Upd: When the target data type does not support the array data type, it will be converted to the array text format and saved: Add the processing when [Base Type] is also an array
  • Upd: Improve the conversion process to avoid the occurrence of Unexpected end of command caused by too long text
  • Upd: Filtering source/Showing target:
  • Upd: 1. The user interface is optimized and updated, 2. The total number of transactions is displayed, 3. The number of browsing transactions is selected or click Enter to update directly
  • Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.12.0 (2021/08/05)
  • Upd: Others include cumulative minor updates, corrections and optimization processing

New in dbMigration .NET 14.3.7874.1 (Jul 23, 2021)

  • Add: Support Bulk Insert mode
  • Significantly increase the conversion processing speed and support data synchronization processing, the processing speed is only slightly lower than the bulk copy mode (Bulk Copy mode)
  • Currently supports SQL Server/SQL Azure/NuoDB/IBM DB2/SQLite/PostgreSQL/MySQL/Firebird/Oracle and other databases
  • Add: Support Asynchronous Processing
  • Add: [Waiting] window, support to complete the remaining time (Countdown time)
  • Add: [Waiting and Output] window, support display of average processing rows per second (Avg. rows/s)
  • Add: Multiple instance support
  • Fix: (Access) Fix that password protection (MDB) database cannot be opened normally without ACE Provider
  • Upd: Optimized interface and HiDPI high zoom ratio display problem
  • Upd: Command-Line:
  • Fix: Fix the problem that does not support the parameter -defopt: under the -defopt: parameter is not specified
  • Upd: MySQL component version updated to MySql.Data.dll 8.0.26 (2021/07)()
  • Upd: Others include cumulative minor updates, corrections and optimization processing

New in dbMigration .NET 14.2.7866.1 (Jul 15, 2021)

  • Upd: Automatic Mapping Types:
  • Add: When the target data type does not support the array data type, it will be converted to array text format and saved (7866)
  • Upd: Support (>2D) Multidimensional Arrays related processing (7866)
  • Upd: (Firebird) Optimize and unify the data type output processing of all objects (7866)
  • Fix: (Firebird) Fix the problem that the corresponding CHARACTER SET NAME is not included when setting COLLATE (7866)
  • Fix: (VistaDB/MySQL) Fix the problem that field comments contain exception characters (') (7866)
  • Upd: (SQL Server/SQL Azure) Add a prompt message when the Azure Active Directory authentication item is selected (7866)
  • Upd: The primary key (PK) generated by the data table no longer contains the name of the conditional constraint (same as FK) (7866)
  • Fix: Fix the problem that the UNIQUE index value cannot be obtained when the index value is not of the Bollinger type (7866)
  • Upd: Improve statement parsing multi-line annotation processing to avoid freezing (7866)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7866)

New in dbMigration .NET 14.1.7857.1 (Jul 6, 2021)

  • Upd: Compatible with Microsoft Windows 11
  • Add: (SQLite) Add LOCALIZED custom collation
  • Add: (SQLite) Add support for AES256 encrypted database REGEX function
  • Upd: (PostgreSQL 14) Update multirange data types output problem
  • Upd: All database name example items are sorted and processed uniformly
  • Upd: More optimized script generation speed and reduced memory usage processing
  • Upd: Optimize the interface and HiDPI high zoom ratio display problem
  • Upd: (Sybase ASE/MySQL) Improve the speed of obtaining DEFAULT VALUES (impacts include multiple points)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.6000.4) (2021/06/21)
  • 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 optimizations

New in dbMigration .NET 14.0.7825.1 (Jun 4, 2021)

  • Upd: Optimize the processing of Automatic Mapping Types (7825)
  • Add: (All) Support BigInteger data type related processing (7825)
  • Add: (Oracle) Support BFILE, XMLTYPE and other data type related function processing (7825)
  • Upd: (Oracle) Support and modify INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH and other data types related function processing (7825)
  • Add: (SybaseASE) Add date, time, bigdatetime, bigtime and other data types (7825)
  • Add: (Firebird 4) Support int128, decfloat, timetz, timestamptz data type conversion processing (7825)
  • Upd: (Firebird) Update time time data type microsecond length display and output issues (7825)
  • Upd: (SQLite/SybaseASE/HP Vertica) Update time The data type only displays and outputs the part of the time (7825)
  • Fix: (NuoDB) Fix the problem that the time data type cannot be processed (7825)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7825)

New in dbMigration .NET 13.9.7818.2 (May 28, 2021)

  • Correction (7814) Guidance, letter case, disparate judgment, loss of action problem (effect inclusion, multi-functionality) (7818)
  • Upd: Document table definition deposit (SQL preview):
  • Fix: Fixed move column order not followed by update preview problem (7818)
  • Add: (SQL Server / SQL Azure) Support Latest Azure Active Directory Login Method (7814)
  • New increase inclusion Active Directory Interactive / Service Principal / Device Code Flow / Managed Identity etc.
  • Add: (SQL Server / SQL Azure) Increased main service Active Directory Authentication
  • Add: Supported latest PostgreSQL 14.0 beta1 Archive system (2021/05/20) (7814)
  • Add: (PostgreSQL) Increased hstore, ghstore Specified support (7814)
  • Upd: (PostgreSQL) Fixed depiction PUBLIC for deposit Hakuhiro Road (search_path) (7814)
  • Fix: Correction table generative material Isao Yukisada (Collation Name) Duplicate demonstrative problem (7814)
  • Upd: Column Designer: Collation 與 Index Expressions Support Multi-selection Criticism Update (7814)
  • Upd: Other inclusion cumulative small update, correction 與 與 處 處 (7818)

New in dbMigration .NET 13.9.7814.1 (May 24, 2021)

  • (SQL Server/SQL Azure) Support the latest Azure Active Directory authentication login method (7814)
  • Added authentication methods including Active Directory Interactive/Service Principal/Device Code Flow/Managed Identity
  • Add: (SQL Server/SQL Azure) Add Active Directory Authentication drop-down option in the main interface (7814)
  • Add: Support the latest PostgreSQL 14.0 beta1 database system (2021/05/20)(7814)
  • Add: (PostgreSQL) Add hstore, ghstore extended data type support (7814)
  • Upd: (PostgreSQL) Fixed structure description PUBLIC is the default search path (search_path) (7814)
  • Fix: Fix the problem of repeated display of the column sequence (Collation Name) generated by the table (7814)
  • Upd: Column Designer: Collation and Expressions support multi-select batch update (7814)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7814)

New in dbMigration .NET 13.8.7804.1 (May 14, 2021)

  • Upd: Improve the processing speed of initial related messages when converting source data tables (7804)
  • Upd: Improve the detection processing speed of the purpose data table (7804)
  • Upd: Increase execution time (Execution time) and total time (Total time) to replace the original elapsed time (7804)
  • Upd: The character limit of the server version connection editor, increased to 512 characters (7804)
  • Upd: (SQLite) Improve the processing efficiency of file-related functions (7804)
  • Upd: (SQLite) Support the calculation data field generation processing when the GENERATED ALWAYS keyword is omitted (7804)
  • Upd: (SQLite) Improve CHECK Constraints detection generation processing (7804)
  • Upd: (SQLite) Remove the HIDDEN keyword when the data type is displayed (7804)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 (3.35.5) (2021/05/02)(7804)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7804)

New in dbMigration .NET 13.7.7788.1 (Apr 28, 2021)

  • Add: Support database [connection] asynchronous processing (7788)
  • Add: Support asynchronous [interrupt] processing capability (7788)
  • Add: Add batch seconds processing (Batch Seconds: >3s), automatic batch approval when exceeded (7788)
  • Upd: SQL preview:
  • Add: Add a prompt message when the external index key (FOREIGN KEYS) of the table is not enabled (7788)
  • Upd: (Oracle) Solve the problem that the timestampltz read speed is too slow (7788)
  • Upd: (MySQL) Remove the wrong connection attribute Allow Load Data Local Infile, and change it to the default enable processing (7774)
  • Fix: (MySQL/Informix) Fixed the problem of trying to switch the connection after clicking to cancel the connection test (7788)
  • Upd: PostgreSQL component version updated to Npgsql.dll 4.1.9 (2021/04/06)(7788)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 (3.35.4) (2021/04/02)(7788)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.5010.4) (2021/04/01)(7788)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5 FP1 (2021/04/01)
  • 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)

New in dbMigration .NET 13.6.7761.1 (Apr 1, 2021)

  • Upd: Data Synchronization:
  • Upd: Optimize code to improve synchronization efficiency (7761)
  • Fix: Fix (7744) the problem that caused Jet<->ACE driver automatic switching ability to lose function (7761)
  • Upd: Optimize HiDPI high zoom ratio display (7761)
  • Upd: Optimize the ability to automatically correspond to the field data type (Automatic Mapping Types) (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)

New in dbMigration .NET 13.4.7716.1 (Feb 16, 2021)

  • Upd: (64bit) On 64-bit platforms, support access to objects larger than 2GB (7716)
  • Upd: ( Firebird 4) Support Decimal/Numeric 19-38 accuracy (7716)
  • Fix: (SQLite) Fix the problem that the RC4 encrypted database can not be opened if the password is entered incorrectly for the first time (7716)
  • Upd: Avoid closing the database Re-opening immediately afterwards may cause Access violation issues (7716)
  • Upd: Optimize HiDPI high zoom ratio, large fonts and sub-control display issues (7716)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7716)

New in dbMigration .NET 13.3.7695.1 (Jan 25, 2021)

  • Add: Wait for the window to support the countdown time display (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: Optimize HiDPI high zoom ratio >150 display and control issues (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 optimization processing (7695)

New in dbMigration .NET 12.9.7613.1 (Nov 4, 2020)

  • Fix: Fix (7607) the problem that caused the target database to be unable to be processed by PostgreSQL (7613)
  • Fix: Solve the occurrence of 25P02: current transaction is aborted (7613)
  • Upd: [Same Type] Database object migration (Migrating VIEW/PROCEDURE/FUNCTION/SEQUENCE/DOMAIN definitions):
  • Add: (Firebird 3.0+) Support EXTERNAL ROUTINES (PROCEDURE/FUNCTION/TRIGGER) syntax generation (7613)
  • Upd: (SQL Server/SQL Azure) Change to PROC method to improve the processing speed of index key reference acquisition (7613)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7613)

New in dbMigration .NET 12.8.7607.1 (Oct 28, 2020)

  • Upd: MySQL component version updated to MySql.Data.dll 8.0.22 (2020/10/19)( )(7607 )
  • Support the latest connection protocol, 2. Relevant updates retain the support of MySQL 5.0 without being affected.
  • Add: (PostgreSQL) Support BitArray (bit(n)/varbit(n)) data type conversion processing (7607)
  • Fix: ( SQL Server) Rewrite (7577) index key reference [multi-column] sorting statement to avoid possible freezing problems (7607)
  • Fix: (MySQL) Fix the problem that the data type ENUM(), SET() get content value ineffective ( 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)
  • Fix: (SQLite) Fixed to Integer data type when the purpose is PK+AUTO (7607)
  • Fix:Fix the problem of missing the keyword CHECK when generating CHECK constraints in some databases (7607)
  • Fix: Fix the problem of {} display and related processing when Array type data is empty (7578)
  • Fix: Solve and fix upgrade to Npgsql.dll 4.1.5 Other related issues brought by later (7607)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7607)

New in dbMigration .NET 12.7.7592.1 (Oct 14, 2020)

  • 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 and related functions are optimized and improved at the same time (7592)
  • Upd: PostgreSQL component version updated to Npgsql.dll 4.1.5 (2020/09/28 ) (7592) is updated to this element, this version comprises a large number of relevant changes and improvements
  • Upd: automatic data type corresponding to the field ( the automatic the Mapping types ): Upd: when source [no length] char data type, to change the preset object 128~256 characters to solve related problems (7592)
  • Add: (FoxPro) Support CHECK Constraints related processing (7592)
  • Upd:(Firebird) Update the VIEW object loading method (7592)
  • Upd: (HP Vertica) Improve the processing speed of the VIEW/SYSTABLE object field (7592)
  • Upd: (NuoDB/Teradata) Improve and fix the problem of obtaining the primary key and external index key (7592)
  • Fix: Fix the problem of table renaming under multi-select processing (7592)
  • Upd: Other includes minor updates, corrections and optimization processing (7592)

New in dbMigration .NET 12.6.7578.1 (Sep 30, 2020)

  • Fix (7331) the problem that the built-in functions of 5.0 cannot be obtained normally under the sharing of VistaDB 5.0/6.0
  • (HP Vertica) Fix the problem of obtaining external index key reference

New in dbMigration .NET 12.6.7577.1 (Sep 29, 2020)

  • Add: Support source and destination color change (Options->Source and Target Color)(7577)
  • Fix: Fix the sorting problem of [multi-column] reference of external index keys in some databases (7577)
  • Fix: (PostgreSQL) Fix the problem that the external index key reference [multi-column] cannot be obtained (7577)
  • Upd: Optimize the reference processing speed of obtaining external index keys (7577)
  • Upd: (SQL Server) Solve the problem of abnormal slowness when listing databases in a few environments (7559/7560)
  • Upd: Improve the ability to read and write exceptions in the clipboard (7577)
  • Upd: Optimize many related display issues under high zoom ratio of HiDPI (7577)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7577)

New in dbMigration .NET 12.5.7559.1 (Sep 11, 2020)

  • Fix: (SQL Server) Solve the problem of abnormally slow database reading in a few environments (7559)
  • Upd: Others include cumulative minor updates, corrections and optimization processing (7559)

New in dbMigration .NET 12.4.7487.1 (Jul 12, 2020)

  • Add: (SQLite) Support CHECK Constraints related processing (7498)
  • Fix: (VistaDB) Improve VistaDB version detection process, fix default cannot open v6 version database(7498)
  • Upd: Automatic mapping field data types (Automatic Mapping Types):
  • Upd: destination data table [no length] blob data type, automatically exclude primary key (PK) processing by default (7498)
  • Upd: Bulk Copy Mode:
  • Upd: Improve progress display processing to increase copy processing speed (7498)
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.4000.4) (2020/06/30)(7498)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5 FP0 (2020/06/30)
  • Upd: Others include cumulative minor updates, corrections and optimization (7498)

New in dbMigration .NET 12.3.7484.1 (Jun 28, 2020)

  • Upd: Converting case, adding prefix and suffix (Converting case, adding prefix and suffix):
  • Fix: Fix the problem that is not included in the processing of external index keys (FOREIGN KEYS) in the table (7484)
  • Add: Increase the detection of the existence of the data table structure description (Schema) (7484)
  • Add: Support PostgreSQL 13 latest database system (7484)
  • Upd: Others include cumulative minor updates, corrections and optimization (7484)

New in dbMigration .NET 12.2.7445.1 (May 20, 2020)

  • Add: Support HP Vertica 10 latest database system (7445) to solve the bug of ver 10 itself, when reading DataTypes leads to StackOverflowException the problem
  • Upd: avoid some database types in the process is interrupted, may lead to the occurrence of an exception (7445)
  • Upd: improved after switching structure describes the program title synchronous update (7445)
  • Fix: (NuoDB) revised composite index (composite index) column Bit sequencing problem (7445)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7445)

New in dbMigration .NET 12.0.7373.2 (Mar 9, 2020)

  • Upd: [Same type] database object migration ( Migrating VIEW / PROCEDURE / FUNCTION / SEQUENCE / DOMAIN definitions )
  • Fix: (Firebird) Fixed TRIGGERS generation script processing (backwards compatible with all database versions)
  • Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.5.0.0 (2020/02/06)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 16.20.9.0 (2020/01/24)
  • Upd: Others include cumulative minor updates, corrections and optimizations

New in dbMigration .NET 12.0.7331.1 (Jan 31, 2020)

  • Add: Support VistaDB 6 database (7331)
  • Upd: Simultaneously backward compatible with VistaDB 5 database (7331)
  • Upd: [Same Type] Database Object Migration (Migrating VIEW / PROCEDURE / FUNCTION / SEQUENCE / DOMAIN definitions):
  • Add: Support DOMAINS object migration processing (including: NuoDB / PostgreSQL / IBM DB2 / Oracle / SQL Server / SQL Azure / Teradata / Sybase ASE / Firebird / Informix and other databases) (7331)
  • Upd: (Oracle) Significantly Improved Foreign Key Relationships Acquisition Processing Speed (50% +) (7331)
  • Upd: (VistaDB / SQLCe) Improve the speed of opening encrypted database (7331)
  • Fix: (SQL Server / SQL Azure) Solve the problem that the field information cannot be obtained correctly when the table name prefix is _ (second correction) (7331)
  • Upd: (Teradata) Exclude built-in user-defined data types (User-Defined Data Types) Browse display (7331)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7331)

New in dbMigration .NET 11.9 (Dec 24, 2019)

  • Upd: Automatic Mapping Types:
  • Upd: Automatic correspondence type AUTOINCREMENT field name case insensitive (7297)
  • Upd: When the update source is nextval and is not the primary key, it automatically corresponds to the AUTOINCREMENT field type processing (7297)
  • Add: (SQLite) Support Julian day and Unix Time to ISO8601 automatic conversion date type processing (7297)
  • Add: (SQLite) Support yyyy / mm / dd and yyyy.mm.dd to yyyy-mm-dd (ISO8601) Automatic conversion date format processing (7297)
  • Fix: (SQLite) After setting some connection properties, the database with password could not be opened (7297)
  • Fix: (FoxPro) Solve the problem that the built-in GetSchema cannot distinguish the Character / Varchar field type correctly (7297)
  • Fix: (Oracle) Solve the problem that the TimeStampTZ data content does not include TimeZone (7297)
  • Fix: (Oracle) Fix the actual defined length of Millisecond output in TimeStampTZ (7297)
  • Upd: Optimize data import processing speed (7297)
  • Fix: Fixed the problem of object name update after generating DDL (tab characters before the object name) (7297)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7297)

New in dbMigration .NET 11.8 (Dec 16, 2019)

  • Add: Support for Microsoft Windows 10 (1909) operating system (7289)
  • Add: Support SQL Server 2019 GA database (7289)
  • Add: increase settings [self] backup and repair processing (7289)
  • Upd: (SQLite) Modify the password detection method to solve the compatibility problem of database opening (7289)
  • Upd: High DPI scaling processing: Improved automatic scaling processing for multiple icons and controls (7289)
  • Fix: Fix the problem of object name update processing after generating DDL (7289)
  • Fix: Fix the problem when COLUMN NAME is the same as DOMAIN NAME (including multiple updates) (7289)
  • Fix: (Firebird) Fix the display order when the field contains COLLATE and PRIMARY KEY (7289)
  • Upd: Teradata component version updated to Teradata.Client.Provider.dll 16.20.8.0 (2019/10/09) ( ) (7289)
  • Upd: Others include cumulative minor updates, corrections and optimizations (7289)

New in dbMigration .NET 11.7 (Nov 4, 2019)

  • Add: Downward support PostgreSQL 8.0.x (compatible with Amazone Redshift) database system (7247)
  • Upd: Improved MariaDB version detection processing, affecting related functions (7247)
  • Fix: (Firebird) Fix the priority of the display of the Collation Name (7247)
  • Fix: (HP Vertica) Fixed AUTOINCREMENT type field syntax generation problem (7247)
  • Fix: (HP Vertica) Optimization long varchar/long varbinary Automatically correct length processing to avoid exceeding the preset maximum value when the source has no length specified (7247)
  • Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.112.0 (3.30.1) (2019/10/28) (7247)
  • Upd: Others include cumulative small updates, corrections and optimizations (7247)

New in dbMigration .NET 11.6 (Oct 21, 2019)

  • Add: High DPI scaling processing: Increase image (Icon) automatic scaling processing (7233)
  • Upd: High DPI scaling processing: Improved multiple text (Text) and control (Controls) automatic scaling processing (7233)
  • Upd: Auto-generating DEFAULT values ??of columns:
  • Upd: When the source is a text type, if the preset value has no single quotes, it will be added automatically (7233).
  • Upd: (MySQL) Remove data type ENUM/SET default value is null ''Processing (7233)
  • Upd: Filter source data/Showing target results:
  • Upd: Improved data type BigDecimal Output and Exception Issue Handling (7233)
  • Fix: Secure Shell Agreement (SSH: Secure Shell): Fixed an issue where settings could not be canceled after saving (7233)
  • Fix: (PostgreSQL 12) Resolve the problem of CHECK constraints due to v12 changes (7233)
  • Upd: (PostgreSQL) Supports database versions below <8.4, including related function handling (7233)
  • Fix: (PostgreSQL) Fix database version below <9.0, exclude built-in TRIGGERS object display (7233)
  • Upd: Others include cumulative small updates, corrections and optimizations (7233)

New in dbMigration .NET 11.5 (Oct 14, 2019)

  • Add Support for High DPI scaling (Support for High DPI scaling) (7226)
  • Support zoom ratio from 100%~300%+ above to automatically adapt display processing
  • Add Column Designer supports Collation Name setting processing (7226)
  • Support for databases such as SQL Server/SQL Azure/SQLite/PostgreSQL/Firebird/MySQL/NuoDB
  • Add Column Designer supports incremental type (Identity Type BY DEFAULT/ALWAYS) setting processing (7226)
  • Support for databases such as Firebird 4+/Oracle 12+/PostgreSQL 10+/NuoDB/IBM DB2/Teradata
  • Upd Greatly improved field editing window display processing (7226)
  • Fix Resolved a problem with the failure to read MATERIALIZED VIEW due to a PostgreSQL 12 change (7226)
  • Fix (PostgreSQL) Fixed MATERIALIZED VIEW unable to display UDT field type problem (7226)
  • Fix (Firebird) Automatically excludes connection exceptions (Error Code335544325) (7226)
  • Upd Others include cumulative small updates, corrections and optimizations (7226)

New in dbMigration .NET 11.4 (Sep 16, 2019)

  • Pd: Auto-generating FOREIGN KEYS of tables:
  • Add: Add reference primary key renaming ([UPD]Renamning Primary Key Table) (7198)
  • Fix: Fixed Update/Delete Rule conversion between different repositories (7198)
  • Fix: (HP Vertica) Fixed SQL query processing for obtaining different schema structure descriptions (Schema) (7198)
  • Add: Support for PostgreSQL 12.0 beta 4 database (7198)
  • Add: Supporting data table Adding prefix and suffix to tables (7198)
  • Upd: (SQL Server/SQL Azure/Sybase ASE) Improve all query (SELECT) encoding problem processing (7193)
  • Upd: Others include cumulative small updates, corrections and optimizations (7198)

New in dbMigration .NET 11.3 (Sep 9, 2019)

  • Update: Automatic generation of DEFAULT values ​​for columns:
  • Updates: Advanced processing of preset digital conversions (7191)
  • Update: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.1.1.0 (2019/09/05) () (7191)
  • Add: (PostgreSQL 12+) Support for generating scripts and computers for columns (7191)
  • Fix ((PostgreSQL / IBM DB2 / Informix) Remedy field NOT NULL Cannot get (7184)
  • Fixed: (PostgreSQL 10+) Fixed target field setting Default No effect (7184)
  • Update: Resolving the problem because it is NULL when the field is intended to change in NAME and may be involved is assigned (Default) (7184)
  • Update: Defined date table preview (SQL preview):
  • Fix: A care issue was resolved to continue generating unnecessary prompt messages after manually creating the default values ​​of the destination field (7184)
  • Updates: others including small cumulative updates, fixes and optimizations (7191)

New in dbMigration .NET 11.2.7184 (Sep 1, 2019)

  • Fix: (PostgreSQL/IBM DB2/Informix) Fixed field NOT NULL Unable to get (7184)
  • Fix: (PostgreSQL 10+) Fix target field setting Default Value No effect (7184)
  • Upd: Solve the problem that the source is NULL when the destination field is changed to NOT NULL and the default value is assigned (7184)
  • Upd: Datasheet definition preview ( SQL preview ):
  • Fix: Fixed an unnecessary prompt message after manually adding the preset value of the destination field (7184)
  • Upd: Others include cumulative small updates, corrections and optimizations (7184)

New in dbMigration .NET 11.2.7181 (Aug 30, 2019)

  • Upd: (SQL Server) Database settings will no longer be displayed when offline or without permission access (7181)
  • Fix: Fixed an issue where the contents of the command bar window could not be fully displayed (7181)
  • Upd: MySQL component version [return] to MySql.Data.dll 6.9.12 (2018/04/27)()(7171)
  • Upd: Others include cumulative small updates, corrections and optimizations (7181)

New in dbMigration .NET 11.1.7156.1 (Aug 5, 2019)

  • Add: Support for Oracle 19c Database System (7156)
  • Add: Support for NuoDB 4.0 Database System (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)

New in dbMigration .NET 11.0.7139.1 (Jul 19, 2019)

  • Upd: Automatic Mapping Types:
  •        Upd: If the source is Firebird, the destination database Decimal/Numeric and other data types must be at least 18 (7139).
  •     Upd: Filter source data:
  •        Fix: Fixed the problem that the main window may be closed directly after the auto-complete list is turned on (7139)
  •     Add: Added Dutch language interface display (7139)
  •     Upd: Provides a more complete error message display (7139)
  •     Upd: Optimize ODBC Dialog Display Processing (7139)
  •     Upd: [Secondary] Resolving problems with Unsupported startup parameter: extra_float_digits when PostgreSQL is connected via 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)

New in dbMigration .NET 10.9.7120.1 (Jul 1, 2019)

  • Add: Support PostgreSQL 12.0 beta 2
  • Add: Support PostgreSQL 12 Computing Columns
  • Updating: PostgreSQL
  • Fix: (Odbc)
  • Updating: Custom Mapping Types:
  • Add: (Odbc)
  • Upd (Oracle)
  • Updates: SQLite System.Data.SQLite.DLL 1.0.111.0 (3.28.0)
  • Updates: IBM DB2 / Informix IBM.Data.DB2.dll 9.7.4.4 (11.5.0.4)
  • Misc: (IBM DB2 / Informix) IBM data server client packages Version 11.5GA
  • Misc: Compatible with IBM DB2 11.5 GA

New in dbMigration .NET 10.8.7086 (May 27, 2019)

  • Add: Support for PostgreSQL 12.0 beta 1 database (7086)
  • Add: Support PostgreSQL 12 Computed Columns conversion processing (7086)
  • Upd: Improved detection of Firebird installation path, processing with exception characters (7086)
  • Upd: Others include cumulative small updates, corrections and optimizations (7086)

New in dbMigration .NET 10.8.7079.1 (May 20, 2019)

  • Add: (MySQL 8.0.16+/MariaDB 10.2.22+, 10.3.10+) Support CHECK Constraints related processing (7079)
  • Fix: Fixed partial database generation CHECK Constraints Problem with no data table name specified (7079)
  • Fix: Fixed an issue that caused exception handling when holding down Up/Down in the list of data sheets (7079)
  • Fix: Fixed data table and field list right-click menu [Rename] option not updated synchronously (7079)
  • Upd: Automatic Mapping Types:
  • 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)
  • Upd: BLOB is changed to BLOB(2G) when the destination database is DB2 (default is 1M) (7079)
  • Upd: Optimize ODBC and OleDB automatic matching processing (7079)
  • Fix: Solve the problem that the length of the field may change when automatically responding to different types (7079)
  • Fix: (Oracle) Fixed TIMESTAMP(x) WITH TIME ZONE conversion to TIMESTAMPTZ display error (7079)
  • Fix: (Teradata) Fixed an issue where some data types were not properly displayed in full format (7079)
  • Upd: Customized Mapping Types:
  • Upd: Improvement and correction [same] When the custom type has [different] length, the priority matching order problem (7079)
  • Upd: Improved when the custom type has a length, the icon (Icon)

New in dbMigration .NET 10.7.7071.3 (May 13, 2019)

  • Data Synchronization:
  • Upd: Supports source and destination field names when they are different (7071)
  • Fix: Fixed (7065) problem that caused the data table synchronization function to be disabled (7071)
  • Upd: Automatic Mapping Types:
  • Add: (ODBC) Short Type Names automatically convert to long data type display (7071)
  • Fix: (Firebird) Fix ARRAY data type [LOWER:UPPER] BOUND Full display (7071)
  • Upd: (Oracle/PostgreSQL/HP Vertica/NuoDB) Data Table Rebuild Added CASCADE Delete Correlation Processing (7071)
  • Add: (MySQL) Preset to join the Keep Alive connection settings, to avoid idle time when the remote connection is idle, resulting in automatic interrupt (7071)
  • Add: (SQL Server) (Connection Profile): Add <Attach a database...>Additional Database Processing (7071)
  • Upd: Improved Commit/Rollback Transaction exception handling (7071)
  • Fix: Solve the problem that the program exits abnormally after selecting Create a new connection via [Keyboard movement direction key] (7071)
  • Upd: Others include cumulative small updates, corrections and optimizations (7071)

New in dbMigration .NET 10.6.7065.1 (May 6, 2019)

  • Upd: (SQL Server/SQL Azure) Automatically converts to (max) when the field length exceeds the default. char/binary/varchar/varbinary(>8000), nchar/nvarchar(>4000)(7065)
  • Upd: (SQL Server/SQL Azure) Automatically converts to (max) processing when the same data type but no length value char/binary/varchar/varbinary/nchar/nvarchar(max)(7065)
  • Upd: Optimize automatic conversion to long data type processing, when the source Char data type length exceeds the maximum value of the destination data type (7065)
  • Upd: (NuoDB) varchar automatically converts to clob processing when there is no length (7065)
  • Upd: Improve long string data type conversion processing speed (7065)
  • Add: Field Work Column Adds a Data Types Reference link for quick access to data types (7065)
  • (SQL Server/SQL Azure) Add and update field data type to add varchar(max)/varbinary(max)/nvarchar(max) exemplified item (7065)
  • Upd: (Firebird) Remove unsupported data types for different database versions (7065)
  • Upd: (Access/Excel/dBase/Text) Supports different component versions Provider automatic switching processing to improve compatibility and connectivity (7065)
  • Upd: When the destination database is MySQL, the data type is BLOB, TEXT, GEOMETRY or JSON will automatically exclude the Default Value setting (7065)
  • Upd: When the destination database is Vertica, the data type is LOB will automatically exclude the Default Value setting (7065)
  • Fix: Missing $ character in the data table when the destination database is Excel, causing problems that cannot be processed normally (7065)
  • Fix: The destination repository is an Oracle solution ORA-01704 error, due to a source string of more than 4000 characters (7059)
  • Upd: Avoid the problem that the contents of the error message dialog box is out of the display range (7065)
  • Upd: Others include cumulative small updates, corrections and optimizations (7065)
  • Upd: Compatible with Microsoft Windows 10 (1903) (7065)

New in dbMigration .NET 10.5.7058.1 (Apr 30, 2019)

  • Add: Supports Find in List: Matches objects will be displayed in text depth (7058)
  • Shortcut Keys: Focus Ctrl+F, Find Next F3 or Enter
  • Upd: Automatic Mapping Types:
  • Add: (PostgreSQL) Add varbit(bit varying) data type processing (7058)
  • Upd: Optimize Character field type automatic matching processing (7058)
  • Upd: Auto-generating DEFAULT values ??of columns:
  • Add: (FoxPro) supports Logical data type .T.=True, .F.=False conversion processing (7058)
  • Upd: Automatically convert text presets to quotes with double quotes (") to single quotes (') (7058)
  • Add: Increase source and destination database version display (7058)
  • Fix: (SQL Server/SQL Azure) Fix the problem of obtaining the source of Computed Columns (7058)
  • Upd: Others include cumulative small updates, corrections and optimizations (7058)

New in dbMigration .NET 10.4.7044.1 (Apr 15, 2019)

  • 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)
  • Fix: Fixed issue where the Decimal of Byte() type could not be converted when the source was (PostgreSQL) (7044)
  • Fix: The problem is solved by (MySQL) Unable to handle Decimal over precision > 28-29 (7044)
  • Upd: Improved error message display processing, avoiding the same error repeated display (7044)
  • Upd: Command-Line Processing:
  • Add: (FoxPro) In addition to the default xxx.dbc, it also supports the specified single file xxx.dbf or multiple files *.dbf import processing (7033)
  • Srctype:3 -src:"c:xxx.dbc" (A database container)
  • Srctype:3 -src:"c:xxx.dbf" (Single dbf file)
  • Srctype:3 -src:"c:*.dbf" (Multiple dbf files)
  • Upd: Missing the original GUI function: Automatically create an external index data table when all data tables have been converted (7033)
  • Upd: Avoid pop-up prompt window when automatic import (*.dbf) processing fails when using the -log parameter (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)

New in dbMigration .NET 10.3.7033.1 (Apr 4, 2019)

  • Upd: Command-Line:
  • Add: (FoxPro) In addition to the preset xxx.dbc, it also supports the specified single file xxx.dbf or multiple files *.dbf import processing (7033)
  • Srctype:3 -src :"c:xxx.dbc" (A database container) -srctype:3 -src:"c:xxx.dbf" (Single dbf file)
  • Srctype:3
  • Src:"c:*.dbf" ( Multiple dbf files)
  • Upd: Missing join original GUI function: Automatically create external index data table when all data table conversion is completed (7033)
  • Upd: Other contains accumulated small update, correction and optimization processing (7033)

New in dbMigration .NET 10.3.7016.1 (Mar 18, 2019)

  • Upd: Connection inventory management ( Connection List ):
  • Fix: problem solving library or path contains exceptions characters (including : Connection Profile (7016)
  • Upd: Update Security Protocol ( Tls11/Tls12 /Tls/Ssl3) (7016)
  • Upd: Add error message display, when the data sheet cannot be read (7016)
  • Fix : Fixed field list right-click menu Parse enabled state (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)

New in dbMigration .NET 10.2.7002.1 (Mar 4, 2019)

  • Upd: Large optimization of user interface (User Interface) controls and text font display (7002)
  • Fix: Resolve an issue that is unusually slow if you cannot read data from a database type such as System.Decimal or System.DateTime (7002)
  • Upd: Optimize Automatic Mapping Types (7002)
  • Upd: compatible with Windows 10 Insider Preview 18305 and higher Latest version (6967)
  • Fix: (NuoDB) Fixed a problem with the format of the field length generated by DECLARED_TYPE (6967)
  • Upd: Secure Shell Agreement (SSH: Secure Shell):
  • Add: Support for private key with password (Private key with a password) (6960)
  • Fix: Fixed an issue that could not handle remote SSH (6959)
  • Upd: Others include cumulative small updates, corrections and optimizations (7002)

New in dbMigration .NET 10.1.6967 (Jan 28, 2019)

  • Upd: compatible with Windows 10 Insider Preview 18305 and higher Latest version (6967)
  • Fix: (NuoDB) Fixed a problem with the format of the field length generated by DECLARED_TYPE (6967)
  • Upd: Secure Shell Protocol ( 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)
  • Upd: Others include cumulative small updates, corrections and optimizations (6967)

New in dbMigration .NET 10.1.6959 (Jan 20, 2019)

  • Main program update ( Main ):
  • Fix: Secure Shell Protocol ( SSH: Secure Shell ): Fixed an issue where remote SSH could not be handled (6959)
  • Upd: Others include cumulative small updates, corrections and optimizations (6959)
  • Data Import :
  • Fix: Correct the data sheet data import source name designation problem, avoiding the change caused by other processing (6959)
  • Table Designer :
  • Fix: (Oracle) Resolving issues that may cause ORA-01451 when modifying field types (6959)

New in dbMigration .NET 10.1.6953.1 (Jan 14, 2019)

  • Upd: Automatically generate [ Auto-generating COMMENTS of tables and columns ]:
  • Add: Added support for VistaDB database (6953)
  • Add: Support for Computed Columns conversion processing (6946/6953)
  • Support includes: Access (accdb/accde) / Firebird / MySQL / SQL Server / SQL Azure / Sybase ASE and other databases
  • Exclusive new support: Access (accdb/accde) source database processing (without destination database) (6953)
  • Upd: Update Secure Shell Protocol ( SSH: Secure Shell ): PrivateKey is saved in relative position (same as DBNet) (6953)
  • Fix: (Access) Fixed an issue where system database processing was not included when opening a password database (6953)
  • Upd: Automatic Mapping Types :
  • Upd: Optimize the automatic matching of numeric types. When there is no corresponding data type, it will be able to automatically match the data type to the closest length (6946).
  • Upd: Command Line Processing ( Command-Line ):
  • Upd: When using the -log parameter, if there is an unfinished data table after the program ends, the prompt window will no longer pop up (6946)
  • Upd: (FoxPro) Simplified database open method *.dbc;*.dbf merge processing (6946)
  • Upd: Others include cumulative small updates, corrections and optimizations (6953)

New in dbMigration .NET 9.9.6918.2 (Dec 12, 2018)

  • Upd: Command-Line Processing:
  • Add: Add Excluding View Objects: -tableonly (6918)
  • Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.11 (2018/12/04) (6918)
  • Upd: Others include cumulative small updates, corrections and optimizations (6918)

New in dbMigration .NET 9.9.6908.1 (Dec 3, 2018)

  • Upd: Command Line Processing ( Command-Line ):
  • Upd: When there is no write permission in the directory where the -log mode is used, it will be automatically updated to the location of the AppData configuration file
  • Upd: In the -log mode, when the recovery window is displayed and canceled, you can choose to skip or cancel the processing completely
  • Fix: Fixed the problem that the cancel button of the progress window is difficult to be clicked when the database is continuously switched in the -log mode
  • Upd: [same type] library object migration ( Migrating VIEW/PROCEDURE/FUNCTION/SEQUENCE definitions ):
  • Add: (MariaDB 10.3.5+) Supports PACKAGES object migration processing
  • Upd: (PostgreSQL/MySQL) Increase the detection and processing of the destination database support
  • Add: (FoxPro) supports Foreign Keys object correlation processing
  • Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.4040.4)
  • Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.4 Fix Pack 4
  • Upd: Others include cumulative small updates, corrections and optimizations

New in dbMigration .NET 9.8.6869.1 (Oct 22, 2018)

  • Upd: Support for PostgreSQL 11 RTM database system (2018/10/18) (6869)
  • Upd: [same type] library object migration ( Migrating VIEW/PROCEDURE/FUNCTION/SEQUENCE definitions ):
  • Add: (PostgreSQL 11) Support Store Procedures Stored Program Object Migration Processing (6869)
  • Upd: (PostgreSQL) Optimizing Functions Function Object Migration Processing (6869)
  • Upd: 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 position, convenient for portable version mobile processing (6869)
  • Fix: Fix the question when the [Servo Database] is connected, and if you click Cancel, it will continue to be processed (6869)
  • Upd: Command Line Processing ( Command-Line ):
  • Upd: When -defopt:xxx is set but the destination data table does not exist, it will be automatically created and continue processing (6869)
  • Fix: (PostgreSQL) Fixed (6862) Numeric data type (6869) that could not be processed [without specified length]
  • Fix: (Excel/Text) Fixed a problem with no prompt message when the connection [source] file no longer exists (6869)
  • Upd: Improved error column number and source data message when the conversion process is wrong (6869)
  • Upd: VistaDB component version updated to VistaDB.5.NET40.dll 5.7.4 (2018/10/14) (6869)
  • Upd: Others include cumulative small updates, corrections and optimizations (6869)

New in dbMigration .NET 9.7.6862.1 (Oct 15, 2018)

  • Upd: Connection Profile :
  • Add: (Firebird) Add Character Sets List to simplify setup issues (6862)
  • Upd: (Firebird) [New Library] The default encoding is changed to UTF8 and allowed to be modified in the property page (6862)
  • Fix: (Firebird) [Embedded] Fixed an error that the test did not continue if it was processed directly (6862)
  • Upd: (Oracle) supports complete field type display and conversion processing such as Number(*,x), Number(x,-x) (6862)
  • Upd: (Oracle) Improved alternative handling when SEQUENCES cannot be generated (6862)
  • Upd: (NuoDB) Supports Number Scale x field type display and conversion processing (6862)
  • Fix: (NuoDB) Fix and update field data type generation method (6862)
  • Upd: Improved source data table field type Numeric(x)/Decimal(x) Conversion processing without (Scale) (6862)
  • Upd: Others include cumulative small updates, corrections and optimizations (6862)

New in dbMigration .NET 9.6.6853.1 (Oct 6, 2018)

  • Add: Connection settings New structure description (Schemas) automatic exampleSupport IBM DB2/Informix/PostgreSQL/HP Vertica/NuoDB databaseAdd: Connection settings New Databases automatically: Support Informix/HP Vertica and other databasesUpd: Improve the user experience: Icon (Icon) level can display node objects to complete loading
  • Upd: Improved user experience: Optimized processing of the user interface (UI)
  • Fix: Improve compatibility issues and avoid accidental unboots
  • Upd: Compatible with Compatible with Microsoft Windows 10 (1809)
  • Upd: Others include cumulative small updates, corrections and optimizations

New in dbMigration .NET 9.5.6844 (Sep 27, 2018)

  • Resolution Decimal Number Configuration Type Super Pas Over Time Temporal Processing Efficiency Problem (6844)
  • Update: Other comprehensive cumulative small update, refurbishment Wang Zhuang (6844)

New in dbMigration .NET 9.5.6836.1 (Sep 19, 2018)

  • Customize the corresponding Mapping Types:
  • Upd: Optimized update processing: Only the data table field update processing is performed when the change is made, and no reset processing is performed any more (6836)
  • Fix: Fixed an issue that was not automatically updated when the data sheet was recorded but re-selected (6836)
  • Upd: Auto-generating DEFAULT values of columns:
  • Upd: Optimized date preset processing: Automatic matching of similar date type presets (6836)
  • Fix: Fixed an issue where the same type of database was not supported (6836)
  • Upd: (Firebird) Improvement (6806) When the same instance is not enabled, the prompt message is displayed when using different fbembed.dll/fbclient.dll components (6836)
  • Add: Right-click menu to increase the current data table sub-option (Refresh this table) (6836)
  • Upd: Resolve the DataGridView control. When the field name contains a comma(,) character, clicking the field sort will cause an exception (6836)
  • Upd: Others include cumulative small updates, corrections and optimizations (6836)

New in dbMigration .NET 9.3.6820.1 (Sep 3, 2018)

  • 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)
  • Upd: (Oracle) Preset [Enable] change destination database [integrated] data table and column case (Change global table and column case ) (6820)
  • Fix: (Oracle) Bulk Copy Mode : Fixed an issue where DATABASENAME was not specified (6820)
  • Upd: (Oracle) Automatic Mapping Types : Change to Number type when the source type is Boolean (6820)
  • Upd: Filter source data :
  • Upd: Open to general users [Preview Query] Source Data Sheet (6820)
  • Upd: Improve user experience and provide more intuitive operation (6820)
  • Upd: (Sybase ASE) Optimize Connection Profile: Increase the 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)
  • Upd: (ODBC/OleDB) Supports processing when the field attribute contains the identity keyword (6820)
  • Add: (SQL Server 2000) Support for the generation of CHECK constraints (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)

New in dbMigration .NET 9.2.6806.1 (Aug 20, 2018)

  • Add: Support for PostgreSQL 11 beta database system
  • Upd: Auto-generating DEFAULT values ​​of columns :
  • Add: Increase the Boolean type preset value automatically generated to the destination field processing
  • Fix: (ODBC/OleDB) Fixed field type parsing problem when the field contains the identity string
  • Fix: (ODBC/OleDB) Fixed an issue where the source data table could not get the datasheet message if it contained SCHEMA and the Quoted Identifiers was empty
  • Fix: (FoxPro) Fixed (6792) Preset quote string change, causing the problem that the field could not be displayed properly ()
  • Upd: (Sybase ASE) Modify the default text size processing (Default Text Size: 32KB->2GB)
  • Upd: Allows Firebird Embedded to open a database with different fbembed.dll/fbclient.dll components in the same instance
  • Upd: Others include cumulative small updates, corrections and optimizations

New in dbMigration .NET 9.1.6792.1 (Aug 6, 2018)

  • Add: Auto-generating CHECK constraints of tables
  • Ability to automatically generate check condition constraint processing for [field exactly match]
  • Add: Auto-generating DEFAULT values ​​of columns
  • Ability to automatically generate [non-function] preset values ​​to destination field processing
  • 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
  • Upd: (Access/Excel/Text/dBASE/FoxPro) Preset quote string ``replace with [] instead
  • Add: (SQLite) supports FTS5 data table conversion processing
  • Fix: Fixed a problem that caused a subsequent processing exception when a data table field could not be obtained normally (6792)
  • Upd: Improved Field Editing Window Property Enable Status Update
  • Upd: Others include cumulative small updates, corrections and optimizations

New in dbMigration .NET 9.0.6785.1 (Jul 30, 2018)

  • Add: Add [Showing TABLE/VIEW types in tooltip] and display it in different colors (6785)
  • Partitioned Table/Temporary Table/FileTable/Memory-Optimized Table/SQL Graph Table
  • Linked Table/Access Table/Foreign Table/Virtual Table/Materialized View
  • Add: (PostgreSQL 9.1+) Supports the migration of Foreign tables data sheets (6785)
  • Add: (PostgreSQL 10+) Supports Partitioned tables data sheet migration (6785)
  • Fix: (ODBC/OleDB) Fixed an issue where the source data table contained SCHEMA and was not specified when the related object was obtained (6785)
  • Fix: (DB2) Fixed an issue where CHAR() FOR BIT DATA, VARCHAR() FOR BIT DATA and other data types could not be processed (6785)
  • Fix: (VistaDB) Fixed Views object field getting problem (6785)
  • Fix: Improved problem when the definition of the data type length (n) is not at the end (6785)
  • Upd: Others include cumulative small updates, corrections and optimizations (6785)

New in dbMigration .NET 8.9.6778.1 (Jul 23, 2018)

  • Add: Corresponding to the destination column table name ( Frame column names ): Add to the work column re-brush button split option (6778)
  • Add: Table Properties : Add sub-options for the command line generation to the scrapbook (Sub-Button->CMD) (6778)
  • Fix: Fixed an issue where the field name could not be displayed and processed when the field name contained an exception character (6778)
  • 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)
  • Upd: Others include cumulative small updates, corrections and optimizations (6778)

New in dbMigration .NET 8.8.6746.1 (Jun 21, 2018)

  • Add: support for mapping column names from the target table (6746)
  • Corresponds to predefined data table field names, eliminating the need to manually change names one by one.
  • Upd: Display in different colors when source and destination fields have different names (6746)
  • Upd: Distinguishing NULL value from 'NULL' string processing preview display processing (6746)
  • Add: (Firebird) Support to reopen Shutdown database files (6746)
  • Fix: (ODBC/OleDB) Avoid nullchar when returning Quoted Identifiers characters (6746)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6746)

New in dbMigration .NET 8.7.6733.1 (Jun 8, 2018)

  • Upd: Change destination database [Overall] table and column case (Change global table and column case ):
  • Fix: Fixed an issue that was not updated after the update of the [selected] data table (6733)
  • Upd: Improved interrupt handling, improved processing speed and avoid unnecessary follow-up actions (6733)
  • Upd: Improve the user experience. Clicking to exit the program when a data sheet is selected will be confirmed again (with interrupted connection) (6733)
  • Upd: After the Splash Form opens and ends, return to the issue of the owning window (6733)
  • Fix: Fixed an issue where the original new data table was not deleted when [Cancel] was clicked instead of [Continue] when the conversion process was interrupted (6733)
  • Upd: Improved Data Sheet List Right-click Menu (Filter/Results) Enable Status (6733)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6733)

New in dbMigration .NET 8.6.6726.1 (Jun 1, 2018)

  • Upd: Automatic Mapping Types:
  • Upd: Improved Datetime/DatetimeTz/Timestamp/TimestampTz Automatic Matching Processing (6726)
  • Upd: Bulk Copy Mode:
  • Upd: (IBM DB2/Informix) Supports SCHEMA Case Differentiation Import Processing (6726)
  • Upd: (Firebird) Connection Settings Enable Status Updates When the Default/Embedded Option Switches (6726)
  • Upd: Optimize 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)

New in dbMigration .NET 8.5.6718.1 (May 24, 2018)

  • Upd: Transaction mode data migration processing (6718) Improve the overall performance due to the number of conversion fields, which can significantly increase the processing speed by 50%+.
  • Upd: Optimize DateTime and DateTimeOffset Date Resolution Processing (6718)
  • Add: Add Save Window Record Function (Save -> Output Window History) (6715)
  • Fix: (ODBC/OleDB) Resolve issues associated with default Quoted Identifiers characters in the database (6715)
  • Fix: Avoid the problem that the main window cannot be focused after waiting for the window to end in some cases (6715)
  • Upd: Others include cumulative minor updates, corrections, and optimizations (6718)

New in dbMigration .NET 8.4.6715.1 (May 21, 2018)

  • Add: increase save output window record function (Save -> Output Window History)
  • Fix: (ODBC/OleDB) Resolve issues associated with the library's absence of a default Quoted Identifiers character
  • Fix: Avoid the problem that the main window cannot be focused after waiting for the window to end in some cases
  • Upd: Others contain cumulative minor updates, corrections, and optimizations

New in dbMigration .NET 8.4.6698.1 (May 4, 2018)

  • Add: Supported MySQL 8.0 GA Data source line (6698)
  • Supported latest Caching SHA - 2 Pluggable Authentication Insertion test connection linkage (6698)
  • Upd: [Similar type] Data storage transition (Migrating VIEW / PROCEDURE / FUNCTION / SEQUENCE definitions)
  • Upd: (Oracle) Join automatic repair coordination ORA - 39212 mistake time method (6698)
  • Upd: During the execution process Young changeover Completion equation, after completion completion changeover principal equation, avoidance influence door Experiment (6698)
  • Upd: Reformed Dynamite Talking Story Showing Positioning Ordering Order Problem (6698)
  • Upd: Bulk Copy Mode:
  • Upd: (Oracle) Revised OCI Location Automatic Measurement (6698)
  • Upd: MySQL Primary version Book Update MySql.Data.dll 6.9.12 (2018/05/02) (6698)
  • Upd: Including inclusion inclusion brief update, revision and offerment superiority (6698)
  • Misc: Compatible with Microsoft Windows 10 (1803) ()

New in dbMigration .NET 8.3.6677.1 (Apr 13, 2018)

  • Upd: Connection List:
  •       Fix: Fixed (6664) Problems that occurred when the internal database could not be upgraded after startup when it was not the first time to start and there was no history list (6677)
  •    Upd: 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 waits when the connection failed (6677)
  •       Upd: Avoid changing settings due to automatic reading of existing settings with the same name when updating the Profile Name process (6677)
  •    Upd: (Oracle) Solve the problem that when the database encoding is not UTF (8/16) and the client code is non-English, the error message is garbled (6673)
  •    Upd: (MySQL) Forces the connection property setting (Allow Zero Datetime=False) and removes it from the settings to avoid causing the conversion to fail (6673)
  •    Add: (SQLCe) Support [Purpose] Data Sheet Identity Attribute Increment Retention Processing After Conversion (6673)
  •    Add: (VistaDB) Support [Source] Data Sheet Identity Property Increment Value Acquisition (6673)
  •    Upd: Others include cumulative minor updates, corrections, and optimizations (6677)

New in dbMigration .NET 8.2.6673.2 (Apr 9, 2018)

  • 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 garbled (6673)
  • Upd: (MySQL) Forces the connection property setting (Allow Zero Datetime=False) and removes it from the settings to avoid causing the conversion to fail (6673)
  • Add: (SQLCe) Support [Purpose] Data Table Identity Property Increment Retention Processing After Conversion (6673)
  • Add: (VistaDB) Support for [Source] Identity Property Increment Value Get(6673)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6673)

New in dbMigration .NET 8.2.6664.1 (Mar 31, 2018)

  • Upd: Connection List :
  • Add: Description of connection items (6664)
  • Add: Support shortcut key Enter processing (6664)
  • Add: Support shortcuts Copy + C copy command line processing (6664)
  • Add: support for Del key delete processing (6664)
  • Add: Support Multiple Selection (6664)
  • Upd: Removes the original MRU menu-style connection item, completely replaced by Listed Connection List Management (6664)
  • Upd: Remove 50 restrictions, change to unlimited number of connections (6664)
  • Add: Column Designer: Add Date Data Type Preset Dropdown (6664)
  • Add: Add [All] Delete Connection Confirmation Dialog Box Display (6664)
  • Upd: Command-Line : Improved Parameter Precedence Order Question (6664)
  • 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: Title shows current connection project name (6664)
  • Upd: Optimized Startup Speed ​​and Interrupt Connection Speed ​​(6664)
  • Upd: Others contain cumulative minor updates, corrections, and optimizations (6664)

New in dbMigration .NET 8.1.6655.1 (Mar 22, 2018)

  • Upd: Automatic Mapping Types:
  •       Upd: (Sybase ASE) Improved automatic matching of data types such as unitext, univarchar, unichar (6655)
  •       Upd: (Firebird) Improved blob sub_type 1 Automatic Matching of Data Types (6655)
  •       Upd: (FoxPro) Improved memo, general and other data type automatic matching processing (6655)
  •       Upd: (Access) Improvements Automatic matching of data types such as varbinary, bigbinary (6655)
  •       Upd: (MySQL) Improved automatic matching of bit data types (6655)
  •       Upd: Exclude duplicate data types, optimize processing speed (6655)
  •    Upd: (Sybase ASE) When the data type is BOOLEAN, it is automatically changed to NOT NULL to comply with the database specification (6655)
  •    Upd: (Oracle) Update TIMESTAMP Data Type Maximum Length Limit (6655)
  •    Upd: (SQL Server/SQL Azure/Sybase ASE) Add Default Schema Name Specify (6652)
  •    Fix: Exception handling when field length is MAX (6652)
  •    Upd: IBM DB2/Informix Component Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.3030) (2018/03/07) (6652)
  •    Upd: Others contain cumulative minor updates, corrections, and optimizations (6655)

New in dbMigration .NET 8.0.6652.2 (Mar 19, 2018)

  • Upd: (SQL Server/SQL Azure/Sybase ASE) Add Scheduled Schema Name Assignment (6652)
  • Fix: Exception handling when field length is corrected (6652)
  • Upd: IBM DB2/Informix Component Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.3030) (2018/03/07) (6652)
  • Upd: Other contains cumulative minor updates, corrections, and optimizations (6652)

New in dbMigration .NET 8.0.6645.1 (Mar 12, 2018)

  • Upd: Bulk Copy Mode:
  •        Add: Support Oracle database bulk copy mode processing (6645)
  •        Databases such as SQL Server/SQL Azure/IBM DB2/Informix/NuoDB/Oracle are now supported
  •     Upd: Command-Line Processing:
  •        Upd: The [Any] Window Is No Longer Displayed When Setting the -log Parameter (6645)
  •     Add: (PostgreSQL 10) Supports MacAddr8 Data Type Handling (6645)
  •     Upd: Update the new database preset extension name: (SQLite) *.db, (Firebird) *.fdb(6645)
  •     Upd: Others contain cumulative minor updates, corrections, and optimizations (6645)

New in dbMigration .NET 7.9.6640.1 (Mar 7, 2018)

  • Add: Displaying a progress indicator in a taskbar button (6640)
  •     Upd: Bulk Copy Mode:
  •        Upd: Allows you to cancel the destination IDENTITY field for automatic incrementing processing (6640)
  •        Upd: Improve [delete new] and [add new] ... and other processing (6640)
  •     Upd: Command-Line:
  •        Upd: no progress window is displayed when setting the -log parameter (6640)
  •     Upd: Connection List Management:
  •        Upd: New Project If the connection fails, it will not be added to the list (6640)
  •     Upd: Automatic Mapping Types:
  •        Upd: If the field type is maximum, the length is no longer displayed (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)

New in dbMigration .NET 7.8.6635.1 (Mar 2, 2018)

  • Add: New Settings [Options -> Change the global case of target objects as database default] (6635)
  • Upd: Improved delete data column conversion processing functions: Increase the detection of the Identity field to deal with the relevant issues (6635)
  • Upd: Save Session: Add Change [Purpose] SCHEMA automatically update processing, no need to reset (6635)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6635)
  • Upd: Connection List Management:
  • Upd: When SCHEMA has changed, it will automatically update the original connection project, to avoid adding new processing (6635)
  • Upd: Optimize the manifestation of the list, emphasizing the source and purpose of the object (6635)
  • Upd: Bulk Copy Mode:
  • Upd: Support BulkCopy Timeout timeout processing, set the same transaction mode (Options -> CommandTimeout) (6635)

New in dbMigration .NET 7.7.6627.1 (Feb 21, 2018)

  • Add: Support [Same Type] Library Items TRIGGER Migrations (6627):
  • Support includes databases such as Firebird / SQLite / MySQL / SQL Server / SQL Azure / Sybase ASE / Teradata / NuoDB / PostgreSQL / IBM DB2 / Informix
  • Upd: Data Sheet Definition Preview (SQL preview):
  • Add: Support for SQL Syntax Highlighting display processing (6627)
  • Upd: Automatic Mapping Types:
  • Add: The type of data used to automatically match AUTOINCREMENT (6627)
  • Upd: Optimization BOOLEAN (BIT) Data Type Matching Processing (Maximum length int64 supported) (6627)
  • Fix: UDT Type Appear Unnecessary Length When Fixing Same Source and Destination Database (6627)
  • Upd: customize the corresponding type of data (Custom Mapping Types):
  • Fix: fixed source (UDT) type does not match the source when the same source database (6627)
  • Fix: fixed UDT case the difference between the same can not be a normal match (6627)
  • Upd: Automatically refresh after updating (6627)
  • Upd: Change Purpose Database [Overall] Changing global table and column case:
  • Upd: When the source and destination databases are the same, the related processing is handled by database default case (6627)
  • Upd: Connection List Management:
  • Upd: update the connection list the number of restrictions from 20 -> 50 (6627)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6627)

New in dbMigration .NET 7.6.6624.1 (Feb 19, 2018)

  • Fix: (Text) Delimited Text: Solve for very large files that do not work properly when not in CSV-separated characters (6624)
  • Upd: (Text) Purpose Data Sheet Name Automatically exclude all custom delimited file extensions (6624)
  • Fix: Fixing issues that may cause SqlTransaction is no longer usable (6624)
  • Upd: customize the corresponding type of data (Custom Mapping Types):
  • Add: Support Source Custom Type Matching with Length (6624)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6624)

New in dbMigration .NET 7.5.6612.2 (Feb 6, 2018)

  • Add: Support Change Purpose Database [Global] Data Sheet & Field Name Case (6611/6612)
  • Fix: Fixing Auto-Matching Problems with Self-Containing Data Types with Lengths (6612)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6612)

New in dbMigration .NET 7.4.6603.1 (Jan 29, 2018)

  • Upd: Automatic Mapping Types:
  •        Upd: (MySQL) Purpose To replace BLOB preprocessing with LONGBLOBs (6603)
  •        Fix: (Firebird) The source of the fix is blob sub_type 1 Automatic matching process (6603)
  •     Upd: Connection List Management:
  •        Upd: Optimize the list display and update right-click menu function (6603)
  •     Upd: Automatically generate foreign keys:
  •        Add: (MySQL) to version 5.0 database support (6603)
  •     Upd: (MySQL) When the server side encoding utf8mb4, if the Client default is automatically modified with the Server side consistent (6603)
  •     Upd: (MySQL) data table to establish the default encoding to Server-side settings encoding to simplify the relevant processing (6603)
  •     Fix: solve the problem when the focus in the Properties page (Properties), click ENTER can not be saved (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)

New in dbMigration .NET 7.3.6597.1 (Jan 23, 2018)

  • Add: New Connection List: More intuitive and convenient management of the connection list (6597)
  •     Upd: Automatic Mapping Types:
  •        Upd: Optimize timestamp / timestampz / timestamp xxx automatic matching process (6597)
  •     Upd: Optimize and Improve Control Compatibility and Display Issues (6597)
  •     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)
  •     Upd: Others Including Cumulative Minor Update, Correction and Optimization (6597)

New in dbMigration .NET 7.2.6593.1 (Jan 19, 2018)

  • 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)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6593)

New in dbMigration .NET 7.2.6585.1 (Jan 11, 2018)

  • Upd: Wait for reform etc
  •     Upd: Secure ownership Import / provision installation, support [before / after] Susumu blank alphabetical character (6585)
  •     Upd: (SQL Server / SQL Azure) Revolution Microsoft.SqlServer.Types.dll [Existence / Existence] Type Changeover (6585)
  •     Upd: (SQLite) Revised AES 256 Confined Data Bin [New Build] Methodology (6585)
  •     Upd: Filter source data / Showing target results:
  •        Add: Increase [Non-.NET internal] Document type documentation (6585)
  •     Upd: Data sheet material Data Synchronization:
  •        Add: Subscription purpose table field column presence existence or nonexistence 檢 measurement (6578)
  •     Add: (SQLite) Supported SQLite AES 256 Confined Data Storage Conversion (Simultaneously Supported AES 256 / RC 4 Confined Data Storage) (6578)
  •     Upd: Including inclusion inclusion brief update, revision and offerment superiority (6585)

New in dbMigration .NET 7.1.6578.2 (Jan 4, 2018)

  • Add: (SQLite) Supports SQLite AES256 Encrypted Database Conversion (Simultaneous AES256 / RC4 Encryption Library) (6578)
  • Upd: Data Synchronization :
  • Add: Add to Destination Datasheet Field Presence Checks (6578)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6578)

New in dbMigration .NET 7.1.6576.1 (Jan 2, 2018)

  • Upd: Automatic Mapping Types:
  • Upd: Dramatically Improve and Optimize Custom Type (UDT) Automated Match Processing (6576)
  • Upd: customize the corresponding data types exclude built-in cast (6576)
  • Upd: customize the corresponding type of data (Custom Mapping Types):
  • Add: Support [Source] Database Custom Data Type Setting (Same Object Database) (6576)
  • Upd: (Access / Excel / dBASE / Text) Supports Different Component Versions Provider Auto-Switch Processing to Improve Compatibility and Connectivity (6576)
  • Fix: (Firebird) Bug Fix message still appears when the machine is not installed (6576) when connecting to remote database
  • Fix: Correction connection settings database [path] may exist if there is no problem (6576)
  • Upd: index to change after the conversion is completed to improve the overall conversion speed (6576)
  • Upd: Enable to choose whether or not to overwrite the old settings when a new server version name already exists (6557)
  • Fix: Fixed TOP [n] conversion display is not the right ratio when the source set the number of columns (6557)
  • Upd: Bulk Copy Mode:
  • Upd: Support NuoDB conversion progress ratio display (6557)
  • Upd: Firebird Symbol Version Updated to FirebirdSql.Data.FirebirdClient.dll 5.12.1.0 (2017/12/22) (6576)
  • Upd: IBM DB2 / Informix Symbol Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.2022) (2017/12/07) (6576)
  • Upd: Others Including the cumulative minor updates, amendments and optimization (6576)

New in dbMigration .NET 7.0.6557.2 (Dec 14, 2017)

  • Upd: Enable to choose whether or not to overwrite the old settings when a new server version name already exists (6557)
  •     Fix: Fixed TOP [n] conversion display is not the right ratio when the source set the number of columns (6557)
  •     Upd: Bulk Copy Mode:
  •        Upd: Support NuoDB conversion progress ratio display (6557)
  •     Upd: Others Including Cumulative Minor Update, Correction and Optimization (6557)

New in dbMigration .NET 7.0.6547.1 (Dec 4, 2017)

  • pd: Data Synchronization :
  • Upd: Optimizing Content Synchronization (6547)
  • Upd: Multiple Controls Rewrite and Optimize (6547)
  • Upd: Bulk Copy Mode :
  • Add: Adding Support for IBM DB2 / Informix / NuoDB (6544)
  • Currently supports SQL Server / SQL Azure / IBM DB2 / Informix / NuoDB
  • Upd: Transaction mode processing speed (6544)
  • Upd: Automatic Mapping Types :
  • Fix: (Sybase ASE) Fixed (max) invalid data type length generation (6544)
  • Fix: Correction and Improvement Servo Edition Database Password Expiration Update (6544)
  • Upd: Others Including Cumulative Minor Update, Correction And Optimization (6547)

New in dbMigration .NET 6.9.6544.2 (Dec 1, 2017)

  • Upd: Bulk Copy Mode:
  • Add: Adding Support for IBM DB2 / Informix / NuoDB (6544)
  • Currently supports SQL Server / SQL Azure / IBM DB2 / Informix / NuoDB
  • Upd: Transaction mode processing speed (6544)
  • Upd: Automatic Mapping Types:
  • Fix: (Sybase ASE) Fixed (max) invalid data type length generation (6544)
  • Fix: Correction and Improvement Servo Edition Database Password Expiration Update (6544)
  • Upd: Others Including Cumulative Minor Update, Correction and Optimization (6544)

New in dbMigration .NET 6.9.6540.2 (Nov 27, 2017)

  • Add: Supports Bulk Copy Mode, a hundredfold (> 100%) faster than normal transaction processing (6540)
  • When the purpose of the database for SQL Server or SQL Azure can choose whether to use Bulk Copy (Bulk Copy) approach
  • Upd: Command-Line:
  • Add: Bulk Copy Parameter: -bulkcopy (6540)
  • Add: Support Source Data Filtering Conversion Process Complete Proportional Display (6540)
  • Fix: Fixed Execution Command Command timeout setting problem (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)

New in dbMigration .NET 6.8.6528.1 (Nov 15, 2017)

  • Add: List of Fields To illustrate clearly Customized Types (6528)
  •     Add: List of Fields To illustrate clearly the Primary Keys (6528)
  •     Add: (PostgreSQL) Add Cancel External Index Key Detection Processing (6528)
  •     Fix: Fixed SQL Server 2005 can not get the field message (6528)
  •     Fix: Fixes (6520) Causes Related Issues Handling (6528)
  •     Upd: Automatic Mapping Types Optimization (6528)
  •     Upd: Optimizing Interface Display and Efficiency while Improving User Experience Processing (6528)
  •     Upd: Others Including Cumulative Minor Update, Correction and Optimization (6528)

New in dbMigration .NET 6.7.6520.1 (Nov 7, 2017)

  • Add: Add Selected Table Contents Display with AutoCommand Table Properties (6520)
  • Upd: Migrating data with a SQL statement :
  • Add: Add the purpose of the existence of the data table detection process (6520)
  • Fix: Revision of the establishment of the purpose of the designated data table name no effect (6520)
  • Upd: Purpose Data Sheet Definition Test (Parsing Table definition):
  • Add: increase the purpose of the existence of the data table detection, and support renamed processing (6520)
  • Upd: Optimizing Startup Speed ​​and Overall Processing Efficiency (6520)
  • Fix: Fix the issue where the enablement of the feature options on the worklist is not updated synchronously when clicking on the object list or the list of fields [blank] (6520)
  • Upd: SQLite Symbol Version Updated to System.Data.SQLite.DLL 1.0.106.0 (3.21.0) (2017/11/02) (6520)
  • Upd: HP Vertica Component Version Updated to Vertica.Data.dll 9.0.0.1 (2017/10/27) (6520)
  • Upd: MySQL Component Version Updated to MySql.Data.dll 6.9.10 (2017/10/23) (6520)
  • Upd: Sybase ASE Component Version Updated to Sybase.AdoNet4.AseClient.dll 4.157.1000.0 (2013/04/26) (6520)
  • Upd: Others Including cumulative minor updates, correction and optimization (6520)

New in dbMigration .NET 6.5.6488.1 (Oct 6, 2017)

  • Upd: Custom Mapping Types:
  •        Add: support for custom data type and data type length (User-Defined DataTypes and DataType length) (6488)
  •     Upd: Command-Line:
  •        Upd: Improved -log parameter handling, when the original record file exceeds> 1MB, it will automatically rename the save and re-establish processing (6488)
  •     Upd: Source source filter:
  •        Upd: Preview results show the number of pages in a custom way (6488)
  •     Fix: (PostgreSQL / Oracle) Fixed (6448) caused TIMESTAMPTZ field type, when the data is NULL can not handle the problem (6488)
  •     Upd: Optimize Data Conversion Progress and Display Problems (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)

New in dbMigration .NET 6.4.6467.1 (Sep 15, 2017)

  • Add: Supports all database Asynchronous connection open, allows waiting for interruption processing (6467)
  •     Fix: Filter source data: Fixed an issue where the new or renamed data table field could not be processed properly (6467)
  •     Fix: Change the result display (see target results): Fix the limit display the number of columns update no effect (6467)
  •     Upd: Migrate data with a SQL statement:
  •        Upd: Optimize command line resolution with case-related processing issues (6467)
  •        Fix: Fix right-click menu to delete item status problem (6467)
  •     Fix: rename the name of the table and the field name (Rename): Fix the shortcuts for the selected item (6467)
  •     Upd: Automatic Matching Type Optimization (6467)
  •     Updating Interface Display and Efficiency while Improving User Experience Processing (6467)
  •     Upd: Other Include Cumulative Small Update, Fix and Optimize (6467)

New in dbMigration .NET 6.3.6463.1 (Sep 11, 2017)

  • Fix: Fix (6461) Problems with noncommercial users that are not working properly (!) (6463)
  •    Fix: (Firebird) Fixed DOMAIN data type related processing (6463)
  •    Add: add migrated data with a SQL statement: provide a more flexible and faster way to migrate data (6460/6461/6463)
  •       Fix: Fix different database types Case Differences (6463)
  •       Fix: Fix the problem that the Servo Library does not handle properly (6461)
  •    Add: add GetColumns alternative processing (support all database types), when the built-in can not get the data table field automatically switch processing (6461)
  •       Resolve the problem when Excel can not get fields when the table name contains - characters
  •    Add: Command-Line: Add the SQL statement to migrate the data parameter settings: -srcsql @ desttable: "SQL statement ... @ new_tab" (6460)
  •    Upd: Raise view objects (VIEW objects) to load and remove speed, no longer with the data table heavy brush processing (6460)
  •    Add: Source Source Filter: Add Shortcut Keys: Execute F5 (6460)
  •    Add: Data table and field name Rename and lower case rename (Rename): increase shortcut key processing (Shortcut Keys): UPPERCASE F11, lowercase F12 (6460)
  •    Fix: Save Session:
  •       Fix: Fixed a problem with memory changes (6460)
  •       Fix: Fixes can not remember additional [add] multiple fields (6460)
  •    Upd: Improved Source Data Sheet Right Menu Status (6460)
  •    Upd: Firebird component version update to FirebirdSql.Data.FirebirdClient.dll 5.11.0.0 (2017/08/30) (6460)
  •    Upd: Other Include Cumulative Minor Update, Fix and Optimize (6463)

New in dbMigration .NET 6.3.6461.3 (Sep 9, 2017)

  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6461)

New in dbMigration .NET 6.3.6460.1 (Sep 8, 2017)

  • Add: Migrate data with a SQL statement: Provides a more flexible and faster way to migrate data (6460)
  •    Add: Command-Line: Add the SQL statement to migrate the data parameter settings: -srcsql @ desttable: "SQL statement ... @ new_tab" (6460)
  •    Upd: Raise view objects (VIEW objects) to load and remove speed, no longer with the data table heavy brush processing (6460)
  •    Add: Source Source Filter: Add Shortcut Keys: Execute F5 (6460)
  •    Add: Data table and field name Rename and lower case rename (Rename): increase shortcut key processing (Shortcut Keys): UPPERCASE F11, lowercase F12 (6460)
  •    Fix: Save Session:
  •       Fix: Fixed a problem with memory changes (6460)
  •       Fix: Fixes can not remember additional [add] multiple fields (6460)
  •    Upd: Improved Source Data Sheet Right Menu Status (6460)
  •    Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.11.0.0 (2017/08/30) (6460)
  •    Upd: Other Include Cumulative Minor Update, Fix and Optimize (6460)

New in dbMigration .NET 6.2.6449.1 (Aug 28, 2017)

  • Upd: Automatic matching types:
  •        Upd: (Oracle) Support TIMESTAMP WITH TIME ZONE Automatic Matching (6448)
  •        Upd: (PostgreSQL) support TIMESTAMPTZ automatic matching process (6448)
  •     Upd: (Oracle) support TIMESTAMP WITH TIME ZONE data type conversion processing (6448)
  •     Upd: (PostgreSQL) support TIMESTAMPTZ data type conversion processing (6448)
  •     Upd: (Oracle) Update TIMESTAMP WITH [LOCAL] TIME ZONE Data Type Default Max (6448)
  •     Upd: (OleDB / ODBC) Support DECIMAL / NUMERIC (precision, scale) Accuracy generation processing (6448)
  •     Fix: (NuoDB) Fix and Update INTEGER / DECIMAL / CLOB Data Type and Accuracy Display (6448)
  •     Upd: Improved data table field Data type Length (n) Resolution (6448)
  •     Fix: Fixed a problem when the mobile window is still redistributed (6448)
  •     Upd: Other Include Cumulative Small Update, Fix and Optimize (6448)

New in dbMigration .NET 6.1.6437.1 (Aug 16, 2017)

  • Upd: Command-Line :
  • Upd: Improvements will not continue when the specified SchemaName does not exist (6437)
  • Upd: Optimize command line parsing (comma + space) (6430)
  • Upd: Optimize output message prompt display (6437)
  • Add: (FoxPro) support (* .dbf) database connection processing (automatically create dbc multiple choice to join * .dbf file) (6437)
  • Upd: (SQLite) field is automatically added when the default value for the function (Parentheses) brackets (6437)
  • Upd: (Firebird) Improvements to get the installation directory may cause an exception event handling (6430)
  • Fix: (Firebird) Fixed Table Field Default Values ​​Lost Generated Issues (6422)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6437)

New in dbMigration .NET 6.0.6430.3 (Aug 9, 2017)

  • Upd: Optimize command-line resolution (6430)
  • Upd: (Firebird) Improvements to get the installation directory may cause an exception event handling (6430)
  • Fix: (Firebird) Fixed Table Field Default Values ??Lost Generated Issues (6422)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize (6430)

New in dbMigration .NET 6.0.6422.3 (Aug 1, 2017)

  • Fix: (Firebird) Fixed Table Field Default Values Lost Generated Issues (6422)
  •     Upd: Other Include Cumulative Small Update, Fix and Optimize (6422)

New in dbMigration .NET 6.0.6411.1 (Jul 21, 2017)

  • Add: Automatically exclude unsupported connection attribute settings to avoid problems with different versions that can cause connection failure (6411)
  • Add: (Oracle 12c + / HP Vertica) supports the last update of the SEQUENCE (6411)
  • Upd: (HP Vertica) field self-incrementing syntax replaces IDENTITY (6411) with CREATE SEQUENCE processing
  • Add: (PostgreSQL 10+) support CREATE SEQUENCE AS datatype attribute 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)
  • Fix: Custom Mapping Types: Fix the same database type does not support conversion problems (6411)
  • Upd: VistaDB Component Version Updated to VistaDB.5.NET40.dll 5.6.8 (2017/07/12) (6411)
  • Upd: Includes Cumulative Small Updates, Fixes and Optimizations (6411)

New in dbMigration .NET 5.9.6404.1 (Jul 14, 2017)

  • Add: (Firebird / PostgreSQL / DB2 / NuoDB) Supports synchronous update of the destination data table SEQUENCE (6404)
  • Fix: (SQL Server / SQL Azure) Fixed char / binary maximum setting (6404)
  • Fix: Fix Partial Database Connection Test Exception Handling (6404)
  • Upd: (ODBC / OLEDB) to enhance the primary key (Primary Keys) to obtain the ability (including data synchronization) (6397)
  • Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.1.0 (2017/07/10) (6404)
  • 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) (6404)
  • Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.2020.4) (2017/06/23) (6397)
  • Upd: Include Cumulative Minor Updates, Fixes and Optimizations (6404)

New in dbMigration .NET 5.8.6397.2 (Jul 7, 2017)

  • Upd: (ODBC / OLEDB) to enhance the primary key (Primary Keys) to obtain the ability (including data synchronization) (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)
  • Upd: Include Cumulative Small Updates, Fixes and Optimizations (6397)

New in dbMigration .NET 5.8.6379.1 (Jun 19, 2017)

  • Add: Support Firebird 4 database system (6379)
  • Upd: (Firebird Embedded) to improve the different Firebird database version when using the same program connection problem (6379)
  • Upd: (Firebird) support installation services detection processing, support 1.5.x version (6379)
  • Fix: (Firebird) Fixed a problem with the normal view of the FUNCTIONS object under 1.5 / 2.0 (6379)
  • Fix: (Firebird) improved when no installation of any FB service, the full use of embedded version of the problem (6379)
  • Upd: Include Cumulative Minor Updates, Fixes and Optimizations(6379)

New in dbMigration .NET 5.6.6364.2 (Jun 5, 2017)

  • 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: Include Cumulative Minor Updates, Fixes and Optimizations (6364)

New in dbMigration .NET 5.6.6361.1 (Jun 2, 2017)

  • Upd: Optimize and Improve Additional Data Processing (Appending Data) (6361)
  • Upd: Improves the error message output processing and avoids repeating the same error message when the click is canceled (6361)
  • Add: (ODBC / OLEDB) Support for the ability to obtain different databases Identity Column (6361)
  • Upd: (SQLite) Individual distinction INTEGER PRIMARY KEY and AUTOINCREMENT definition processing (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: Include Cumulative Minor Updates, Fixes and Optimizations (6361)

New in dbMigration .NET 5.5.6352.2 (May 24, 2017)

  • Upd: (SQLite) Individual distinction INTEGER PRIMARY KEY and AUTOINCREMENT definition processing
  • Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.9.1.0 (2017/05/21)
  • Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.105.1 (3.18.0) (2017/05/15)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize

New in dbMigration .NET 5.5.6341.1 (May 12, 2017)

  • Add: Support for IBM DB2 for z / OS database system (6341)
  • Upd: Data table synchronization (Data Synchronization):
  • Add: Add Synchronization Inserted / Updated / Deleted count count display (6341)
  • Add: When the field has a preset value, leave a null value or not when converting (Options-> Preserve null values) (6341)
  • Fix: (Firebird 1.5.x) Fixed Loading FUNCTIONS Object Field Name Problem (6341)
  • Add: (Firebird) to create a remote database (6334)
  • Upd: (Oracle) remove the OCI Driver connection support, the original set to automatically turn Managed Driver is not affected (6334)
  • Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.9.0.1 (2017/05/07) (6341)
  • Upd: Include Cumulative Minor Updates, Fixes and Optimizations (6341)

New in dbMigration .NET 5.4.6334.2 (May 4, 2017)

  • Add: (Firebird) to create a remote database
  • Upd: (Oracle) remove the OCI Driver connection support, the original set automatically turn Managed Driver is not affected
  • Upd: Other Include Cumulative Small Update, Fix and Optimize

New in dbMigration .NET 5.4.6324.1 (Apr 25, 2017)

  • Add: Connection Profile Connection (Connection Profile), support for non-synchronous connection test interrupt processing (6324)
  • Add: Add Execute Command Timeout (Options-> Command Timeout) (6324)
  • Upd: Allows custom batch size settings (Options-> BatchSize) (6324)
  • 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: Optimize [data transfer] processing, the overall performance to enhance the speed of 30% to 50% (6316)
  • Upd: [Migrated VIEW / PROCEDURE / FUNCTION / SEQUENCE definitions]
  • Add: (MariaDB 10.3+) support SEQUENCES object migration processing (6324)
  • Add: (Firebird 3 <-> Firebird 3) Support PSQL Stored Functions Object Handling (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)

New in dbMigration .NET 5.3.6316.2 (Apr 18, 2017)

  • Upd: Optimize [data transfer] processing, the overall performance to enhance the speed of 30% to 50% (6316)
  •     Upd: [Migrated VIEW / PROCEDURE / FUNCTION / SEQUENCE definitions]
  •        Add: (Firebird 3 <-> Firebird 3) Support PSQL Stored Functions Object Handling (6316)
  •     Fix: Improved re-targeting Firebird's path without immediate reboot (6316)
  •     Upd: Other Include Cumulative Minor Update, Fix and Optimize (6316)

New in dbMigration .NET 5.3.6313.1 (Apr 14, 2017)

  • Upd: Automatic matching types:
  •        Upd: Optimized (ODBC / OLEDB) and Custom Type (UDT) Automatic Matching (6313)
  •     Add: (Text) support UTF-16 format file import (6313)
  •     Fix: (Text) Fixed UTF-8 File Import Problem (6313)
  •     Upd: Improved Decimal data type conversion processing (including overflow exception display) (6313)
  •     Upd: (Vertica) Dramatically Optimize and Improve Conversion Processing (6313)
  •     Upd: (Excel / Text) stops when the source connection resource does not exist (6313)
  •     Fix: (FoxPro) Fixes TABLE / VIEW Objects Unclassified Issues (6313)
  •     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)

New in dbMigration .NET 5.1.6301.3 (Apr 2, 2017)

  • Fix: Fixed (6295) caused (ODBC / OLEDB [Access / dBASE / FoxPro / Excel / Text]) database without SCHEMA can not normally get IndexColumn problem (6301)
  • Upd: Save Session :
  • Add: increase source data filter source (6301)
  • Fix: Fix reconnection can not remember the problem of renaming the field (6301)
  • Fix: Filter Source data : Fix Reboot Filtered Data Table SQL Preview Problem (6301)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6301)

New in dbMigration .NET 5.1.6295.1 (Mar 27, 2017)

  • Upd: (ODBC / OleDB) table list to increase SCHEMA display, when the database itself supports (6295)
  •     Upd: (Firebird) connection attribute CharSet allows the user to change the processing afterwards (initial automatic database coding) (6295)
  •     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: Command-Line: Fixed -srcschema / -destschema Can not specify the first item name in the list (6287)
  •     Upd: Improve the conversion process error dialog function, support skip all the error column processing: (6287)
  •        (Click [Yes] to skip all error rows), Click [No] to skip this error row), Click [Cancel] to skip this table)
  •     Upd: Other Include Cumulative Minor Update, Fix and Optimize (6295)
  •     Misc: dbMigration .NET is available on Chocolatey

New in dbMigration .NET 5.1.6295.1 (Mar 27, 2017)

  • Upd: (ODBC / OleDB) table list to increase SCHEMA display, when the database itself supports
  • Upd: (Firebird) connection attribute CharSet allows the user to change the processing afterwards (initial automatic database coding)
  • Fix: (OLEDB) Fixed View COLUMNS / INDEXES Unresolved if there was SCHEMA
  • Fix: (ODBC) Fix Browsing INDEXES Unspecified issue if there is SCHEMA
  • Fix: Command-Line : Fixed -srcschema / -destschema Can not specify the first item name in the list
  • Upd: Improve the conversion process error dialog function, support skip all the error column processing
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize
  • Misc: dbMigration .NET is available on Chocolatey

New in dbMigration .NET 5.0.6287.66 (Mar 19, 2017)

  • Fix: Command-Line: Fixed -srcschema / -destschema Can not specify the first item name in the list (6287)
  • Upd: Improve the conversion process error dialog function, support skip all the error column processing: (6287)
  • (Click [Yes] to skip all error rows), Click [No] to skip this error row), Click [Cancel] to skip this table)
  • Upd: Other Include Cumulative Small Update, Fix and Optimize (6287)

New in dbMigration .NET 5.0.6278.1 (Mar 10, 2017)

  • Add: increase the system object display settings (Options-> Show system objects) (6278)
  •        Preset for the display (Default = false), can be excluded from the unnecessary system object display at the same time greatly enhance the object display speed
  •     Fix: Fixed field FK text is not fully displayed problem, when the multi-field external key (Multiple-column foreign key) (6278)
  •     Fix: (IBM DB2) Fixed TIMESTAMP Data Type Microsecond Length Problem (6278)
  •     Fix: (Teradata) Fixed field where TIMESTAMP data type could not be added and updated (6278)
  •     Misc: Compiled with Visual Studio 2017
  •     Upd: Other Include Cumulative Minor Update, Fix and Optimize (6278)

New in dbMigration .NET 4.9.6271.1 (Mar 3, 2017)

  • Add: support multi-language display (Multi-Language UI: Options-> Language) (6271)
  •     Add: add a new version of the automatic detection settings (Options-> Check for new version) (6271)
  •     Fix: Automatically generate foreign keys:
  •        Upd: When the destination database type is dBASE / Excel will not be generated, and the ODBC / OleDB presets will not automatically generate processing (6271)
  •     Upd: (TEXT) Increases the number of rows detected to improve the correctness of the detected field type (6268)
  •     Fix: Fixed an issue where the [Execute] dialog box does not function properly if it appears after the [Error] dialog box (6268)
  •     Upd: Firebird component version update to FirebirdSql.Data.FirebirdClient.dll 5.8.0.0 (2017/02/23) (6268)
  •     Upd: Other Include Cumulative Small Update, Fix and Optimize (6271)

New in dbMigration .NET 4.8.6268.2 (Feb 28, 2017)

  • Upd: (TEXT) Increases the number of rows detected to improve the correctness of the detected field type (6268)
  •     Fix: Fixed an issue where the [Execute] dialog box does not function properly if it appears after the [Error] dialog box (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)

New in dbMigration .NET 4.8.6260.1 (Feb 20, 2017)

  • Fix: Automatically generate foreign keys
  • Upd: Improve the user experience: When the external index key data table does not exist or can not be established, you can choose to automatically perform a separate reference or choose not to perform processing
  • Upd: External index key field Repeated reference detection processing
  • Fix: Fixed destination database does not support source database ON UPDATE, ON DELETE when the type of change to the default processing
  • Fix: (NuoDB) Fix support for adding Multiple-column foreign key
  • Upd: (Access / Firebird / VistaDB / Informix) Exclude external key keyers (Foreign key Indexes), to avoid duplication
  • Upd: (Teradata) to exclude self- generated system index display (System indexes), to avoid duplication
  • Upd: The object name contains the handling of the exception character ()
  • Upd: (Sybase ASE) Add InitializationString Connection Properties Settings, Script Tab (Script Tab)
  • Upd: Other Include Cumulative Minor Update, Fix and Optimize

New in dbMigration .NET 4.7.6248.1 (Feb 8, 2017)

  • Upd: Data table data synchronization (Data Synchronization):
  • Add: Support for Unique Index synchronization (6248)
  • Upd: remove the column must meet the restrictions (The columns of the two tables must match) (6248)
  • Upd: Exclude Synchronization with NULL Primary Key Value (6248)
  • Upd: Conversion options such as Synchronize / Append / Delete are supported when the source and destination table fields are different (6248)
  • Upd: (SQL Server / SQL Azure) support for Geography / Geometry / HierarchyId and other data types such as automatic mapping and conversion (6248)
  • Add: (Oracle) Support MATERIALIZED VIEW Object and Object Data Conversion (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: Save Session If the table field name change can not be restored normally (6248)
  • Upd: Change the field name of the destination database when the field name is changed (6248)
  • Upd: VistaDB component version is updated to VistaDB.5.NET40.dll 5.5.3 (2017/02/03) (6248)
  • Upd: (Informix) supports TEXT data type (blob) data type processing (6241)
  • Upd: (NuoDB) Update data type (Decimal / Numeric) Maximum length setting (6241)
  • Add: Support batch processing of [single-line 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: Other Includes Cumulative Minor Updates, Fixes and Optimizations (6248)

New in dbMigration .NET 4.6.6241.2 (Feb 1, 2017)

  • Upd: (Informix) supports TEXT data type (blob) data type processing
  • Upd: (NuoDB) Update data type (Decimal / Numeric) Maximum length setting
  • Add: Support batch processing of [single-line non-GO], enabling batch processing of repositories that do not support batch commands
  • Upd: non-fixed date data type to increase the length of the display (including script generation)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimization

New in dbMigration .NET 4.6.6235.1 (Jan 27, 2017)

  • Updating: Automatically generate foreign keys : Add Options-> Automatically generate to target tables Setting Options
  • Upd: Add the `mysql_native_password` failed exception message to resolve the MySQL Connector / NET connection problem
  • Upd: Execute scripts when connected after connection
  • Add: Add to Comments Comments Filter Processing
  • Upd: Optimization (6211) Processing Mode
  • Upd: support the elimination of external index key data table detection processing (support SQLite / MySQL / SQL Server / SQL Azure)
  • Upd: SQLCe v3.5 component version update to SQL Server Compact 3.5 SP2 hotfix (3.5.8109.0) (2013/06/14)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations

New in dbMigration .NET 4.5.6211.1 (Jan 3, 2017)

  • Add: Added full support VistaDB database (Full support for VistaDB)
  • Add: (Access / SQLite / SQLCe / VistaDB) direct support to establish an encrypted database features ( Creating AN ENCRYPTED Database ) (same SQLCe)
  • Add: After performing the specified code to support the connection function ( the Execute scripts the when Connected ) (with Database .NET)
  • Upd: Index Management ( the Manage the Indexes ): Added support for FoxPro object repositories
  • Fix: External index key is automatically generated ( the Automatically the Generate Foreign Keys ): syntax NONE automatically converted to NO ACTION
  • Upd: optimize the detection and release of interrupt processing Interconnect
  • Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.1010.4) (2016/12/16)
  • 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

New in dbMigration .NET 4.4.6199.1 (Dec 21, 2016)

  • Upd: Modifying the Configuration to Improve Security Software Compatibility (6199)
  • Upd: (FoxPro) Destination database field names are automatically renamed if they contain an exception character (Space)
  • Upd: Changing the destination database field name will display a prompt message if it contains an exception (6199)
  • Fix: Saving Session: Fixed a problem where the destination database field does not match if it contains an exception. (6199)
  • Upd: Connection Profile:
  • Updating Oracle Instant Client version detection with different bits (32 / 64bit), preventing errors from causing an exception (6199)
  • Upd: SQLite component version is updated to System.Data.SQLite.DLL 1.0.104.0 (3.15.2) (2016/12/16) (6199)
  • Upd: Firebird component version is updated to FirebirdSql.Data.FirebirdClient.dll 5.7.0.0 (2016/12/12) (6199)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations (6199)

New in dbMigration .NET 4.3.6185.1 (Dec 8, 2016)

  • Upd: Connection Profile:
  • Upd: Merging the Database .NET Connection Settings Module, Inheriting All Past Updates (6185)
  • Upd: Resolving a problem that caused the program to quit unexpectedly when a connection (DB2 / Informix) was executed without IBM DATA SERVER DRIVER installed (6185)
  • Fix: Fixing Exception Message Display When Fixing Error Property Settings (6176)
  • Upd: Improve the automatic matching field data type (Automatic Mapping Types):
  • Upd: Improved Custom Type (UDT) Automatic Match Processing (6185)
  • Add: MySQL 8.0 database system to increase support for solving PROCEDURE / FUNCTION / INDEX and other compatibility issues (6176)
  • Upd: Improves exception handling when starting a read configuration file (6176)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations (6185)

New in dbMigration .NET 4.2.6165.1 (Nov 17, 2016)

  • Add: (Firebird) Added SYSTEM SEQUENCES object display (6165)
  • Fix: (Firebird) fix (6151) Database connection password exception handling, affecting the default password reference problem (6165)
  • Fixed: (MySQL) External index keys automatically generated (Automatically generate foreign keys): Fixed MySQL 5.1 or above can not generate the problem (6165)
  • Upd: (SQLite) Update Field Type DECIMAL / NUMBER Length Limit (Default 15,0) (6165)
  • Fix: Fixed (6125) custom data type, updated [current data table] is not automatically updated after the update (6165)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimization (6165)

New in dbMigration .NET 4.1.6156.2 (Nov 8, 2016)

  • Fix: Fix (6155) An issue that could not be handled properly when the source database does not support external index keys (6156)

New in dbMigration .NET 4.1.6155.1 (Nov 7, 2016)

  • Add: Automatically generate foreign keys (6155)
  • & Lt; / RTI & gt; Upd: Improving and Correcting Test Pattern Related Processing (6155)
  •     Upd: (MySQL) Data table encoding changed to the main database code set to the main database encoding (6155)
  •     Fix: (FoxPro) Fixed AutoInc problem if it was not set correctly in the first field or non-primary key (6155)
  •     Fix: Library List Object Move Up and Down Set Up Move Up and Down (6155)
  •     Fix: Fix the problem that the menu name is not updated synchronously after the field is renamed (6155)
  •     Fix: Resolves a problem that can not be fully used when the operating environment is set to the Turkish (Cyprus) language (6155)
  •     Upd: Database connection password exception handling (6151)
  •     Upd: Firebird component version is updated to FirebirdSql.Data.FirebirdClient.dll 5.6.0.0 (2016/11/02) (6151)
  •     Upd: NuoDB component version is updated to NuoDb.Data.Client.dll 2.3.0.9 (2016/10/24) (6151)
  •     Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations (6155)

New in dbMigration .NET 4.0.6151.2 (Nov 3, 2016)

  • Upd: Database connection password exception handling
  • Upd: Firebird component version is updated to FirebirdSql.Data.FirebirdClient.dll 5.6.0.0 (2016/11/02)
  • Upd: NuoDB component version is updated to NuoDb.Data.Client.dll 2.3.0.9 (2016/10/24)

New in dbMigration .NET 4.0.6142.1 (Oct 26, 2016)

  • Fix: Data Synchronization: Fixed an issue where the source data could not be synchronized (NULL)
  • Add: Custom Delimited File Extensions (6142) to add custom delimited text extensions
  • Upd: Adding Exception Messages When Rebuilding and Deleting Fails
  • Upd: NuoDB component version is updated to NuoDb.Data.Client.dll 2.3.0.8 (2016/10/20)
  • Upd: Other Cumulative minor updates, fixes and optimizations

New in dbMigration .NET 3.9.6125.1 (Oct 7, 2016)

  • Add: Support for Custom Delimited File Extensions
  • Fix: Problem that can not be read properly when the number separator character (NumberDecimalSeparator) in the operating system is different from that in the operating system when the delimited character of the delimited text is [,]
  • Upd: Custom Mapping Types: Updates the selected data table field type after updating
  • Fix: Resolve manual rename tables If Quoted Identifiers is removed, it will cause SCHEMA to repeatedly process the problem
  • Add: (PostgreSQL) Error Information Add an [Error detail message]
  • Add: [SQLCe / SQLite] Add additional connection properties (with Access / Firebird)
  • Fix: (SQL Server / SQL Azure / Sybase ASE) table to change the name of the case to maintain the original SCHEMA unchanged
  • Upd: Improvements and Fixes for Firebird Global Connection Settings
  • Upd: Firebird component version is updated to FirebirdSql.Data.FirebirdClient.dll 5.5.0.0 (2016/10/05)
  • Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations

New in dbMigration .NET 3.8.6121.3 (Oct 4, 2016)

  • Added:
  • Support (one / two) dimensional arrays data type conversion process (6118)
  • [DIFFERENCE] Database type conversion to text type, [Same] Database type Direct conversion processing
  • Support (one / two) dimensional arrays data type display process (6118)
  • Time (6118) when added Quoted Identifiers dimensional arrays contains exceptions characters
  • Updated:
  • Improved user experience, whether the table simultaneously, increasing the prompt message is displayed (6118)
  • Cumulative contain other minor updates, fixes and optimization (6118)
  • (Firebird) If the table for the purposes of IDENTITY (seed) treatment initial value of -1, +1 if it is the source of the initial value of the process (6118)
  • Fixed:
  • (Firebird) Correction (6109) result that has been set Embedded Server / Remote Type settings such useless questions (6118)

New in dbMigration .NET 3.7.6109.1 (Sep 22, 2016)

  • 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: [the same type] database object migration (Migrating VIEW / PROCEDURE / FUNCTION / SEQUENCE definitions)
  • Add: (Firebird Firebird) increase FUNCTIONS object migration process (6099)
  • Upd: (Firebird Firebird) program generates object (PROCEDURE): increase in the processing and DEFAULT CHARACTER SET's (6099)
  • Fix: (Firebird / Access) amendment (6059) to connect additional property settings were not saved after the update problem (dbMigration .NET only)
  • 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 element version update to SQL Server Compact 4.0 SP1 hotfix (4.0.8902.1) (2014/06/10)
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.6.6099.1 (Sep 12, 2016)

  • Upd: [the same type] database object migration ( Migrating the VIEW / PROCEDURE / the FUNCTION / the SEQUENCE Definitions )
  • Add: (Firebird Firebird ) increase FUNCTIONS object migration process (6099)
  • Upd: (Firebird Firebird ) program generates object (PROCEDURE): increase in the processing and DEFAULT CHARACTER SET's (6099)
  • Upd: Cumulative contain other minor updates, fixes and optimization (6099)

New in dbMigration .NET 3.6.6087.1 (Aug 31, 2016)

  • Upd: browsing speed significantly improved object processing load, only less than 1/10
  • Add: support [of the same type] database object migration (Migrating VIEW / PROCEDURE / FUNCTION / SEQUENCE definitions), comprising:
  • Access Access: (VIEWS / PROCEDURES)
  • SQLite SQLite: (VIEWS)
  • FoxPro FoxPro: (VIEWS)
  • Firebird Firebird: (VIEWS / PROCEDURES / SEQUENCES / DOMAINS)
  • MySQL MySQL: (VIEWS / PROCEDURES / FUNCTIONS)
  • SQL Server / SQLAzure SQL Server / SQLAzure: (VIEWS / PROCEDURES / FUNCTIONS / SEQUENCES)
  • PostgreSQL PostgreSQL: (VIEWS / FUNCTIONS / SEQUENCES)
  • SybaseASE SybaseASE: (VIEWS / PROCEDURES / FUNCTIONS)
  • Oracle Oracle: (VIEWS / PROCEDURES / FUNCTIONS / SEQUENCES)
  • IBM DB2 IBM DB2: (VIEWS / PROCEDURES / FUNCTIONS / SEQUENCES)
  • Informix Informix: (VIEWS / PROCEDURES / FUNCTIONS / SEQUENCES)
  • NuoDB NuoDB: (VIEWS / PROCEDURES / FUNCTIONS / SEQUENCES)
  • Teradata Teradata: (VIEWS / PROCEDURES / FUNCTIONS)
  • HP Vertica HP Vertica: (VIEWS / FUNCTIONS / SEQUENCES)
  • Upd: Remove VIEWS object data conversion process is defined by the object migration substituted
  • Upd: (SQLite) when multiple primary key (PKs) will be canceled automatically incremented (AUTOINC) set the field's
  • Fix: (FoxPro) to resolve when table contains incremented (AUTOINC) field data can not convert problem
  • Upd: (ODBC) to improve information and table view table group classification to avoid duplicated
  • Fix: Fixed scaling window is not smooth problems
  • Upd: join a more complete object icon (Icon) Display
  • Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.1.0.0 (2016/08/29)

New in dbMigration .NET 3.5.6079.1 (Aug 23, 2016)

  • Fix: Index generated automatically (Automatically create indexes): correction of multiple index fields (Multiple Column Indexes), field names exactly matching process
  • Fix: Custom corresponding data type (Custom Mapping Types): Fixed type name exactly matching process
  • Fix: command line processing (Command-Line): Fixed table name exactly matching process
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.5.6059.1 (Aug 3, 2016)

  • Add: (Firebird) increase [overall] connection property settings (Global connection properties), you can specify the system user and password (replace the original setting options)
  • Add: (Firebird) increase [distal] connection establishment setting process ()
  • Add: (Access) increase in [specified] property is set to connect additional (Additional connection properties), easy setup [Users and Passwords] and other additional connection message
  • Upd: (MySQL) New encoding table change to take character-set-server instead of the default character-set-database library encoding
  • Upd: source to auto-increment field but [non] primary key, if it is the purpose of the database (MySQL / SQLite / FoxPro) except when set to auto-increment the outside also will be automatically set as the primary key
  • Upd: numeric and date data types added length detection, avoid exceeding the maximum value in itself and can not be established (eg:. Datatime2, datetimeoffset ... etc)
  • Fix: Fixed an issue with the source object database type switching change-related function keys are not synchronized update
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.4.6040.1 (Jul 15, 2016)

  • Add: (PostgreSQL / Informix) increase the auto-increment field set to automatically switch to Serial data type
  • Add: (PostgreSQL) support bigserial data type is displayed with the relevant processing
  • Add: Support IDENTITY (seed, increment) complete the definition of field editing process
  • Comprising: SQL Server / SQLAzure / SQLCe / FoxPro / Access / HP Vertica / Firebird 3
  • Upd: (HP Vertica) table updates automatically increment fields grammar original AUTO_INCREMENT change IDENTITY (seed, increment) full definition (6040)
  • Upd: (PostgreSQL / Informix) improved Serial (AUTO_INCREMENT) field automatic matching process
  • Fix: (FoxPro) correction can not get the source table is automatically incremented problem fields (Identity Column) of
  • Upd: strengthening the connection error message is displayed, to provide a more complete error information
  • Upd: command line processing (Command-Line):
  • Add: Support file password settings: -srcdbpwd: yourdbfilepassword destdbpwd: When no memory yourdbfilepassword can save input 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
  • 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: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.3.6036.6 (Jul 11, 2016)

  • 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 capacit
  • Add: Support Microsoft Office Access 2016 and Microsoft Access Runtime 2016 element connection process
  • Upd: (SQL Server) to update the database include ways to significantly improve loading speed, when solving the problem no permission to access the database causes a load for too long
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.2.6029.1 (Jul 4, 2016)

  • 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: (Firebird 3) Client Library can automatically correct the wrong set of issues
  • Upd: MySQL element updated to MySql.Data.dll 6.9.9 ]
  • Upd: SQLite element updated to System.Data.SQLite.DLL 1.0.102.0 (3.13.0)
  • Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.0.4)
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.2.6001.1 (Jun 6, 2016)

  • 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 (5997) after [Objective field]
  • Upd: command line processing (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 (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)
  • Upd: HP Vertica element to return the updated version Vertica.Data.dll 7.2.3 -> 7.1.2
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.1.5997.6 (Jun 2, 2016)

  • Upd: Improved automatically match the field data types (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)

New in dbMigration .NET 3.1.5989.1 (May 25, 2016)

  • Add: New source-separated text file conversion (Converting Delimited Text Files)
  • Automatic Identification text file separator character (comma, tab, pipe, semicolon and custom delimiter) the file encoding
  • Upd: table data synchronization (Data Synchronization): table primary key (Primary Keys) support for [all] the types of data processing
  • Fix: When (Firebird 3) If you do not install the corrected version installed Guardian, the connection is not displayed when FB installation problems
  • Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.0.5.0 (2016/05/24)
  • Boolean Data Type Support and SRP authentication
  • Upd: HP Vertica element updated to Vertica.Data.dll 7.2.3 (2016/05/23)
  • Upd: Oracle component version update to Oracle.ManagedDataAccess.dll 12.1.24160419 (2016/04/27)
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 3.0.5959.1 (Apr 29, 2016)

  • Add: Added support purposes table custom field functions ( Adding Custom Columns ) (5959)
  • Upd: Database for the purpose of removing unnecessary indexes Vertica function generation processing (5959)
  • Upd: Improved source PostgreSQL database to access the index-related issues (5959)
  • Upd: automatically exclude unnecessary index generation processing (5959)
  • Upd: join the state to change the order of the fields after reservation (5959)
  • Upd: SQLite element updated to System.Data.SQLite.dll 1.0.101.0 (3.12.2) (2016/04/19) (5959)
  • Upd: Cumulative contain other minor updates, fixes and optimization (5959)

New in dbMigration .NET 2.9.5959.1 (Apr 25, 2016)

  • Add: Added support purposes table custom field functions (Adding custom columns)
  • Upd: Database for the purpose of removing unnecessary indexes Vertica function generation processing
  • Upd: Improved source PostgreSQL database to access the index-related issues
  • Upd: automatically exclude unnecessary index generation processing
  • Upd: join the state to change the order of the fields after reservation
  • Upd: SQLite element updated to System.Data.SQLite.DLL 1.0.101.0 (3.12.2) (2016/04/19
  • Upd: Cumulative contain other minor updates, fixes and optimization

New in dbMigration .NET 2.9.5957.2 (Apr 23, 2016)

  • Upd: optimizing data conversion processing speed (5952)
  • Upd: the same index name is automatically renamed Processing (5952)
  • Upd: (MySQL> 5.0.2) When the database connection SQL MODE setting if it is loose ANSI mode, will automatically set STRICT_TRANS_TABLES strict mode (5952)
  • Upd: SQLite element updated to System.Data.SQLite.dll 1.0.100.0 (3.12.1) (2016/04/15) (5952)
  • Upd: HP Vertica element updated to Vertica.Data.dll 7.2.2 (2016/03/30) (5952)
  • Upd: Cumulative contain other minor updates, fixes and optimization (5952)

New in dbMigration .NET 2.8.5924.1 (Mar 21, 2016)

  • Fix: Fixed multi-column index generated when the field is displayed in order of priority issues (5924)
  • Fix: Fixed after completion of the project the new connection can not be displayed immediately [auto-generated command line to the clipboard] function button issues (5924)
  • Fix: Fixed Oracle index generation processing (5924)
  • Fix: Improved index was renamed after the problem menu changes are not synchronized Index Name (5924)
  • Upd: command line processing (Command-Line):
  • Upd: increase QuotedString recognition processing, in order to avoid duplication of the specified (5924)
  • Fix: Fixed database to SQL Server / SQLAzure / SybaseASE, you can not specify schema + table (Schema.Table) Issues (5924)
  • Upd: correct object parameter abbreviated -dest (formerly -desc still use [?]) (5924) [?]
  • Upd: Cumulative contain other minor updates, fixes and optimization (5924)

New in dbMigration .NET 2.7.5918.1 (Mar 15, 2016)

  • Add: increase Index Management (Manage Indexes): Allows rename and remove the target database index (5918)
  • Add: increase in batch mode settings (Batch Mode Settings), set the options to be set (Help-> Options-> Batch Size) (5918)
  • Upd: Storage session function (Saving Session) was added to the right-click menu (5918)
  • Upd: source data filtering (Filter source data): automatically (Auto Completion): increase =, etc. insert the selected item processing (5918)
  • Upd: source data filtering (Filter source data): automatically (Auto Completion): optimized to reduce unnecessary perception show (5918)
  • Upd: Cumulative contain other minor updates, fixes and optimization (5918)
  • Google Traducere pentru companii:Translator ToolkitInstrumentul de traducere a site-urilor webGlobal Market Finder
  • Dezactivați traducerea automatăDespre Google TraducereMobilComunitateConfidenţialitate şi termeniAjutorTrimiteți feedback
  • Îmbunătățiți aceast

New in dbMigration .NET 2.5.5903.2 (Feb 29, 2016)

  • Add: Added a custom data type corresponding to (Custom Mapping Types): convenience for the entire library of data processing using the corresponding table custom (5903)
  • Fix: Fixed some type of database table column sorting process, when more than> 10 when scheduling problem (5903)
  • Upd: Cumulative contain other minor updates, fixes and optimization (5903)

New in dbMigration .NET 2.5.5884.1 (Feb 9, 2016)

  • solve Teradata table fields slower access issues can significantly improve processing speed (5884)
  • Upd: Table definition preview (SQL preview): Improved copy processing without directly copying the whole election process (5884)
  • Upd: Improved automatically match the field data types (Automatically match columns):
  • Upd: Improved Unicode Char Char conversion between different combinations of matching process (5884)
  • Upd: automatic exclusion object database field is not supported by the primary key (PK) data type (5884)
  • Fix: solve the source text data types of content, if when NullChar contain characters causing the problem can not be properly handled (5884)
  • Fix: Fixed re-linking of different types of database update QuotedString priorities to avoid affecting the Schema switch (5884)
  • Upd: (FoxPro) when the source table name contains exceptions characters [. $] Will be automatically renamed as [_] (5884)
  • Upd: (ODBC) databases to increase read retry processing (5884)
  • Upd: Cumulative contain other minor updates, fixes and optimization (5884)

New in dbMigration .NET 2.4.5877.5 (Feb 8, 2016)

  • Added:
  • (ODBC / OleDB) supports short data types (Short Type Names) automatic matching process (5877)
  • New build only table structure described processing (Create Table Schema Only) (5876)
  • Help button (Help Button): integrated wiring list (Connection List) Display (5876)
  • Connection list items increased to generate the command line to the clipboard sub-option (Generate the command-line to Clipboard) (5876)
  • Updated:
  • compatible ODBC Version

New in dbMigration .NET 2.3.5877.2 (Feb 3, 2016)

  • Add: (ODBC / OleDB) supports short data types (Short Type Names) automatic matching process (5877)
  • Add: Added establish data table structure is described only process (Create Table Schema Only) (5876)
  • Add: Help button (Help Button): integrated wiring list (Connection List) display (5876)
  • Add: Connection list items increased to generate the command-line options scrapbook son (Generate the command-line to Clipboard) (5876)
  • Upd: compatible ODBC Version

New in dbMigration .NET 2.3.5876.1 (Feb 2, 2016)

  • Add: Added establish data table structure is described only process (Create Table Schema Only) (5876)
  • Add: Help button (Help Button): integrated wiring list (Connection List) display (5876)
  • Add: Connection list items increased to generate the command-line options scrapbook son (Generate the command-line to Clipboard) (5876)
  • Upd: compatible ODBC Version

New in dbMigration .NET 2.3.5851.1 (Jan 8, 2016)

  • Add: Inheritance Database .NET connection string settings Additional settings (Additional connection parameters) (5851)
  • Upd: (Firebird) database when the connection is not the same with the preset encoding automatically switches to NONE to solve Can not transliterate character between character sets of questions (5851)
  • Upd: Improved When the directory can not be written because of UAC settings change automatically stored to x: \ Users \ \ AppData \ Roaming \ Database location record (5851)
  • Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (10.5.7.4) (2015/12/30) (5851)
  • Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 7 (2015/12/30)
  • Upd: SQLite element updated to System.Data.SQLite.DLL 1.0.99.0 (3.9.2) (2015/12/10) (5851)
  • Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.9.0.0 (2015/12/20) (5851)
  • Upd: HP Vertica element updated to Vertica.Data.dll 7.2.1 (2015/11/16) (5851)
  • Upd: Accumulated other contains minor updates, correction and optimization (5851)

New in dbMigration .NET 2.2.5798.1 (Nov 16, 2015)

  • Upd: (SQLite) when the source repository for the associated processing WITHOUT ROWID table of (5798)
  • Upd: original \ app.exe.sandbox scratch directory to the \ temp \ after app.exe.sandbox program closed automatically deleted (5798)
  • Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.7 (2015/11/10) (5798)
  • Upd: Accumulated other contains minor updates, correction and optimization (5798)
  • Misc: Compatible with PostgreSQL 9.5b2 or higher (2015/11/12)
  • Misc: Compatible with Teradata 15.10 (2015/11/04)

New in dbMigration .NET 2.1.5784.1 (Nov 2, 2015)

  • Add: Support update process when the password expires ( Change Password Dialog When password prompt expired ) (5784)
  • Contains MySQL 5.6 + / Oracle 12 + / SQL Server / SQL Azure / Sybase ASE / Teradata database, etc.
  • Fix: Fixed servo Edition database connection when the password memory is not set, you can not display the password input window of the problem (5784)
  • Add: (MySQL 5.7) supports JSON data type handling (5784)
  • Upd: modifications and improvements when the purpose of the database SQLite related issues with int integer processing: (5784)
  • (Integer + PK but not AutoInc, PK + AutoInc but non-integer, integer + AutoInc but non-PK)
  • Fix: Problems (Teradata) amended VIEWS object data types that are not displayed (5784)
  • Upd: HP Vertica element updated to Vertica.Data.dll 7.2.0 (2015/10/29) (5784)
  • Upd: Accumulated other contains minor updates, correction and optimization (5784)
  • Misc: Compatible with HP Vertica 7.2 (2015/10/29)
  • Misc: Compatible with MySQL 5.7.9 (2015/10/21) / MySQL 5.6.27 (2015/09/30) / MySQL 5.5.46 (2015/09/30)

New in dbMigration .NET 2.0.5778.3 (Oct 27, 2015)

  • Add: Support column index generated automatically processed ( Automatically create Indexes ) (5778)
  • Add: Support Change save function ( Saving Changes ): When selecting the next no longer need to re-set the same thing (the same applies in the command line treatment) (5778)
  • Add: Support [Column] hierarchy cancellation process (Skipping error rows), an error occurs when the conversion process, you can choose to skip data column can not be converted (5778)
  • Upd: upgrade automatically match the field data type handling ( Automatically match columns ) (5778)
  • Fix: solve the source repository when SQLAzure not support issues (5778)
  • Upd: MySQL element is updated to version 6.9.8 MySql.Data.dll (2015/10/21) (5778)
  • Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.1 (2015/10/20) (5778)
  • Fix: Returns NuoDB element version to NuoDb.Data.Client.dll 2.3.0.4 : The original version of numeric data types can not display null issues (5778)
  • Upd: Accumulated other contains minor updates, correction and optimization (5778)

New in dbMigration .NET 1.9.5770.1 (Oct 19, 2015)

  • Add: command line processing ( Command-Line )
  • Add: Support (Firebird / SQLite / Access / SQLCe / Excel) purpose database automatically establish processing
  • Add: When the source and destination repositories If no pre-established after the specified file type repository can be set to automatically establish a connection no longer pre-established
  • Add: increase the log file date convenient to distinguish each different execution record
  • Upd: When the specified parameters is invalid will appear in the output window or log file in the
  • Add: Support multiple selection fields ( Selecting Multiple columns to Edit ) batch update data type handling
  • Upd: (Oracle) Update of Fields LONG / NUMBER information such as the type of automatic matching process
  • Fix: (Oracle) modify field CHAR / VARCHAR2 / NCHAR / NVARCHAR2 way to obtain information such as the type length
  • Fix: When (Oracle) Correction Connection is set to OCI, unable to deal with the issue of migration
  • Add: (Teradata) supports auto-increment field set processing (Auto Increment)
  • Fix: Fixed results when the [Source] Connection appointment as SQLCe, unable to deal with migration issues
  • Upd: join the structural integrity descriptive name (SCHEMA NAME) treatment
  • Fix: Problems (NuoDB) amended IDENTITY column can not be achieved
  • Upd: (Access) change OLEDB.4.0 ACE.OLEDB.12.0 connection method to replace the original, easy to use (dbP) in the environment without installing the required components
  • Upd: Output window displays a more complete error message
  • Upd: Accumulated other contains minor updates, correction and optimization

New in dbMigration .NET 1.8.5765.1 (Oct 14, 2015)

  • Add: Columns Columns command processing ( Command-Line ):
  • Add: Added default confirmation options ( Default Confirmation Options (if the target table exists) ): -defopt: [rename / recreate / delete / append / Sync]
  • Add: Add record mode no window option (Log mode and No window (DBMigration.log)): -log
  • Add: Support handle success or failure return code (Return ExitCode: Success = 0, Failure = 1)
  • Fix: exceptions can cause problems when correcting for changes in part to the type of information
  • Fix: Fixed PostgreSQL Advanced Connection property is set to issue stalled
  • Upd: Improved ODBC Data Sheet and the correction field shows
  • Add: increase SQLCe 3.5 / 3.1 support database format
  • Upd: upgrade automatically identify the type of data matching process
  • Upd: Accumulated other contains minor updates, correction and optimization

New in dbMigration .NET 1.7.5759.1 (Oct 8, 2015)

  • Add: Sources of information filtering ( Filter Source Data ): supports auto-complete text input process ( Auto Completion ) (5759)
  • Add: Added information table and field names in uppercase and lowercase renamed Processing ( UPPERCASE and lowercase ) (5759)
  • Fix: life column column processing ( Command-Line ): amendment because it supports the function button menu function is causing the problem and the implementation of direct connection lost Effects (5759)
  • Fix: Data table definition preview ( SQL preview ): change the purpose of correction after the table name is not synchronized display problems (5759)
  • Fix: (Sybase / SQLServer / SQLAzure) correction (5753) only for xVARCHAR / xBINDAY (MAX) data type handling, etc. (5759)
  • Upd: Improved [Date / Time / Datetime / Timestamp] (scale) and so the date and time data types are specified length when dealing with the issue (5759)
  • Fix: Fixed interrupt testing and implementation of key disable status is not updated after wiring problems (5759)
  • Fix: Fixed in some cases when the servo version repository automatically connect Login failed, unable to open the original connection settings, cause problems program can not proceed (5759)
  • Fix: solve when setting area and language (Turkish) language, because Case-Sensitive issues cause-related issues (5759)
  • Upd: Improved handling problems the decimal separator symbol integer (5759)
  • Upd: Oracle components updated to Oracle.ManagedDataAccess.dll 12.1.0.2.4 (2015/10/05) (5759)
  • Upd: Accumulated other contains minor updates, correction and optimization (5759)

New in dbMigration .NET 1.6.5753.1 (Oct 2, 2015)

  • Add: Added Data Sheet Data Sync ( Data Synchronization ): Support Information column add / update / delete transaction synchronization processing (5753)
  • Upd: Default changed to a primary key (Primary Key (s)) as a write sequence data columns, which can enhance the writing speed (5753)
  • Upd: (Sybase / SQLServer / SQLAzure) support purposes repository datatype (MAX) define the length of the field data (5753)
  • Upd: Improved automatic matching source data types when no length specified treatment (5753)
  • Fix: (Firebird) Improved blob / blob sub_type 1 distinguishing processing (5753)
  • Fix: Fixed [same] source and destination connection, [different] data table column data merge process (Appending rows) option to disable status (5753)
  • Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.8.1.0 (2015/09/30) (5753)
  • Upd: Accumulated other contains minor updates, correction and optimization (5753)

New in dbMigration .NET 1.5.5744.2 (Sep 23, 2015)

  • Upd: Information row migration (merger) process (Appending rows)

New in dbMigration .NET 1.3.5742.1 (Sep 21, 2015)

  • Upd: Information row migration (merger) process (Appending rows):
  • Add: allows the [same] source and destination connection, [different] columns data sheet consolidation process (5742)
  • Fix: (SQLCe / SQLAzure / SQLServer / Sybase) correction data column can not be merged when the data table containing the fields of auto-increment issue (5742)
  • Upd: source and destination data table the same as the auto-increment field (AUTO_INCREMENT), will retain the source increment value (5742) non-merger
  • Fix: Fixed some source repository status bar is not displayed correctly (NOT NULL) of (5742)
  • Upd: Improved Decimal data type Maximum processing, when the source of the field length exceeds the purpose of field, automatically takes the maximum value for the purpose of data fields (along with other data types) (5735)
  • Fix: Fixed file type repository can not be the role of memory problems when checking the password (5735)
  • Upd: Improved Teradata database provide a more complete error message is displayed (5735)
  • Upd: Accumulated other contains minor updates, correction and optimization (5742)
  • Upd: PostgreSQL components updated to Npgsql.dll 2.2.7 (2015/09/18) (5742)
  • Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.6 (2015/09/15) (5742)
  • Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.8.0.0 (2015/09/14) (5742)
  • Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.0 (2015/09/08) (5735)
  • Misc: Compatible with NuoDB 2.3.1 (2015/09)
  • Upd: Information row migration (merger) process (Appending rows):
  • Add: allows the [same] source and destination connection, [different] columns data sheet consolidation process (5742)
  • Fix: (SQLCe / SQLAzure / SQLServer / Sybase) correction data column can not be merged when the data table containing the fields of auto-increment issue (5742)
  • Upd: source and destination data table the same as the auto-increment field (AUTO_INCREMENT), will retain the source increment value (5742) non-merger
  • Fix: Fixed some source repository status bar is not displayed correctly (NOT NULL) of (5742)
  • Upd: Improved Decimal data type Maximum processing, when the source of the field length exceeds the purpose of field, automatically takes the maximum value for the purpose of data fields (along with other data types) (5735)
  • Fix: Fixed file type repository can not be the role of memory problems when checking the password (5735)
  • Upd: Improved Teradata database provide a more complete error message is displayed (5735)
  • Upd: Accumulated other contains minor updates, correction and optimization (5742)
  • Upd: PostgreSQL components updated to Npgsql.dll 2.2.7 (2015/09/18) (5742)
  • Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.6 (2015/09/15) (5742)
  • Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.8.0.0 (2015/09/14) (5742)
  • Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.0 (2015/09/08) (5735)
  • Misc: Compatible with NuoDB 2.3.1 (2015/09)

New in dbMigration .NET 1.3.5731.3 (Sep 14, 2015)

  • Upd: Improved Decimal data type Maximum processing, when the source of the field length exceeds the purpose of field, automatically takes the maximum value for the purpose of data fields (along with other data types) (5735)
  • Fix: Fixed file type repository can not be the role of memory problems when checking the password (5735)
  • Upd: Improved Teradata database provide a more complete error message is displayed (5735)
  • Upd: Accumulated other contains minor updates, correction and optimization (5735)
  • Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.5 (2015/09/09) (5735)
  • Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.0 (2015/09/08) (5735)
  • Misc: Compatible with NuoDB 2.3.1 (2015/09)

New in dbMigration .NET 1.3.5731.1 (Sep 11, 2015)

  • Add: Support TimeSpan to DateTime data type conversion process (5731)
  • Upd: re-click the connection when recoverable last selected SchemaName (non-wired way through a fast selection) (5731)
  • Upd: Improved text data type String automatic matching process (5731)
  • Upd: Improved exception handling and error message is displayed (5731)
  • Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.0 (2015/09/08) (5731)
  • Upd: Accumulated other contains minor updates, correction and optimization (5731)
  • Misc: Built to Database .NET Professional (64bit) (Native 64bit and Built-in Data Migration) (5731)
  • Note: The Professional Edition's built-in does not support dBase, FoxPro and the command-line processing (No dBase, FoxPro and Command-line support for Pro)

New in dbMigration .NET 1.3.5725.1 (Sep 4, 2015)

  • Added:
  • Support for Array Data Type conversions
  • Support for DateTimeOffset to DateTime, TimeSpan ... and other data type conversion process
  • Source field to increase the system prompt message type (System Type Tooltips); the ability to easily customize the data type (UDT) is now clearly shown
  • Fixed:
  • Fixed DateTimeOffset to DateTimeOffset data type conversion process
  • Sources of information filtering ( Filter Source Data ) and the destination repository results ( results Show target problem-solving part of the data type can not be displayed )
  • Updated:
  • Improved DateTime / TimeStamp date data type automatic matching process
  • Improved binary BLOB data type conversion process
  • Other minor updates, corrections, and optimizations

New in dbMigration .NET 1.2.5721.1 (Aug 31, 2015)

  • Added:
  • Support for Generic ODBC / Generic OleDB common connections repository
  • Automatically match [same] database [different version] of data type handling
  • Updated:
  • If the library source and destination are the same, the connection list will be synchronized to change (add / delete / update)
  • PostgreSQL components updated to Npgsql.dll 2.2.6 (2015/08/27)
  • Accumulated other minor updates, corrections and optimizations
  • Fixed:
  • Fixed and improved migration process to minimize the problem and interrupt handling

New in dbMigration .NET 1.1.5717.1 (Aug 27, 2015)

  • Added:
  • Support for Excel repository
  • Supports VIEWS Entity Data Migration
  • Support Groups Categories Show, Including TABLES / SYSTABLES / VIEWS / SYSVIEWS peer groups
  • Total increase object display
  • Updated:
  • Improved servo version repository after [New] Connection failure handling
  • Support Connection settings SCHEMA preset specification
  • Other minor updates, corrections and optimizations
  • Fixed:
  • Oracle database table data can not be correctly displayed