Bug #16739 for SQL-Translator: Integrate with ActiveRecord::Migrations

Mon Dec 26 21:38:56 2005 Guest - Ticket created

Subject:

Integrate with ActiveRecord::Migrations

SQL::Translator is great! One thing that I think would help it a lot is to be able to read/write the universal SQL format in ActiveRecord::Migration [http://api.rubyonrails.com/classes/ActiveRecord/Migration.html] . This is a universal SQL format, which works for any database that ActiveRecord supports (which is a lot!). ActiveRecord can dump the schema, and it can create tables from the schema, but it can't diff them. If SQL::Translator spoke Migration, we would have a system which can easily dump, diff, and load schemas from and to almost any db. Plus, Migration supports basic version control and deployment on the db's.

Mon Jul 24 03:04:02 2006 cpan [...] desert-island.me.uk - Correspondence added

On Mon Dec 26 21:38:56 2005, guest wrote: Show quoted text

> SQL::Translator is great! > > One thing that I think would help it a lot is to be able to read/write > the universal SQL format in ActiveRecord::Migration > [http://api.rubyonrails.com/classes/ActiveRecord/Migration.html] . > This is a universal SQL format, which works for any database that > ActiveRecord supports (which is a lot!). > > ActiveRecord can dump the schema, and it can create tables from the > schema, but it can't diff them. > > If SQL::Translator spoke Migration, we would have a system which can > easily dump, diff, and load schemas from and to almost any db. > > Plus, Migration supports basic version control and deployment on the > db's.

Parsers and Producers for SQL::Translator are fairly straight forward to write, if you'd like to contribute some, we'd be happy to include them. Else I'll try and find time to take a look. Jess

Mon Jul 24 03:04:02 2006 The RT System itself - Status changed from 'new' to 'open'

Mon Jul 24 03:04:04 2006 cpan [...] desert-island.me.uk - Given to JROBINSON