RE: RIP DDL Wizard

From: Matt Adams <MAdams_at_equian.com>
Date: Fri, 8 Mar 2019 17:04:51 +0000
Message-ID: <f18418d700664c29ac40e1b8cf24fca5_at_wpvl1dag04.hcrec.com>



SQL Developer 18.3.0.227

Steps I perform:
Start a schema browser.
Choose a schema other than one I logged in as Choose Packages (note – package bodies is not an option) Highlight all packages (about 50 to 60).

Option 1 - Right click -> Export -> (change file name for output) Next -> Finish

    End up with one package header in file

Option 2 -> Right click -> Quick DDl -> Save to file

    End up with all package headers in file

Still haven’t figure out how to get package bodies generated

From: Jeff Smith <jeff.d.smith_at_oracle.com> Sent: Friday, March 08, 2019 11:09 AM
To: Matt Adams <MAdams_at_equian.com>; Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> Cc: oracle-l_at_freelists.org
Subject: RE: RIP DDL Wizard

>> At the moment, I’m using one of the features of Oracle’s SQL Developer, but I’m having difficulties with that.
Like…?

From: Matt Adams <MAdams_at_equian.com<mailto:MAdams_at_equian.com>> Sent: Friday, March 8, 2019 10:36 AM
To: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com>> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: RIP DDL Wizard

If there’s another tool that works as well as DDL Wizard, I don’t know about it. All I want is a license key to use to most recently available version. I’m not asking for any support. I wouldn’t think that they would care if they don’t have to support it, but obviously there’s more to it than that. At the moment, I’m using one of the features of Oracle’s SQL Developer, but I’m having difficulties with that.

I’d also like them to bring back the DataBee sub-setting tool they got from Net 2000 LTD too. I had finally convinced this place to buy it, only to discover Redgate had bought and buried it 4 months earlier. I’ve had a few discussions with Redgate about this tool, but they apparently have no interest in selling or supporting it.

Matt

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com>> Sent: Friday, March 08, 2019 10:16 AM
To: Matt Adams <MAdams_at_equian.com<mailto:MAdams_at_equian.com>> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: RIP DDL Wizard

Net 2000 was a huge acquisition by Redgate, giving them the masking tool they desired for their SQL Clone to go SQL Provision product. I wouldn't be surprised if they are the lead behind this. The question would be, is there another tool from them that is similar that competes with it? Now that I don't know. I'm more familiar with their cloning and masking products as that was in my wheelhouse while I was at Delphix.

Their marketing just reached out to me yesterday about presenting with them, so I did ask about a PM that I could talk to about this topic, so let me know if getting more info on it is still of interest.

Hope this helps,

Kellyn Pot'Vin-Gorman
DBAKevlar Blog<https://link.zixcentral.com/u/53acb120/ACCreLxB6RGt4VP-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_dcfe2997_etEHG7VB6RGEO94Fh3soMg-3Fu-3Dhttp-253A-252F-252Fdbakevlar.com%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DX30sKT2Igw8FjSvAc-10fN5uuWOOvlDmUQf88CT8J1E%26e%3D> President Denver SQL Server User Group<https://link.zixcentral.com/u/9b3f4285/0IGreLxB6RGt4VP-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_66972249_TiAIG7VB6RGEO94Fh3soMg-3Fu-3Dhttp-253A-252F-252Fdenversql.org-252F%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DS094van8iXJAAbw_ix8Qw36KdYnT4G4jzEOYw66pM2c%26e%3D> about.me/dbakevlar<https://link.zixcentral.com/u/8b2e3526/bNGreLxB6RGt4VP-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_bcd9386e_PL0JG7VB6RGEO94Fh3soMg-3Fu-3Dhttp-253A-252F-252Fabout.me-252Fdbakevlar%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DAG5kesYj5Z-OCTUNqSglUHabfSxmi18NzchtFQ6aZVM%26e%3D>

