https://wiki.commander4j.com/index.php?action=history&feed=atom&title=Clone4jClone4j - Revision history2026-04-27T23:03:12ZRevision history for this page on the wikiMediaWiki 1.42.1https://wiki.commander4j.com/index.php?title=Clone4j&diff=1817&oldid=prevDgarratt: Updated by push_wiki.py2026-04-05T16:01:21Z<p>Updated by push_wiki.py</p>
<p><b>New page</b></p><div>'''Clone4j''' is a database copy utility included with Commander4j. It copies the entire contents of one Commander4j database into another, and supports copying between different database types — for example from SQL Server to MySQL or from MySQL to Oracle.<br />
<br />
Clone4j is launched from the <code>Clone4j.exe</code> executable in the Commander4j installation directory. It requires administrator privileges (the launcher requests elevation on Windows).<br />
<br />
== When to Use Clone4j ==<br />
<br />
Typical uses include:<br />
<br />
* Copying a live production database to a test or development environment<br />
* Migrating data when moving a site from one database platform to another<br />
* Creating a full backup copy of the database in a different database instance<br />
<br />
== Prerequisites ==<br />
<br />
Before running Clone4j:<br />
<br />
* Both the source and destination databases must be defined as hosts in <code>hosts.xml</code> (use [[Setup4j]] to configure host connections)<br />
* Both databases must be on the '''same schema version''' — Clone4j will refuse to proceed if the schema versions differ<br />
* Both databases must have the same number of tables — they must be on identical schema revisions with no partial upgrades applied<br />
* The destination database will have '''all its data erased''' and replaced with the source data<br />
<br />
== Using Clone4j ==<br />
<br />
# Launch <code>Clone4j.exe</code><br />
# The window shows two lists populated from <code>hosts.xml</code> — select the '''source''' database on the left and the '''destination''' database on the right<br />
# Click '''Clone Database'''<br />
# A confirmation prompt warns that all data in the destination will be erased — confirm to proceed<br />
# Clone4j copies every table in sequence, updating a progress bar as it works<br />
# On completion, the status bar reports the outcome<br />
<br />
The Clone button is only enabled when both a source and a destination have been selected and they are not the same host.<br />
<br />
== Limitations ==<br />
<br />
* Clone4j copies data row by row — it is not a structural migration tool. Both databases must already have matching schemas (same schema version, same table count).<br />
* It is not designed for continuous replication. It is a one-time full copy.<br />
* Large databases may take several minutes to clone depending on row count and network speed.<br />
<br />
See also: [[Setup4j]], [[Installation]], [[Upgrading]]<br />
<br />
[[Category:Commander4j]]</div>Dgarratt