Re: TOAD for Oracle: Copy new columns from one schema to another?

[Quoted] [Quoted] I have found the "compare schemas" feature (it's the "Compare with another object" feature, right?) and saw the differences, but could not see any way to generate the code you mentioned.

Looking at the "File Difference" screen, I see all the differences (naturally) but I don't see any icons above for generating the code. COuld you tell me what to look for?

I'm sure it might make the difference, but my company is running Toad for Oracle 8.5 - are there newer versions?

Many thanks

Kevin

sybrandb wrote:
> Kevin Blount wrote:
> > I have two schema that I use: one for development and one that's used
> > for live data.
> >
> > I'm currently working on a large project so I have extensive updates to
> > the development schema and various databases within it. In most cases
> > this is just the addition of new columns to an existing table, but in
> > other cases it's a whole new table.
> >
> > I can handle adding the complete new tables (right-click: Create in
> > another schema) but I can't find a way to add selected columns from one
> > schema to another.
> >
> > e.g. I have a common table (between dev and live) with 30 columns. I
> > added another 5 to the dev table, and need now to get those 5 to the
> > live table. In some cases there are less than 5, but there are also
> > cases where there are more, sometimes a lot more.
> >
> > Is there a Toad for Oracle function that will allow me to select the
> > new columns in my dev table, and copy them to the live table?
> >
> > If not, would someone be able to advise me on any SQL statements I
> > might use, or do I have to do this manually?
> >
> > TIA
> >
> > Kevin
>
>
> The full version of Toad can *compare schemas* and generate code to
> rectify it in one direction.
> Note: the free version can not do this.
> You can obviously do this yourself by querying the dictionary.
> It is not that difficult.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Nov 30 2006 - 15:03:37 CET