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.



>
> -- 
> Sowjanya
> Wipro Technologies
>  Bangalore
>