Re: Cmd line DB compare tool for Oracle

From: Chris O <itoys1>
Date: Tue, 18 Nov 2003 15:18:58 +1000
Message-ID: <3fb9b7fe$0$20308$afc38c87@news.optusnet.com.au>

"ask" <samk_at_vwebsol.com> wrote in message news:22e5a971.0311170243.1dd81c84_at_posting.google.com...
> Hi
>
> can someone suggest me where i can find a tool(free/commercial) to
> compare the oracle DB schemas/data which also has a cmd line interface
> since i want it to be automated.
> The DBDiff looks nice but seems it does not have a cmd line interface.
>
> thanks
>
> Sam

Hi Sam. Oracle Change Manager which is one of the Enterprise Management packs compares schemas and provides the ability to run the job in the background. I'm not sure about re-submissions but it should be possible. As for comparing data, do you mean application data or meta-data? If it is application data that you want to compare then I don't think Change Manager will do that.

Some others that I know of and which provide some form of background execution facility. I'm not sure whether any of these compare application data.

BMC's Change Manager: http://www.bmc.com/ Embarcadero's Change Manager:
http://www.embarcadero.com/products/changemanager/index.asp Quest's Schema Manager: http://www.quest.com/schema_manager/ Quest's TOAD (with optional DBA module): http://www.quest.com/toad/

Cheers Chris Received on Mon Nov 17 2003 - 23:18:58 CST