Support for foreign keys in Migrations


#1

Is there any work being done to add support for defining foreign keys in
ActiveRecord Migrations? If not is it something that people would find
useful or do most people here believe in the “Application Database”
style
over the “Integration Database” style [1] as defined by Fowler?

I’d love to see support for foreign keys in Migrations. For selfish
reasons
I’d be most interested in such support for SQL Server and Oracle.

Cheers,
Steve

[1] http://martinfowler.com/bliki/DatabaseStyles.html


#2

This plugin does it for mysql & postgre.
http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin


#3

Joshua B. wrote:

This plugin does it for mysql & postgre.
http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin

maybe a little simpler - but so far servicing my needs, hadn’t looked at
the other one until now.

http://blog.alancfrancis.com/2005/11/add_foreign_key.html


#4

Joshua/Darragh,

Thanks for the pointers to the plugins!