Because of the work, so there is more contact with db2db. However, since the previous version has been able to meet the needs of the work, until recently updated to the latest version, and summarized the new version of the update history, found that db2db more than a year has included the following significant updates:
- Added support for Postgressql database, currently supports SQL Server, MySQL, SQLite, Postgressql, Access, SQL CE, Oracle (test) 7 major databases
- Added global data filtering for scenarios where only a subset of the data in a table can be converted (example: Cloud Platform with table multi-tenancy to convert all table data of one of the tenants)
- Added timing data synchronization, support by minutes, hours, days, weeks, months, multiple synchronization mode
- Added statistics throughout the statistical process, data reads and data writes are time-consuming to count
- Optimized data import performance and significantly improved data tables with a particularly large single-table data size
- Optimized overall support for MySQL and added "Select character encoding", "Database Engine" two parameters
- Optimized the operation interface, changed from the original window operation to the wizard mode
- Fixed multiple issues with user feedback
The support and performance of the Postgressql database is very important to me, the performance of the upgrade although there is no specific test data, but in the process of data conversion is obviously not the original "more to the back of the slower" feeling, this must praise one.
DB2DB a major update over the past year