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

Thanks for the extra info Sybrandb.

While you were typing <g> I found the DBA menu and the "Compare Schema" option, and this did indeed produce the sync scripts you were telling me about. Unfortunately, the scripts could not be copied, run or anything like that using my companies version of TOAD, as we don't have the "dba module". My IT dept is checking out the costs involved...

... but that didn't stop industrious me :) I setup a new Printer using the FILE: port to Print these sync queries, then copied and formatted the contents of that file back to TOAD and ran the queries that way.. worked a treat!

Wouldn't have got even close without your input... cheers!

Kevin

sybrandb wrote:
> Actually, 9.0 just hit the market.
>
> I'm running 8.6.0.36, with several options, among them the DBA option.
>
> When I click DBA, the second lowest line shows 'Compare schemas'
> I can select which object types to compare, and I can provide a script
> filename.
> This results in a series of ALTER statements.
>
> I really don't know when this was introduced, and/or in which modules,
> sorry.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
>
> On Nov 30, 3:03 pm, "Kevin Blount" <kevin.blo..._at_gmail.com> wrote:
> > 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- Hide quoted text -- Show quoted text -
Received on Thu Nov 30 2006 - 17:44:13 CET