Oracle Database Sync

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now.

I will show here a very fast way of comparing different database and auto-generate migration script.

  1. Reverse engineer the source database using Oracle Data Modeler
  2. Now select the right arrow  shown below:
    sync-with-db
  3. Select the destination datasource (more here) when asked.
  4. The compare pane will enable you to compare the databases.
    But the default options will also use schema name to detect different object, so you will not get what you want in every scenario.
    In 50% of my daily job, schema are different, so you must select the options below to fix it:
    Select “Options” and then “Compare options”. Then  de-select “Use schema property” like suggested below:
    magic-option
  5. Push the “Sync new object”. Then push the “DLL Preview” button and inspect the generated database.
  6. Bonus: by default the tool will not include tables to drop. Inspect the two pane ad check the table you want to drop in the left pane.
  7. Refrain launching the script without proper testing. You are migrating your valuable data.

Unison File Synchronizer

Several years ago I had the need of keep in sync three computers.  After some questions on a java mailing list, a very smart guy suggested me Unison.


Unison is a file-synchronization tool for Unix and Windows. It allows two replicas of a collection of files and directories to be stored on different hosts (or different disks on the same host), modified separately, and then brought up to date by propagating the changes in each replica to the other.

Unison shares a number of features with tools such as configuration management packages (CVS, PRCS, Subversion, BitKeeper, etc.), distributed filesystems (Coda, etc.), uni-directional mirroring utilities (rsync, etc.), and other synchronizers (Intellisync, Reconcile, etc). However, there are several points where it differs:[…]

read the rest on  Unison File Synchronizer.

Unison seems a bit lost in cyberspace (no new features) but the users mailing list spot some activity, so I will suggest to give it a try, because its sync alghoritm is very well written, and the MS-Window interface is good.