On 5/10/2010 7:07 AM, Steve Singer wrote:
> On Mon, 10 May 2010, sowjanya v wrote:
> 
>> Hi,
>>
>> I have two databases db1 and db2. db2 is replica of db1. Now i have added a
>> column in a table in db1. Since schema changes do not propogate by itself to
>> db2, need to execute execute script. But the input for that is a sql file
>> with all  difference in schema. Hence please let me know how replicate the
>> schema changes. If i do the diff of two schemas, it only shows the lines
>> where the difference is present and not the sql command to be executed on
>> db2 to make it same as db1. Please do reply immediately.
> 
> What do you mean by 'with all difference in schema'? Are you saying that db1 
> and db2 have a different schema on them? Specifically different columns for 
> the same table? If so I think your asking for trouble.

Sounds to me as if Sowjanya already did all the DDL against db1, 
probably manually and not protocoling what exactly was done, and is now 
looking for some automagical way to get db2's schema back into sync.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin