Re: RIP DDL Wizard

Hi Jeff!

I used to use it. It was working on the first generation export files, not on the data pump ones. It was able to extract DDL from the DMP files and it was possible to re-create a schema or two with many fewer errors than without it. However, I haven't used legacy exp/imp tools in a while now and, as somebody else has mentioned, I too am using DBMS_METADATA right now. I am not particularly sad, I haven't used the tool at least in the last 5 years, maybe even longer than that.

Regards

On 3/8/19 8:36 AM, Jeff Smith wrote:
>
> I’ve never heard of it, but I can imagine it’s use cases.
>
> What could it do that SQLcl’s DDL command could not? Maybe there are
> some ER’s we could address on our tooling side to fill any gaps they
> left behind.
>
> *From:* Jacek Gębal <jgebal_at_gmail.com>
> *Sent:* Wednesday, March 6, 2019 5:16 PM
> *To:* dbakevlar_at_gmail.com
> *Cc:* MAdams_at_equian.com; oracle-l_at_freelists.org
> *Subject:* Re: RIP DDL Wizard
>
> utPLSQL was recently supported by RedGate and we're getting interest
> from their side in unit testing for Oracle PL/SQL & SQL.
>
> It seems strange that they are giving up on some of their products for
> Oracle DB given their overall interest in DB DevOps and CI/CD.
>
> Cheers
>
> Jacek
>
> On Wed, 6 Mar 2019 at 20:31, Kellyn Pot'Vin-Gorman
> <dbakevlar_at_gmail.com <mailto:dbakevlar_at_gmail.com>> wrote:
>
> I'm sorry to hear this and will be giving the folks over there a
> hard time about it. Although Redgate doesn't have the following on
> the Oracle side like they do on the Microsoft SQL side, its still
> a shame to see it go.  With their huge impact on the DevOps, CI/CD
> with their SQL Provision, (think thin clone with data masking)
> product plugged in with their SQL Toolbelt, they've got quite the
> customer base, with Oracle supported stuff just a side gig, (same
> with MySQL and other db platforms).
>
> Good to know about DDL Wizard.
>
>
>
>
>
>
> *Kellyn Pot'Vin-Gorman*
>
> DBAKevlar Blog
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__dbakevlar.com&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=jaO-pXepBzSx98nP01x-oAIhEMzgMh8Fn7mQU5Vurwg&s=VyqemNfku-aSC_os5v3yw9HUOra_wrsvVZw6jlQhmwA&e=>
>
> President Denver SQL Server User Group
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__denversql.org_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=jaO-pXepBzSx98nP01x-oAIhEMzgMh8Fn7mQU5Vurwg&s=IOWH2Ub2QnlmU3qd3iUeACipTv6bs7zL6bvSMQ2NLkA&e=>
>
> about.me/dbakevlar
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__about.me_dbakevlar&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=jaO-pXepBzSx98nP01x-oAIhEMzgMh8Fn7mQU5Vurwg&s=Slha4BNoOUQkvO2OCT5V_MPfbI_tgW9H8HIdYamqL6c&e=>
>
> On Wed, Mar 6, 2019 at 3:03 PM Matt Adams <MAdams_at_equian.com
> <mailto:MAdams_at_equian.com>> wrote:
>
> I just found out that Redgate (the purchasers of the DDL
> Wizard developers Net 2000 LTD.)  will no longer supply
> license keys for any version, including the free/unsupported
> version.   Which means that while the software can still be
> downloaded, it’s useless.
>
> I know that DDL Wizard has largely been replaced by the
> DBMS_METADATA package and features built into software
> packages like TOAD and SQL DEVELOPER, but I still used it on a
> regular basis and still loved it.  Unfortunately, my previous
> laptop has died, and I cannot run DDL Wizard on the new one.
>
> This tool was of tremendous benefit in it’s heyday and I for
> one will miss it.
>
> Good bye DDL Wizard.   Rest in Piece.
>
> **** This communication may contain privileged and/or
> confidential information. If you are not the intended
> recipient, you are hereby notified that disclosing, copying,
> or distributing of the contents is strictly prohibited. If you
> have received this message in error, please contact the sender
> immediately and destroy any copies of this document. ****
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l