Data Transfer

Copy table data to another connection, database, and schema with live progress.

A wizard for copying table data to another connection - including across engines, with column types mapped for the target and any lossy mappings reported in the summary. Pick source tables from a checkbox list, the target connection, database, and schema, then a write mode - Create table, Append, Truncate then insert, or Upsert on primary key - and an identifier casing (keep, lower_case, or UPPER_CASE, handy when moving between SQL Server and PostgreSQL naming conventions).

This is the one Tools dialog that runs directly rather than scripting first - it is moving rows, not changing definitions - so it is gated accordingly: it refuses production-marked targets, connections with writes disabled, relay-routed targets, and a target identical to the source. Selected tables copy in foreign-key dependency order with a live "Copying table - N rows (i/total)" readout, a Stop button, and a per-table row-count summary at the end. The dialog can also pop out into its own window so a long transfer does not hold the workspace hostage.

SQLly