Re: Developers wanting individual Unit Test (no data) databases - suggestions?

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: Jacek Gębal <jgebal@xxxxxxxxx>
  • Date: Sat, 12 Aug 2017 09:01:23 -0600

SDLC is not a straight line going one direction or another, but a circle, always has been (i.e. PROD > DEV > SIT > UAT > PROD).

It just moves faster now.

On 8/12/17 03:23, Jacek Gębal wrote:

I think that the need to clone and refresh from prod to dev every few days/weeks/months is indicating a gap in the development and delivery process.

You should move your code form Dev to Prod not the other way around.

Investing in tools and processes to patch that gap seems an expensive workaround for lack of clean development process.

I would have the golden copy done on dev, after every release.

On 11 Aug 2017 21:34, "Tim Gorman" <tim.evdbt@xxxxxxxxx <mailto:tim.evdbt@xxxxxxxxx>> wrote:

    It's always kinda fun when someone says, "but I don't want the
    whole database - I just want X, Y, and Z from it".

    OK.  Don't look at everything.  The full copy is available in
    minutes and takes no storage, what is so bad about that?

    Or, if you absolutely don't want the extra stuff to exist, then do
    DROPs or TRUNCATEs as post-processing when cloning/refreshing the
    virtual database?

    I can spin up an environment in a couple minutes, giving you full
    root, oracle, and delphix access, and you can check it all out.

    On 8/11/17 12:06, Jacek Gębal wrote:
    I think the requirement is tho have empty db, so only code and
    structures would be cloned from prod into the master copy.

    On 11 Aug 2017 19:00, "Tim Gorman" <tim.evdbt@xxxxxxxxx
    <mailto:tim.evdbt@xxxxxxxxx>> wrote:

        This is how most (if not all) of 300+ customers use Delphix
        for virtualizing Oracle, MSSQL, DB2, Sybase, and application

        Make full-size, read-write clones quickly and cheaply, use
        them, get rid of them, or archive them for easy restore.

        If you want a full environment to play with and show you
        around, I can make one for you in a couple minutes.

        Full disclosure:  I work for Delphix.  Not sales, just

        On 8/11/17 11:25, Chris Taylor wrote:
        We've got a relatively large development group who want to
        have many Unit Test databases (without data) that they can
        spin up on demand and destroy when done.

        I'm curious what products are available that could
        facilitate something like this?

        I was thinking something like this:

        Unit Test (UT Master) - code replicated from production
        nightly (never used for testing)

        How could I facilitate users creating a copy on demand of
        UTMaster using something like:

        VMWare or
        Delphix or
        Docker or

        I'm basically looking to see what options are to accomplish
        something like this.

        I was thinking if we stood up UT Master on a VM, we could
        snap the VM into another copy for a specific developer on


Other related posts: