DBCopier 3.0 Released
Download
2026/09/14
V3.0 Released
Add "Options / Settings"; the log filter and the finish notify are kept for the next run.
Add "Preview Plan": the target table, the field map risks and the number of rows of every item before anything is written.
Show the field map risks in the map dialog (NOT NULL, primary/unique, unmapped required columns).
Add saving, loading and clearing the field mapping of a session.
Add "Notify me when the conversion is done", with an optional sound.
Add a log filter (level, keyword, only the current item) and Copy Log / Save Log to the output windows.
Add choosing an update key per item ("Click To Config"), with multi-column keys; tables created by the run get a primary key.
Create an index on the update key automatically, so update and upsert are much faster.
Write update and upsert in batches (SQL Server and Oracle).
Wait and retry when the database is temporarily busy (deadlock, lock timeout, lost connection); a paused conversion is kept alive and reconnects when it resumes.
Confirm the records that reported a write error before calling them failed, and drop the bad record file when they all reached the table.
A temporary connection problem is no longer reported as an error; only real data errors raise the error dialog.
Fix field mapping after the source columns changed, and fix losing the target tables when a session was loaded.
Editing the structure of a SQLite table: drop a column and rebuild the table.
Add Copy Names / Export DDL / Drop Selected and a search filter to the object tree.
Some minor bug fixes and improvements.
2025/11/05
V2.9 Released
Add "Show/Hide MEMO (TEXT/CLOB) data in grid".
Add importing via "update/upsert with multi-column keys".
Improve data type map.
Improve reading SQLite varchar data.
2025/07/22
V2.8 Released
Improve converting performance.
2025/02/12
V2.7 Released
Add batch upserting.
2024/09/09
V2.6 Released
Add support to InterBase/FireBird database.
Improve mapping field types.
2024/04/02
V2.5 Released
Add support Access in Linux and macOS.
Add support SSL connection to MySQL.
Improve support SSL connection to PostgreSQL.
Improve support to Access in Windows.
Improve support to UUID/GUID.
2024/02/18
V2.4 Released
Improve support to convert json/jsonb data.
Improve support to multiple monitors.
Some minor bug fixes and improvements.
2023/08/08
V2.3 Released
Improve progress UI.
2023/07/12
V2.2 Released
Fix bugs on wizard.
Improve exception report.
2023/05/12
V2.1 Released
Add more "Help" buttons, and "Help" web pages.
Add support to Oracle XMLTYPE.
Improve importing performance.
Some minor bug fixes and improvements.
2023/03/30
V1.9 Released
Fix coping data from SQL query contains "group by".
Fix importing data after creating table automatically.
Improve "Replace" loading for DBF, add "PACK".
Improve importing to DBF.
2022/10/08
V1.8 Released
Fix logon form.
Improve creating batch/shell file.
Some minor bug fixes and improvements.
2022/09/09
V1.7 Released
Add edit table struct.
Improve copy data to same type database.
2022/08/04
V1.6 Released
Fix refresh tables when changed schema.
Some minor bug fixes and improvements.
2022/07/14
V1.5 Released
Add support ssl logon to PostgreSQL.
Improve support to Linux command line.
Some minor bug fixes and improvements.
2022/06/01
V1.4 Released
Add Azure SQL logon form.
Improve login to SQLite.
2022/05/04
V1.3 Released
Add support to Redshift.
2022/04/28
V1.2 Released
Fix create indexes on creating table, more than one index.
2022/03/21
V1.1 Released
Fix convert n to 1, with different column count or orders.
Improve "show query error message" in executing query.
2022/02/24
V1.0 Released