Better Oracle Support for Db:structure:dump

- -

If you have tried

$ rake db:structure:dump

in a rails app when using Oracle as your database, then you have probably been slightly disappointed. The same rake task for MySQL and Postgres dumps everything you need to recreate the database. The task for Oracle only dumps SQL for the table creation (no constraints), and for the sequences. The active_record_oracle_extensions plug now supports dumping sql for the following:

  • primary keys
  • indexes
  • foreign keys
  • synonyms

I have added enough functionality to scratch my itch. If you need something else or find a bug let me know.