I would use
- docker image,
- test-data-ninja
http://www.codemonth.dk/code_is_good/dev_qa_prod.assert?condition=codemonth:::20::Easily-generate-millions-of-rows-of-random-test-data-using-a-PLSQL-API
.
- utPLSQL v3 for unit testing
Cheers
Jacek
On 11 Aug 2017 18:45, "Gerald Venzl" <gerald.venzl@xxxxxxxxxx> wrote:
Hey Chris,
Many people use Docker for this these days.
Docker integrates well with almost all CI/CD tools and it allows you to
spin up a DB fast and just throw it away afterwards, which makes it perfect
for Unit Testing.
If you don’t even need any data or not much, it’s a great fit.
If you do need a lot of data or more sophisticated snapshot and rollback
then probably not so much.
Another benefit of Docker is that Community Edition is free which is
probably all you need for unit testing.
Community Edition also ships in the Oracle Linux addons if you happen to
run on OL.
Thx,
---------------
Gerald Venzl | Senior Principal Product Manager
Email: gerald.venzl@xxxxxxxxxx | Phone: +1.650.633.0085 <+16506330085>
Oracle ST & Database Development
400 Oracle Parkway | Redwood Shores | 94065 | USA
On Aug 11, 2017, at 10:35, Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx>
wrote:
Which would result in a storage purchase, scripting project to manage it
all and lock into hardware. Delphix and a couple others work on any
hardware, are cloud mobile and have a self-service portal so the DBA
doesn't have to manage it all. The new pricing model makes it worth the
look!
Yes, I work for Delphix...:)
Kellyn Gorman
Technical Intelligence Manager
On Fri, Aug 11, 2017 at 1:31 PM Stefan Koehler <contact@xxxxxxxx> wrote:
Hey Chris,
you don't need any special product for this purpose - just a CoW
filesystem with snapshot technology like ZFS :)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=uoe2_mIWZYIS115tKAaYX0r7QALuXiZxvhULSzWKSD0&e=>
Twitter: @OracleSK
Chris Taylor <christopherdtaylor1994@xxxxxxxxx> hat am 11. August 2017um 19:25 geschrieben:
Unit Test databases (without data) that they can spin up on demand and
We've got a relatively large development group who want to have many
destroy when done.
like this?
I'm curious what products are available that could facilitate something
used for testing)
I was thinking something like this:
Unit Test (UT Master) - code replicated from production nightly (never
using something like:
How could I facilitate users creating a copy on demand of UTMaster
like this.
VMWare or
Delphix or
Docker or
something
I'm basically looking to see what options are to accomplish something
into another copy for a specific developer on demand.
I was thinking if we stood up UT Master on a VM, we could snap the VM
--
Chris
//www.freelists.org/webpage/oracle-l
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=PhZW7UpUQnZi_JN31FnzAI_J16qg7dXBnptd-jhSFJU&e=>
--
[image: Kellyn Pot'Vin on about.me]
Kellyn Pot'Vin-Gorman
about.me/dbakevlar
<https://urldefense.proofpoint.com/v2/url?u=http-3A__about.me_dbakevlar&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=PcyHrWG_Og5V5tM02fFWQOL6xjV3Z4h3lPOOgXMvR6o&e=>