On Fri, Mar 8, 2019 at 10:10 AM Matt Adams <MAdams_at_equian.com<mailto:MAdams_at_equian.com>> wrote: It may have been discontinued by Net 2000 LTD at Oracle 10, but I was using it with Oracle 11 and 12 up until 2 months ago with no problems.

Matt

From: Jacek Gębal <jgebal_at_gmail.com<mailto:jgebal_at_gmail.com>> Sent: Friday, March 08, 2019 9:55 AM
To: Jeff Smith <jeff.d.smith_at_oracle.com<mailto:jeff.d.smith_at_oracle.com>> Cc: dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com>; Matt Adams <MAdams_at_equian.com<mailto:MAdams_at_equian.com>>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: RIP DDL Wizard

I got some feedback from a colleague at RedGate.

"... Just asked internally. This tool was discontinued at Oracle 10 anyway, even by Net2000. So hardly surprising that it's not available ..."

On Fri, 8 Mar 2019, 14:36 Jeff Smith, <jeff.d.smith_at_oracle.com<mailto:jeff.d.smith_at_oracle.com>> 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<mailto:jgebal_at_gmail.com>> Sent: Wednesday, March 6, 2019 5:16 PM
To: dbakevlar_at_gmail.com<mailto:dbakevlar_at_gmail.com> Cc: MAdams_at_equian.com<mailto:MAdams_at_equian.com>; oracle-l_at_freelists.org<mailto: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://link.zixcentral.com/u/1015ebb4/Jl2xeLxB6RG8r1P-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_435070df_JOHYLrJB6RGTLOHm9e-5F1Kg-3Fu-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fdbakevlar.com-2526d-253DDwMFaQ-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253DjaO-2DpXepBzSx98nP01x-2DoAIhEMzgMh8Fn7mQU5Vurwg-2526s-253DVyqemNfku-2DaSC-5Fos5v3yw9HUOra-5FwrsvVZw6jlQhmwA-2526e-253D%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DaaB_GnUdndLhiJxeu4cMWzwt9KeVFmOmSKkdVBiyOW8%26e%3D> President Denver SQL Server User Group<https://link.zixcentral.com/u/eb92455e/fq6yeLxB6RG8r1P-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_fa8662d4_aBXZLrJB6RGTLOHm9e-5F1Kg-3Fu-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fdenversql.org-5F-2526d-253DDwMFaQ-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253DjaO-2DpXepBzSx98nP01x-2DoAIhEMzgMh8Fn7mQU5Vurwg-2526s-253DIOWH2Ub2QnlmU3qd3iUeACipTv6bs7zL6bvSMQ2NLkA-2526e-253D%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3DlHj0z6ml3_IvuQGB2CYLZz503gpYCocX1idge-PicZg%26e%3D> about.me/dbakevlar<https://link.zixcentral.com/u/dcce25a5/WPKyeLxB6RG8r1P-hnsoMg?u=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__link.zixcentral.com_u_19b0a4e6_fkXZLrJB6RGTLOHm9e-5F1Kg-3Fu-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttp-2D3A-5F-5Fabout.me-5Fdbakevlar-2526d-253DDwMFaQ-2526c-253DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI-5FJnE-2526r-253DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM-2526m-253DjaO-2DpXepBzSx98nP01x-2DoAIhEMzgMh8Fn7mQU5Vurwg-2526s-253DSlha4BNoOUQkvO2OCT5V-5FMPfbI-5FtgW9H8HIdYamqL6c-2526e-253D%26d%3DDwMGaQ%26c%3DRoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE%26r%3DN2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM%26m%3DZSX-xCPiR7aJHsBOQPn1gREhsLcODA7pP2BEhCf5DxQ%26s%3D3-IaQaz-SviEDCGZQwIXFuiR7exkgnJwbl7ooUUrTAA%26e%3D>

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. ****
  • 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. ****
  • 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. ****
  • 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. ****
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 08 2019 - 18:04:51 CET

Original text of this message