DB Copy Plugin is a database copying plugin for the SQuirreL SQL Client. It makes it possible to copy and paste tables from one session to another and between different databases and includes primary key and foreign key constraints for copied tables, and uses Hibernate 3.0 internally to perform database object type mappings. It supports Firebird, Oracle, Sybase, MS SQL Server, MySQL, HyperSonic, Pointbase, and PostgreSQL, and allows the user to select a Hibernate dialect for the destination database if one couldn't be determined automatically.
|Tags||Database Front-Ends Archiving Mirroring Systems Administration|
|Operating Systems||OS Independent|
Release Notes: 0.22 (03/18/2006) ==== - Added support for DaffodilDB and H2 (www.h2database.com) - For number type fields, previously, the precision was always the maximum allowed by the destination database. A new mechanism was added to allow the source database precision to be used if it doesn't exceed the destination database's maximum precision. Otherwise the previous behavior (maximum precision allowed by the destination database) is used.
Release Notes: Binary data copy was tested using the newly developed BinaryGenerator plugin for DBMonster. An elapsed time counter and time remaining estimate were added to the progress dialog. An independently configurable delay (with millisecond granularity) between copying records and tables can now be set. This reduces the CPU and IO load on both the client and the database servers. Better support for BOOLEAN types when the source database supports them and the destination database does not was provided. Bugs were fixed.
Release Notes: This release adds the ability to copy to existing table definitions that differ from the source table definitions with regard to column order. (Columns are now matched up by name instead of assuming they are in the same order on the destination database as that of the source database.) Support for the Axion (build M3) Java embedded database was added. Support for the Progress, FrontBase, and Ingres RDBM servers was added. Bugfixes were made.
Release Notes: This release adds custom column type mappings for IBM DB2, and a new configuration option to disable auto-detection of the destination database (which causes the Hibernate dialect chooser to always appear when copying to a new database session; dialect choices are cached for existing sessions). The Oracle type mapping for LONGVARCHAR has been changed to use CLOB instead of LONG, since LONG is deprecated and multiple LONG columns for a single table aren't supported, whereas multiple CLOB columns for a single table are.
Release Notes: This release added support for caching BLOBs to disk during transfer to prevent the client from running out of memory on large BLOBs. The transfer buffer size is configurable. A DB Copy tab was added to the Global Preferences section of SQuirreL for configuring preferences for the plugin. Support for choosing additional Hibernate dialects from DB2, Derby, FrontBase, Informix, Ingres, Interbase, McKoi, and TimesTen if the destination database vendor couldn't be determined was added.