{"id":45656,"date":"2026-09-14T02:50:00","date_gmt":"2026-09-14T02:50:00","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=45656"},"modified":"2026-09-16T03:50:14","modified_gmt":"2026-09-16T03:50:14","slug":"dbcopier-3-0-released","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/pr\/dbcopier-3-0-released.html","title":{"rendered":"DBCopier 3.0 Released: Preview Plan, Safer Writes &#038; Faster Updates"},"content":{"rendered":"<p>September 14, 2026 \u2014 Withdata Software announces <strong><a href=\"https:\/\/www.withdata.com\/db-copier\/\">DBCopier 3.0<\/a><\/strong>, a cross-platform desktop tool for copying data between databases. This is the biggest update to DBCopier so far: a <strong>Preview Plan<\/strong> that shows exactly what will happen before anything is written, safer and faster update \/ upsert, and a long list of usability improvements for DBAs and developers.<\/p>\n<h2>What\u2019s New in DBCopier 3.0<\/h2>\n<h3>1. Preview Plan \u2014 See What Will Happen Before You Copy<\/h3>\n<p>Before anything is written, DBCopier 3.0 can show you the plan: the target table of every item, the field map risks, and the number of rows each item will move. Field map risks are also shown in the map dialog \u2014 NOT NULL columns, primary \/ unique key problems, and required columns that are not mapped. You fix problems before a run instead of after one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/db-copier\/db-copier.png\" alt=\"DBCopier 3.0 \u2013 Preview Plan, field map risks and faster database copy\" width=\"954\" height=\"702\" style=\"max-width:100%; height:auto; display:block;\" \/><\/p>\n<h3>2. Safer Writes on Busy Databases<\/h3>\n<p>A long copy no longer fails just because a database was busy for a moment. DBCopier now waits and retries on deadlock, lock timeout and lost connection, and a paused conversion is kept alive and reconnects when it resumes. Records that reported a write error are confirmed before they are called failed, and the bad record file is dropped when they all reached the table. A temporary connection problem is no longer reported as an error \u2014 only real data errors raise the error dialog.<\/p>\n<h3>3. Faster Update and Upsert<\/h3>\n<ul>\n<li>Choose an update key per item (\u201cClick To Config\u201d), including multi-column keys.<\/li>\n<li>An index is created on the update key automatically, so update and upsert are much faster.<\/li>\n<li>Update and upsert are written in batches on SQL Server and Oracle.<\/li>\n<li>Tables created by a run now get a primary key.<\/li>\n<\/ul>\n<h3>4. Better Control, Logging and Notifications<\/h3>\n<ul>\n<li>New \u201cOptions \/ Settings\u201d; the log filter and the finish notification are kept for the next run.<\/li>\n<li>A log filter by level, keyword, or only the current item, plus Copy Log \/ Save Log in the output windows.<\/li>\n<li>\u201cNotify me when the conversion is done\u201d, with an optional sound.<\/li>\n<\/ul>\n<h3>5. Field Mapping, Sessions and Other Improvements<\/h3>\n<ul>\n<li>Save, load and clear the field mapping of a session; the mapping is fixed automatically after the source columns changed; losing the target tables when a session was loaded is fixed.<\/li>\n<li>Editing the structure of a SQLite table: drop a column and rebuild the table.<\/li>\n<li>Copy Names \/ Export DDL \/ Drop Selected, and a search filter in the object tree.<\/li>\n<li>Some minor bug fixes and improvements.<\/li>\n<\/ul>\n<h2>About DBCopier<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/db-copier\/\">DBCopier<\/a> copies data between databases, fast and locally, without coding.<\/p>\n<ul>\n<li>Copy a table, several tables, a query result, or a whole database between databases<\/li>\n<li>Over 20 supported databases: Access, MySQL, Oracle, PostgreSQL, SQL Server, SQLite, DB2, Redshift, Azure, DBF and more<\/li>\n<li>Direct copy, update and upsert; similar tables can be merged into one target table<\/li>\n<li>Field mapping with risk checks, preview plan, and saved sessions for repeated jobs<\/li>\n<li>Batch copy, command line, and scheduled tasks for automation<\/li>\n<li>Cross-platform: Windows, Linux, macOS<\/li>\n<li>Fully local offline processing; no data uploaded to cloud servers<\/li>\n<\/ul>\n<h2>Upgrade Today<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/db-copier\/\">DBCopier 3.0<\/a> is ready for download: <a href=\"https:\/\/www.withdata.com\/db-copier\/download.html\">https:\/\/www.withdata.com\/db-copier\/download.html<\/a>. Existing users may update directly. New users can download a free trial to try the new Preview Plan and the faster, safer update \/ upsert.<\/p>\n<p>Withdata Software continues optimizing DBCopier for real-world database copy and migration scenarios based on user feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>September 14, 2026 \u2014 Withdata Software announces DBCopier 3.0, a cross-platform desktop tool for copying data between databases. This is the biggest update to DBCopier so far: a Preview Plan that shows exactly what will happen before anything is written, safer and faster update \/ upsert, and a long list of usability improvements for DBAs [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[13769,13762,13760,13770,1325,1321],"class_list":["post-45656","post","type-post","status-publish","format-standard","hentry","category-pr","tag-database-copy","tag-database-migration","tag-dba","tag-dbcopier","tag-oracle","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=45656"}],"version-history":[{"count":2,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45656\/revisions"}],"predecessor-version":[{"id":45664,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45656\/revisions\/45664"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=45656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=45656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=45656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}