Skip Menu |
 

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 16739
Status: open
Priority: 0/
Queue: SQL-Translator

People
Owner: cpan [...] desert-island.me.uk
Requestors: eastcoastcoder [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)



Subject: Integrate with ActiveRecord::Migrations
Download (untitled) / with headers
text/plain 634b
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.
Download (untitled) / with headers
text/plain 927b
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


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.