On 07/29/2010 03:43 AM, Fabian Marin wrote:
> Robert Klemme wrote:
>
>> The key question is: can an AR model represent a DB schema entirely?
>> What does it tell you about constraints and triggers?  Does it cover all
>> sorts of special indexes as Oracle's FBI's and special types found only
>> in one RDBMS?
>
> The answer might be that it cannot, it's a matter of where you put your
> logic.  RoR relies on logic in the AR model even for testing constraints
> like uniqueness, as far as I know.  They themselves admit RoR is
> opinionated in many respects.  I guess such a tool won't be useful for
> developers that have opted for an architecture strongly reliant on the
> Database (i.e. using triggers, stored procedures, sequences and so
> forth).

But what are you looking for?  The subject says you want to compare a 
schema and a DDL file now it seems you need to compare a schema and an 
AR model.  These are two quite different sets of requirements.

Cheers

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/